Creating Your Own Spreadsheet

EXERCISE 6

CREATING YOUR OWN SPREADSHEET

Assume you have completed four assignments for both software applications Word and Excel. Assume each assignment was marked out of 30. Create a spreadsheet to calculate each assignment percent, and calculate your average Word Percent and average Excel Percent. Spreadsheet Title

Total Mark: Assignment 1 Assignment 2 Assignment 3 Assignment 4 Average Percents:

Word Word Excel Excel Assignment Assignment Assignment Assignment Mark Percent Mark Percent 30 % 30 % ? # ? # ? # ? # ? # ? # ? # ? # #

#

Instructions: 1. Start a new spreadsheet file and key the values and labels provided. • Insert an appropriate spreadsheet title • Enter a numeric value in the cells where the question mark (?) appears using realistic marks • Use appropriate formulae/functions in the cells where the number sign (#) appears •

To calculate percent, divide the assignment mark by the total mark. Use an absolute cell address in your formula

•

To calculate average use the average function

2. Format the spreadsheet values and labels appropriately. 3. Center the spreadsheet vertically and horizontally on a page. 4. Create an appropriate footer for your printout 5. Save the spreadsheet using an appropriate filename