Sunday, January 27, 2013

IT Apps - Exercise 4


Type in the following spreadsheet, and format it to look like the sample below.
1      Type in all text and numbers shown in the spreadsheet below.
2      Format all numbers with appropriate formats.
3      Center the spreadsheet heading 'Total Sales for the Month of November' across the spreadsheet.
4      Format all text as displayed in the sample below, including the rotated text labels.
5      Create formulas to display a total quantity for each fruit.
6      Create formulas to calculate the total sales to each fruit.
7      Apply all borders and shading (color) shown in the sample below, feel free to experiment with your own color schemes.


No comments:

Post a Comment