Excel Formulas Practice
Download the Files to complete the activity:
Wingtip Worksheet
Complete the following task:
1. OPEN the Formula Practice workbook.
2. SAVE the document in your flash drive. Make sure you are working in the Wingtip worksheet
3. In E4, create formula that totals the values for January, February, and March for the Outdoor products. Copy that formula to cells E5:E10.
5. In F4, create a formula that calculates the bonus amount to be paid by multiplying the value in E4 by the value in B12. Use an absolute reference to cell B12.
6. Copy the formula from F4 to F5:F10.
7. SAVE the document.
Check Worksheet
1. Go to the Check worksheet
2. In cell G6, enter a formula that displays the value in G5 minus the value in E6, plus the value in F6.
3. Copy the formula from G6 to G7:G20.
4. In row 10, enter the following new transaction:
Number: 1034
Date: 1/5/2015
Description: Groceries
Debit: $55.12
5. SAVE the workbook.
CLOSE the workbook. Exit Excel.
| Please enter your name. (optional) |
|
|
|
