Mt. Eden Computer Essentials & Applications I Classes

Excel YOYO 1...

You are on your own to complete the following exercise:

1. In Excel, start with a new blank worksheet.
   
   
2. In cell A2 type Monday and distribute the days down the A column until you reach Sunday in cell A8 (or you could type them in). See Figure 1==>
   
   
3. Adjust (or double-click on) the line between A and B column headers until Wednesday fits in cell A4. See Figure 1==>
   
   
4. In cell B1 type Week 1.
   
   
5. in cells B2 to B8 type
   1. 5
   2. 6.5
   3. 4
   4. 3.5
   5. 4
   6. none
   7. none
      
      
6. Distribute Week 1 in cell B1 to cell C1 so it reads Week 2 in that cell.
   
   
7. in cells C2 to C8 type
   1. 4.5
   2. 5
   3. 5
   4. 4.5
   5. 6
   6. none
   7. none
      
      
8. In cell A10 type: Total Hours.
   
   
9. Click cell B10 and use AutoSum to calculate the total hours for week 1.
   
   
10. Click cell C10 and use AutoSum to calculate the total hours for week 2.
    
    
11. In cell C3, change 5 to 6.
    
    
12. DONE.

WHEN YOU ARE DONE...

TURN IT IN THROUGH GOOGLE CLASSROOM.

This assignment is worth 15 Participation points.