- using the appropriate formulae, generate the Projected income per 10 students (Fee multiplied by 10) for the first course. Replicate this formula for each of the other courses.
- For the formula, use the cell reference *10, e.g.: C6*10
- Using the appropriate formula, generate a total in the Totals row for Projected Income from all courses.
- Use AutoSum to generate the formula. Zeros will appear in cells where there is no data to work with. Delete them.
- Save the spreadsheet with the name Redeemed College Courses within your own folder.
Friday, 13 December 2013
Spreadsheet Project 1
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment