Excel SpreedSheet #1
Premuc
new_excel_project_.docxCreate 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. |
|
|
||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
