80
1. Insert a page
break in a
spreadsheet.
C
ompanies generate income, expense, and other fi nancial reports
periodically throughout the fi scal year, culminati ng in end-of-the-year
fi nancial statements that provide a snapshot of the company's fi nancial
situati on at that ti me. It is important for companies to maintain correct
fi nancial data so that the fi nancial reports are accurate.
The following acti vity illustrates how spreadsheets can be used to record
the expenses of a small company, Mike's Bike Rentals, so that the owner can
analyze the expenses of the last six months of 2010 compared to the same
period in 2009, and perhaps devise some ways to cut operati ng costs.
34
1. Create a NEW spreadsheet.
Unless otherwise stated, the font should be 10 point Arial.
2. Type the data as shown. To save ti me, copy and paste the data in cells A1 A23
to cells A28 A50.
3. Enter your name as the accountant in cells B7 and B34.
4. Format the width of column A to 22.0 and left align.
5. Format the width of columns B H to 14.0 and right align.
6. Bold cells D5 and D32.
7. Bold rows 1, 5, 7, 23, 28, 32, 34, and 50.
8. Bold and underline rows 11 and 38.
9. Format cells B13 H23 and B40 H50 as numbers displaying 0 decimal places
with a comma separator.
10. In cells H13 and H40, enter SUM formulas to compute the total for each
expense item.
11. Use the AutoFill feature to copy the formulas in cells H13 and H40 down to
compute the totals of the other expenses.
12. In cells H23 and H50, use the AutoSum feature to compute the total expenses
for the six month period.
13. Bold column H.
14. At cell A28, insert a Page Break. This will force each expense report to print on
a separate page.
15. Display formulas in your spreadsheet by using <CTRL> + ` to check for accuracy.
16. Carefully proofread your work for accuracy.
17. Save the spreadsheet as EXPENSE REPORT.
18. Analyze the changes made to the data in the spreadsheet.
Expense Report
NEW SKILL
ACTIVITY
For Evaluation Purposes Only