77-420 Online Practice Questions and Answers

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: Open the correct worksheet(Section 3 Worksheet).

Step 2: Click in cell A2.

Step 3: Press down the Shift key and click in cell S2.

Step 4:On the Home tab, under Format, choose Format Cells.

Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.

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: Open the correct worksheet(Section 3 Worksheet).

Step 2: Click in cell A2.

Step 3: Press down the Shift key and click in cell S2.

Step 4:On the Home tab, under Format, scroll down until you see 40% . Accent3, and click on it.

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

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 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.

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

Step 1:Click Cell B2. Type the text: Date Step 2: Click cell C2. Type the text: 22-Aug Step 3: Click cell D2. Type the text: 29-Aug Step 4:Click cell C2, then shift-click cell D2.

Step 5:Copy until cell S2(by dragging from cell D2 to cell S2).

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

Step 1:Click the PAGE LAYOUT tab, click Colors, scroll down and select Slipstream.