77-420 Online Practice Questions and Answers

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell A1.

Step 2:Click the Data tab, and click the From Text button.

The Text Import Wizard starts.

Step 3:Make sure Delimited is select, and click Next.

Step 4:Make sure Delimiters: Tab is selected. Then click Next.

Step 5:Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click the File menu.

Step 2:Select Info (if necessary) and click Show All Properties,

Step 3:In the Subject textbox type: HomeWork and click theReturn button.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click on the Chart.

Step 2:Click on the Chart title.

Step 3:Changeby typingthe title to:All Zero Scores

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell B3.

Step 2:Shift-click cell B25

Step 3:Right-click somewhere in the B3-B25 cell range, and choose Format Cells from the context menu.

Step 4:In the Format Cells dialog box click the Alignment Tab, change Horizontal: to Right (Indent), change Indent: to 1, and then click the OK button.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell A2.

Step 2:On the Insert tab, in the Links group, click Hyperlink.

Step 3:In the Insert Hyperlink dialog box, in the Type the cell reference: type A3, select Cell Reference 'Section 3', and click OK.

Correct Answer: 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:

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:

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell C3

Step 2:Shift-Click cell S25.

Step 3:On the Home tab, under Format, choose Conditional Formatting, and choose New Rule...

Step 4:In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green. Step 5:In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click in cell B3, and then shift-click in cell S25.

Step 2:On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Step 3:Still in the Page Layout tab, Enable the Gridlines Print option.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1: Click cellE7, and the click the Insert Function Button.

Step 2: In the Insert Function dialog box select Category Statistical, select function MAX, 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 cellE7 downwards until cellE29.

Result will be like:

Correct Answer: 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.