Activity Two October 8th/9th 10 points
Due: Before Wednesday, October 15th
Remember: You have a quiz on Excel October 20/21
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.
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.”
