Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q11: Lookup tables can be constructed for exact
Q12: TODAY is an example of a(n)_ function.
Q13: In the formula =IF(A1=B1,C1,C2),the result will be
Q14: Susan is in charge of the inventory
Q15: Explain what a logical function is and
Q17: Which of the following is a Math
Q18: A(n)_ operator is a symbol that indicates
Q19: Which of the following is not a
Q20: MATCHING<br>Identify the letter of the choice that
Q21: =ROUND(AVERAGE(A1:A100),2)is an example of a(n)_ function.<br>A)complex<br>B)logical<br>C)absolute<br>D)nested