최신 77-420 무료덤프 - Microsoft Excel 2013
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.
정답:
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:
CORRECT TEXT
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style
정답:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell B6, and Shift-click cell F29.
Step 2:Click theInserttab, and click the Table button.
Step 3:In the Create Table dialog box click OK. Microsoft 77-420 : Practice Test
Step 4:In the Design tab, Table Styles select Table Style Medium 4.
Step 5:In the Design tab enable First Column.
Explanation:
Step 1:Click cell B6, and Shift-click cell F29.
Step 2:Click theInserttab, and click the Table button.
Step 3:In the Create Table dialog box click OK. Microsoft 77-420 : Practice Test
Step 4:In the Design tab, Table Styles select Table Style Medium 4.
Step 5:In the Design tab enable First Column.
CORRECT TEXT
Hide columns.
Column A.
Columns O through R.
Hide columns.
Column A.
Columns O through R.
정답:
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.