Sunday, January 27, 2013

IT Apps - Exercise 3


Type in the following spreadsheet, and format it to look like the sample below.

1) Type in all text and numbers shown in the spreadsheet below.
2) Format all numbers as a currency.
3) Center the spreadsheet heading 'Sales and Produce Department' across the spreadsheet.
4) Format all text as displayed in the sample below.
5) Create formulas to display the average sales.
6) Create formulas to display total sales for each salesperson. 


No comments:

Post a Comment