Multiple Choice
Case 3-1
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 2016. 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
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
Q27: The _ is the middle value from
Q47: Not all functions have arguments,and some functions
Q58: A(n)_ reference contains both relative and absolute
Q63: An <span class="ql-formula" data-value="\underline {
Q66: Case 3-2<br>Susan is in charge of the
Q67: Case 3-2<br>Susan is in charge of the
Q83: In the following formula: =IF(A1="YES","DONE","RESTART"),what happens if
Q94: One way to perform a _ is
Q96: _ arguments may provide more control over