77-420 무료 덤프문제 온라인 액세스

CORRECT TEXT
Sort and Filter.
Apply a sort and a filter to the table.
Cell range B6:F29
Sort Column Zero Scores Order Largest to Smallest Column IDs Order Smallest to Largest Filter Hide students ids with no zero scores.

정답:

Use the following steps to complete this task in
Explanation:
Step 1:Click a cell in the table.
Step 2:On the Home tab select the Sort & Filter button, and select Custom sort (needed to
sort on more than one column at a time).

Step 3:In the Sort dialog box select Sort by: Zero Scores, Order: Largest to Smallest, and click the Add Level button.

Step 4:Select then by: Ids, Order: Smallest to Largest, and click the OK button.

Step 5:Click the Zero Scores column header header arrow, select Number Filters, and clickDoes not Equal.

Step 6: In the Custom AutoFilter enter 0, and click OK The result will look like:

CORRECT TEXT
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"

정답:

Use the following steps to complete this task in
Explanation:
Step 1:Click cell C7, and the click the Insert Function Button.

Step 2:In the Insert Function dialog box select Category Statistical, select function AVERAGE, 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 C7 downwards until cell C29.

Result will be like:

CORRECT TEXT
Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows
Horizontal Axis Labels: "IDs" column in table
Series 1: "Zero Scores" column in table.

정답:

Use the following steps to complete this task in
Explanation:
Step 1:Click in a cellin the data table, and then click on the INSERT tab.

b
Step 2:Click Insert Column Chart, and select 3-D Clustered Column.

Step 3:If necessary move the chart to the right of the table.
Step 4:Click the Select Data button.

Step 5:In the Select Data Source dialog box click the Switch Row/Column button, Deselect everything except IDs for Horizontal Axis Labels, deselect everything excepts Series1 for Legend Entries (series), and click OK.

CORRECT TEXT
Crop the picture. Microsoft 77-420 : Practice Test
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.

정답:

Use the following steps to complete this task in
Explanation:
Step 1:Click on the picture.
Step 2:In the Format menu (which is displayedautomatically) click the Crop Command,
select Crop to Shape, and click Snip Same Side Corner Rectangle.