To begin, please enter the following five (5) equations into cells A1 to A5. Do not enter the number labels, just enter the equation itself. If you enter them properly, you should get the answers in the cells when you hit return.
| 1) | 2*6+3-4/2-5+20/5*3+50 |
| 2) | (3+3-5)*(15-5)*10-99 |
| 3) | 50/5-7*2+11+3*10/2-2+6*5 |
| 4) | 4+5-7+8*5-12*2/8+6-3+20/2 |
| 5) | 9*9-30/3+5-6+7-2+9*9 |
Second, type in the following spreadsheet below the equations, 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
When you are done, raise your hand to be graded. Good Luck!! - Mr. S
0 Comments