Activity Two April 7th/8th 10 points
Due: Before Wednesday, April 14th OR Thursday, April 15th
Remember: You have a quiz covering Excel on April 19th/20th
The intent of this activity is to become familiar with MS Excel.
1. Start the Microsoft Excel application. The Program starts with a new worksheet.
2. Save your file as “Act2_lab section number_ last name” in your Home directory on
ONID.
3. Create a worksheet that looks like the one below. You don’t have to use these names
or grades, but populate seven rows and three columns with data:
Students Grade Sheet
Act 1 Act 2 Act 3
Jones 10 8 6
Smith 5 10 7
Adams 6 9 9
Mason 8 7 8
Simmons 3 6 6
Cooper 9 8 5
Jackson 10 9 10
4. Remember to save your file after every change (often at least).
5. Add labels for activities 4 and 5 in columns E and F.
6. Add data in the columns that you just created.
7. Insert a Column before Activity 3 and label it Weighted Total.
8. You want to add 20% of Act 1 and 80% of Act 2 to make this weighted total.
9. Create the formula for the first student in the appropriate cell (a formula starts with an
"=" sign, refer to your book for further information).
10. To complete the spreadsheet for all rows, highlight the first cell where you have
written the formula, and then the cells that will also have the same calculations.
Under “Edit,” find “Fill” and “Down.” This will copy the same formula or data to all
highlighted cells.
11. In column H, add a label for "Total."
12. In the first data row in column H, create a formula to calculate the sum of the activity
grades. Use edit, fill, down, to copy the formula to the rest of the rows.
13. Add two more columns after “Total” labeled “Average” and “Minimum.”
