Lesson 5: Inserting Formula and Functions

Check Your Progress

Activity 1

  1. STEP 1. Create a new file and enter the data on the worksheet below.
  2. STEP 2. Compute the Average grade.
  3. STEP 3. Save your file as "CLASS RECORD 1".
  4. STEP 4. Close your file.

Activity 2

  1. What is the Average grade on the First Quarter?
  2. What is the Average grade on the Second Quarter?
  3. What is the Average grade on the Third Quarter?
  4. What is the Average grade on the Fourth Quarter?
  5. What is the Minimum Grade?
  6. What is the Maximum Grade?
  7. Who got the highest average?
  8. Who got the lowest average?
  9. What is the Average grade of Grayda, John Lloyd?
  10. Who got the second highest average?