In the excel work book you created for Exercise 1, create a sheet tab labeled Exercise 2.

Create a spreadsheet using the following information.  You are the owner of a fruit store, you have owned the fruit store for one complete year. Use the data below to construct a spreadsheet to display the sales figures for the first year of operation of your fruit store.

 

1) Enter the raw data below, applying as many presentation Features (Font, Font Size, Font Colour, Number Formats and Colour, Cell Shading, Text Rotation, etc) to it as you wish.
2) Apply appropriate number formats to your numbers.
3) Center your spreadsheet horizontally on the page
4) Give your spreadsheet an appropriate title and center it across your spreadsheet.
5) Select the best page orientation for your spreadsheet.
6) Adjust the column width and row height to suit the layout you have selected.
7) Create formula's to calculate totals for each month.
8) Create formula's to calculate totals for each fruit item.
9) Setup an appropriate header for this spreadsheet.
10) Setup a page number for this spreadsheet and place it in the footer.
    

 


  Apples      Bananas     
  January

2298

  January

6899.21

 
  February

3512.56

  February

6755.33

 
  March

4929.67

  March

6541

 
  April

5883

  April

6032.79

 
  May

6237.77

  May

5822.72

 
  June

6566.78

  June

5968

 
  July

6213.88

  July

6333.33

 
  August

6001

  August

6544.11

 
  September

5799.69

  September

6845.45

 
  October

5527

  October

7000.01

 
  November

3914.55

  November

7216.27

 
  December

2564.99

  December

7283

 
                
  Oranges       Kiwifruit     
  January

4923.88

  January

3349.12

 
  February

4444.99

  February

3899.87

 
  March

3851

  March

4336

 
  April

3399.88

  April

4892.01

 
  May

3020.03

  May

5217.97

 
  June

3411.89

  June

4764.10

 
  July

3567.09

  July

4523.22

 
  August

3999.91

  August

4501

 
  September

4255.88

  September

4219.91

 
  October

4873

  October

3877.49

 
  November

5214.95

  November

3712.12

 
  December

5521.17

  December

3555.56

 
               
  Pears       Grapes     
  January

3310

  January

4847.23

 
  February

4524.65

  February

5361.58

 
  March

5992.76

  March

5899.24

 
  April

6961.44

  April

6853.01

 
  May

7447

  May

5471.34

 
  June

7583.87

  June

4534.22

 
  July

7393

  July

4222.83

 
  August

7110.10

  August

4137

 
  September

6637.96

  September

3998

 
  October

6275

  October

3556.36

 
  November

4841.71

  November

3111.44

 
  December

3456.11

  December

2789.74

 
               
  Peaches       Nectarines     
  January

5902.44

  January

5310

 
  February

7234.12

  February

7772.71

 
  March

5110

  March

8219

 
  April

3521.87

  April

6989.33

 
  May

1276.34

  May

4535.52

 
  June

1227.30

  June

1873.38

 
  July

1199.99

  July

1198

 
  August

1242.09

  August

1241.63

 
  September

1189.73

  September

1187.57

 
  October

1195.42

  October

1222.21

 
  November

1213.14

  November

1432.43

 
  December

1887.49

  December

2137.78