To find the second smallest or largest number, we can use the functions LARGE or SMALL functions in Microsoft Excel.
MS Excel is a generally used Microsoft Office application. It is a spreadsheet application that is used to store and examine numerical data.
First of all select the invoice column, use the functions LARGE or SMALL functions. Then these functions take quite a number of values, then the k value. If you use k value of 1, the LARGE characteristic is precisely like a MAX: = LARGE(B2:B100,1).
Thus,The actual value in LARGE is the capacity to ask for the second biggest value using = LARGE(B2:B100,2).
Learn more about Excel here:
https://brainly.com/question/25879801
#SPJ1
