# A formula containing the entry =\$B3 is copied to a cell one column to the right and two rows down

A formula containing the entry =\$B3 is copied to a cell one column to the right and two rows down 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. =\$C52. 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()_B103. 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 orderB. Range D12:D18 are in descending orderC. Range D12:D18 contain multiple valuesD. The third column of the lookup tale must be text only5. 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.606. What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?A. =average(B5:F5)B. =Sum(B5:F5)/5C. =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 reference8. When you start =AV, what displays a list of functions and defined names?A. Formula auto completeB. Function Screen tipC. Inser function dialog boxD. Function arguments dialog box9.Which of the following is not an acceptable range name?A. Goal for 2016 B. FICA C. Test_Weight D. Target_201510. the function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?A. Periodic Interest RateB. APRC.Loan amountD.Number of payment periods