Excel Chapter 2
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)? 1. 60 2. 40 3. 10 4. 90
90
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? 1. =$B3 2. =B3 3. =$C5 4. =$B5
=$B5
What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5? 1. =COUNT(B5:F5) 2. =SUM(B5:F5)/5 3. =MEDIAN(B5:F5) 4. =AVERAGE(B5:F5)
=AVERAGE(B5:F5)
Which of the following is not an appropriate use of the SUM function? 1. =SUM(D15-C15) 2. =SUM(F1:G10) 3. =SUM(A8:A15,D8:D15) 4. =SUM(B3:B45)
=SUM(D15-C15)
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 is formatted with Number Format? 1. =CURRENT()-B10 2. =TODAY()+NOW() 3. =TODAY()-B10 4. =TODAY()
=TODAY()-B10
If cell D15 contains the formula =$C$5*D$15, what is the D15 in the formula? 1. Circular reference 2. Relative reference 3. Range name 4. Absolute reference
Circular reference
When you start =AV, what displays a list of functions and defined names? 1. Function ScreenTip 2. Formula AutoComplete 3. Function Arguments dialog box 4. Insert Function dialog box
Formula AutoComplete
Which of the following is not an acceptable range name? 1. Goal for 2016 2. Target_2015 3. Test_Weight 4. FICA
Goal for 2016
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5? 1. Loan amount 2. Number of payment periods 3. Periodic interest rate 4. APR
Periodic interest rate
Given the function =VLOOKUP(C6,$D$12:$F$18,3), the entries in: 1. Range D12:D18 contain multiple values in each cell. 2. The third column of the lookup table must be text only. 3. Range D12:D18 are in descending order. 4. Range D12:D18 are in ascending order.
Range D12:D18 are in ascending order.
