Baic Spreedsheet Concepts

Only available on StudyMode
  • Download(s) : 59
  • Published : April 28, 2013
Open Document
Text Preview
Exercise 1: Sales for the Month
 Type in the following spreadsheet, 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 for the Month' across the spreadsheet. 4) Format all text as displayed in the sample below.
5) Create formula's to display a total for each sales rep.
6) Create formula's to display a total for each product.
7) Create a formula to calculate the total sales for all sales rep's for the month. [pic]
Exercise 2: Sales And Produce Department
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 . [pic]

Exercise 3: Mike's Stationary Order
Instructions
1) Type in all text and numbers shown in the spreadsheet below. 2) Format all numbers with appropriate format's.
3) Center the spreadsheet heading 'Mike's Stationery Order' across the spreadsheet. 4) Format all text as displayed in the sample below, including the rotated text labels. 5) Create formula's to display a total for each stationery item ordered. 6) Create a formula to calculate the total for the stationery order. [pic]

Exercise 4: Travel Expenses For The Month Of May
Instructions
1) Type in all text and numbers shown in the spreadsheet below. 2) Format all numbers with appropriate format's).
3) Center the spreadsheet heading 'Travel Expenses For The Month Of May' across the spreadsheet. 4) Format all text as displayed in the sample below, including the rotated text labels. 5) Create formula's to display a total for each Sales...
tracking img