1. A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down . How will the entry appear in its new location? A. =$B$5 B. =$B3 C. =B3 D. =$C5

2. Cell B10 contains a date, such as 1/1/2016. which formula will determine how many days are between that date and the current date, given that the cell containing the formula withNumber Format. A. =Today()-B10. B.=Today()+NOW() C. =TODAY() D. =Current()_B10

3. Which of the following is not appropriate use of the SUM function?

A. =SUM(D15-C15) B. =SUM(B3:B45) C. =SUM(F1:G10) D. =SUM(A8:A15),D8:D15)

4. Given the function =VLOOKUP(C6,$D$12:$F$18,3), the entries in:

A. Range D12:D18 are in ascending order

B. Range D12:D18 are in descending order

C. Range D12:D18 contain multiple values

D. The third column of the lookup tale must be text only

5. Given that cells A1,A2 and A3 contain values 2, 3, and 10, respectively, and B6,C6 and D6 contain values 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6*A1,D6*A2)?

A. 90 B. 10 C. 40 D.60

6. What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

A. =average(B5:F5)

B. =Sum(B5:F5)/5

C. =Medium(B5:F5)

D. =Count(B5:F5)

7. In the formula =$C$5*D$15, what is the D15 in the formula?

A. Mixed cell reference B. Absolute cell reference C. Relative cell reference D. cell reference

8. When you start =AV, what displays a list of functions and defined names?

A. Formula auto complete

B. Function Screen tip

C. Inser function dialog box

D. Function arguments dialog box

9.Which of the following is not an acceptable range name?

A. Goal for 2016 B. FICA C. Test_Weight D. Target_2015

10. the function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?

A. Periodic Interest Rate

B. APR

C.Loan amount

D.Number of payment periods