Excel SpreedSheet #1

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 Color, Number Formats and Color, 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

 

 

 

 

 

 

Name

 

Mid-term

Final

Total

Grade

Description

 

Virak

 

14

45

59

       

Soa

 

12

34

46

       

Vibol

 

12

26

38

       

Theary

 

14

25

39

       

Sokha

 

14

40

54

       

1. By using if function, determine the student grade based on the following rules:

 

Total score>=90 then grade A

           

90>Total score>=80 then grade B

           

80>Total score>=70 then then grade C

         

70>Total score>=60 then grade D

           

60>Total score>=50 then grade E

           

Else then grade F

             

2. By using if function, display the word “Pass” or “Fail” under the Description column

Students who pass need to have total score greater than or equal to 50.

   

Assignment Solutions