Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year.
-Ellen wants to find out what her median monthly spending is.The monthly totals for her spending appear in the range A10:L10.Which of the following is NOT a way to enter the MEDIAN function into her database?
A)Type =MEDIAN(A10:L10) into an empty cell.
B)Select the range A10:L10, click the Quick Analysis button, click TOTALS, and then click Median.
C)Click the More Functions button in the Function Library group on the FORMULAS tab, point to Statistical, and then click MEDIAN.
D)Click the Insert Function button in the Function Library group on the FORMULAS tab, scroll the Select a function list, then click MEDIAN.

Question

Quizplus · Accepted Answer

Option B is not a valid way to enter the MEDIAN function as it only provides the option to calculate the total and not the median. Options A, C, and D are all valid ways to enter the MEDIAN function into the database.

Ellen Is a Recent College Graduate