Microsoft
77-420 · Question #1
Formula. Find the average of each student's homework scores. Cell range C2:C29. Use Function AVERAGE Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Step 1: Click cell C7, and then click the Insert Function Button. Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK. Step 3: Click on the Section 3 tab (left bottom part of the window). Step 4: Locate the data for the…
Prepare the Technician Computer Environment
Question
Formula. Find the average of each student's homework scores. Cell range C2:C29. Use Function AVERAGE Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Explanation
Step 1: Click cell C7, and then click the Insert Function Button. Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK. Step 3: Click on the Section 3 tab (left bottom part of the window). Step 4: Locate the data for the first student. This will be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.
Topics
#AVERAGE function#spreadsheet formula#named range#worksheet reference
Community Discussion
No community discussion yet for this question.