If you wanted to find the largest number from cells E3 to E6, what formula would you use?=LARGE(E3:E6)=MAX(E3:E6)=MIN(E3-E6)

Which Excel formula would one use to find the largest number in the field that match specific conditions that you provide?=FIELDMAX=DMAX=MAX

Which Excel function is used to find the largest value in a range of cells?a) =SUMb) =MAXc) SUMd) MAX

What is the correct way to write a function that will find the greatest value in the range of cells from G60 to G100 in a spreadsheet?

What function would you use to find the highest value in a range of cells?Answer areaMAX()SUM()MIN()AVG()

Which formula below will extract the third largest price from the data set above?=LARGE(3,C3:C7)=LARGE(D3:D7,3)=SMALL(C3:C7,3)=LARGE(C3:C7,C6)