Microsoft Exam 77-420 Topic 4 Question 16 Discussion

Actual exam question for Microsoft's exam

Question #: 16
Topic #: 4

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.

AStep 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.
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:

Show Suggested Answer

Suggested Answer: A

by Willodean at Jun 27, 2022, 07:10 PM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!