Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

a. Average
b. Count
c. %Total
d. Sum

A jewelry designer creates an excel sheet to list different items he sold on the previous day. Cells A1, B1, C1, and D1 contain headings—Order ID, Unit price, and Quantity, respectively. Cells A2 to A6 list the order ID for items sold— 10001,10002,10003,10004, and 10005, respectively. Cells B2 to B6 list their respective unit price—$15, $18.5, $12, $9.5, and $6. Cells C2 to C6 list their respective quantities—20, 32, 16, 15, and 10. If he enters the formula in cell D1 as: =VLOOKUP (10005, A1: H3, 3, FALSE), what will the formula return?

a. $12
b. 10
c. $6
d. 10003

Which of the following lets you fill a cell with only specific elements of a copied cell?

a. SHEET
b. relative cell reference
c. argument
d. Auto Fill Options button
e. mode indicator

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59. Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B?

a. =IF(B2<59,"F",IF(B2<69,"D",IF(B2<79,"C",IF(B2<89, "B","A"))))
b. =IF(B2=0-59,"F",IF(B2=60-69,"D",IF(B2=70- 79,"C",IF(B2=80-89,"B",IF(B2=90-100,"A"))))
c. =IF(B2</=59,"F",IF(B2</=69,"D",IF(B2</=79,"C",IF( B2</=89,"B", IF(B2</=100"A"))))
d. =IF(B2<60,"F",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90, "B","A"))))

What is the correct formula to insert the date January 12, 1998 into a cell?

1. =DATE(1/12/1998)
2. =DATE(12-1-1998)
3. =DATE(1998,1,12)
4. =DATE(1998,12,1)

Arlo wants to use goal seek to answer "what if" questions in a file. To do this, he clicks the cell in the spreadsheet that he wants to change, then selects the "X" button from the Data tab and selects Goal seek... from the drop down menu. What is X in the procedure?

a. Relationships
b. Data Validation
c. Consolidate
d. What-if Analysis

Which of the following functions would you use to calculate the arithmetic mean of a price list?

a. AVERAGE
b. MAX
c. SUM
d. COUNT

Where can you see a brief description of a selected function?

a. Insert Function dialog box
b. Insert dialog box
c. Insert tab
d. Formula bar

Which formula can you use to extract the month from the date in cell F5: 2016 July 8th?

1. =MONTH("F5")
2. =MONTH(DATE(2016,7,0))
3. =MONTH(DAY(2016,7,0))
4. =MONTH(F5)

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

1. If it needs landscape orientation.
2. If it needs a relative cell reference.
3. If it needs an absolute cell reference.
4. If it needs a function