Jane has just started a job at a local shoe retailer. One of her first tasks was to compile the above worksheet, showing the first quarter. Her boss has reviewed the worksheet and asked her to add some functions and formulas to the worksheet.
-What formula would you write to find the largest value in cells E11:E14?
A) =MAXIMUM(E11:E14)
B) =MAX(E11:E14)
C) MAX(E11:E14)
D) MIN(E11:E14)

Question

Jane has just started a job at a local shoe retailer. One of her first tasks was to compile the above worksheet, showing the first quarter. Her boss has reviewed the worksheet and asked her to add some functions and formulas to the worksheet.
-What formula would you write to find the largest value in cells E11:E14?
A) =MAXIMUM(E11:E14) 
B) =MAX(E11:E14) 
C) MAX(E11:E14) 
D) MIN(E11:E14)

Quizplus · Accepted Answer

The function to find the largest value in a range of cells is =MAX(). Therefore, option B is the correct formula to use to find the largest value in cells E11:E14. Option A is incorrect because there is no function called =MAXIMUM(). Option C is also incorrect because it is missing the equal sign before the function. Option D is incorrect because it would give the smallest value in the range, not the largest.

Jane Has Just Started a Job at a Local Shoe