Online Access Free 77-420 Practice Test

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.

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.

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.

Use the following steps to complete this task in
Explanation:
Step 1:Open the correct worksheet (Summary Worksheet).
Step 2:Click in cell B5.
Step 3:Click on the insert function button.

Step 4:In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.

Step 5:In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.