Practice Test #3–CLICK PRACTICE TEST ON LEFT

Test #3–CLICK REPORTED QUIZ ON RIGHT

LESSON 3 HANDS ON QUIZ

excel section 3 quiz

1. Change the dates:
1. B9 should be 12/15/2016
2. B10 should be 12/16/2016
3. B11 should be 12/17/2016
4. B12 should be 12/18/2016
5. B13 should be 12/19/2016
6. B14 should be 12/20/2016
2. Copy the function in cell G9 all the way down to G14
3. Be sure the US dollar amounts with two decimal places is in place from E8 to G20
4. Enter the following additional transactions:
1. Row 12–check # 103, date 1/31/2017, payee Car Wash, check amount 40.00
2. Row 13–check #104, date 2/1/2017, payee Bellevue State Bank, check amount 2000.00
3. Row 14–deposit amount 500.00
5. Put another Thick Red Line at the bottom of row 14
6. In cell E15 find the total amount in checks
7. In cell F15 find the total amount in deposits
8. Create a bar chart that shows the Balance in the account on each day.
9. Put your name in the footer
10. Print answers & formulas–be sure each one fits on one page