Microsoft Excel 2013 (77-420) Free Practice Test
Question 1
CORRECT TEXT
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.
Use the following steps to complete this task in
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.
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.
Use the following steps to complete this task in
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.
Correct 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:
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:
Question 2
CORRECT TEXT
Hide columns.
Column A.
Columns O through R.
Hide columns.
Column A.
Columns O through R.
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Right-click on the A column header, and select Hide from the context menu.
Step 2:Click on the O columns header, and then Shift-click on the R Column Header. Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.
Explanation:
Step 1:Right-click on the A column header, and select Hide from the context menu.
Step 2:Click on the O columns header, and then Shift-click on the R Column Header. Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.
Question 3
CORRECT TEXT
Create a new named range.
Cell range C7:C29.
Name: "Homework"
Create a new named range.
Cell range C7:C29.
Name: "Homework"
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell C7, and then Shift-click cell C29
Step 2:Click the Name box at the left end of the formula bar.
Step 3:Type: Homework. Press ENTER.
Explanation:
Step 1:Click cell C7, and then Shift-click cell C29
Step 2:Click the Name box at the left end of the formula bar.
Step 3:Type: Homework. Press ENTER.