EDPM
Use the spreadsheet below to answer the following questions.ABCDEF1NamesMathEnglishScienceTotalAverage2James Blake89100903Tanisha Myrie6778564Keely Dowe9098905Henry Fayne100781006Sally Morris4565897Kelsie Rose8780768Total SUMMARY11Class Average12Highest Average13Lowest Average14Highest Math Score15Highest English Score1. Develop a formula to determine the: The first one is done for you:total grade for each student.= B2 + B3 + B4average grade for each studentaverage grade for Mathaverage grade for English average grade for Science2. Develop a function to determine the: One is done for youtotal grade for each student.= SUM (B2:B4)average grade for each studentaverage grade for Mathaverage grade for English average grade for Scienceclass average highest averagelowest averagehighest Math scorehighest English scoreBased on the activity, students will tell the difference between a formula and a function. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.