Basic Spreadsheets EX 2


	Basic Spreadsheets EX 2

Basic Spreadsheet Concepts Exercise 2

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

Instructions

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 formula's to display a total for each fruit.

6) Create formula's to display a total for each month.

7) Create a formula to calculate the total sales for all fruit items for the year to date