Intermediate Spreadsheet Concepts Exercise 2-2
Create a spreadsheet using the following information. You have been tasked with creating a spreadsheet to generate and stationery order for the month of March.
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 stationery item.
8)Create a formula to calculate the order total for the month.
9)Create a formula to calculate the Sales Tax component of the order. Note all prices include Sales Tax, and the value of Sales Tax is 7.5%.
10)Create a formula to calculate the net total (pre Sales Tax total) of the order for the month.
11)Setup an appropriate header for this spreadsheet.
12)Setup a page number for this spreadsheet and place it in the footer.
Create a spreadsheet using the following information. You have been tasked with creating a spreadsheet to generate and stationery order for the month of March.
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 stationery item.
8)Create a formula to calculate the order total for the month.
9)Create a formula to calculate the Sales Tax component of the order. Note all prices include Sales Tax, and the value of Sales Tax is 7.5%.
10)Create a formula to calculate the net total (pre Sales Tax total) of the order for the month.
11)Setup an appropriate header for this spreadsheet.
12)Setup a page number for this spreadsheet and place it in the footer.
|
