• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Spreadsheets

MEMO TO THE STAFF

Mr. McGee used his spreadsheet application to prepare a company

budget. The spreadsheet shown below presents Mr. McGee's budget

estimates for the next three months. Note that the cells in the

row across the top of the spreadsheet show the column titles

(the months) and the cells in the column on the left show the

row titles (the budget categories). The cells in the body of the

spreadsheet show the dollar estimates.

   Please note that the spreadsheet application has totaled the

estimates for each month. These totals are shown in the bottom row.

The application has also totaled the estimates for the three expense

categories. These totals are shown in the column on the right. The

grand total for the three months is shown in the bottom right-hand

cell.

Budget Estimates
 APRILMAYJUNETOTAL
Salaries$30,000$30,000$32,000$92,000
Equipment and Supplies$2,500$2,250$2,800$7,550
Overhead$6,000$6,000$6,000$18,000
Total$38,500$38,250$40,800$117,550



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint