Microsoft
77-420 · Question #7
Formula. Find the minimum homework score for each student. Cell range D7:D29 Number 1: minimum homework score for each student on "Section 3" worksheet.
Step 1: Click cell D7, and the click the Insert Function Button. Step 2: In the Insert Function dialog box select Category Statistical, select function MIN, 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…
Perform Operations with Formulas and Functions
Question
Formula.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum homework score for each student on "Section 3" worksheet.
Explanation
Step 1: Click cell D7, and the click the Insert Function Button. Step 2: In the Insert Function dialog box select Category Statistical, select function MIN, 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
#MIN function#cross-sheet reference#cell range#homework scores
Community Discussion
No community discussion yet for this question.