Click to get it
Life time Calender


To create a worksheet listing the students' average grade, follow these steps:

1. Create a new worksheet and click A1.
2. Go to Data | Consolidate.
3. Select Average from the Function drop-down list.
4. Click the Collapse dialog button.
5. Select A1:B20 in Midterm Grades Sheet.
6. Click the Collapse dialog button and click Add.
7. Click the Collapse dialog button and Select A1:B20 in Final Grades Sheet.
8. Click the Collapse dialog button and click Add.
9. Under Use Labels In: select the Left Column check box. Click OK.

The students' average grades are now listed in the new worksheet.