Question

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.

Answer 1

Answer:

B

Explanation:

B. Select the range A1:L10, click the Quick Analysis button, click TOTALS, and then click Median.

Found it here might help with other questions on your test.

https://quizlet.com/386793520/cit105-excel-quiz-3-flash-cards/