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.
Correct Answer: Use the following steps to complete this task in explanation:
Explanation/Reference:
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 MAX, and click OK. Formula.
Find the minimum homework score for each student.
Answer:
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.
The function Arguments Dialog box appears:
Step 3: Click on the Section 3 tab (left bottom part of the window).
Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.
Step 5: Copy cell D7 downwards until cell D29.
Result will be like:
