Free Microsoft 77-420 Exam Dumps Questions & Answers

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.

Use the following steps to complete this task in
Explanation:
Step 1:Click on the chart.
Step 2:On the Design tab, in the Chart Styles group, click theStyle 7chart style.

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

Step 2: In the Insert Function dialog box select Category Statistical, select function COUNTIF, and click OK.

The function Arguments Dialog box appears: Microsoft 77-420 : Practice Test
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.Press Enter.

Step 5:In the Function Arguments Dialog box, in the Criteria field type: 0. Then click the OK button.

Step6: Copy cellF7 downwards until cellF29. Result will be like:

Use the following steps to complete this task in
Explanation:
Step 1:Click K2andClick on the insert function button.
Step 2:Select Category: Text, the CONCATENATE function, and click OK.

Step 3:In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the header of column F in the worksheet, press the enter Key

Step 4:Press the OK button in the Function Arguments dialog box. Microsoft 77-420 : Practice Test