Download Microsoft.77-420.TestKing.2018-06-19.14q.tqb
| Vendor: | Microsoft |
| Exam Code: | 77-420 |
| Exam Name: | Excel 2013 |
| Date: | Jun 19, 2018 |
| File Size: | 3 MB |
Demo Questions
Question 1
Insert a picture.
To the right of the data
File source Books.jpg
- See the explanation
Correct answer: A
Explanation:
Step 1: Click in a cell to the right of the data.Step 2: Click the INSERT tab, and then the Pictures command. Step 3: From the Insert Picture dialog box select the Books.jpg file. Step 1: Click in a cell to the right of the data.
Step 2: Click the INSERT tab, and then the Pictures command.
Step 3: From the Insert Picture dialog box select the Books.jpg file.
Question 2
Crop the picture.
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.
- See the explanation
Correct answer: A
Explanation:
Step 1: Click on the picture.Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle. Step 1: Click on the picture.
Step 2: In the Format menu (which is displayed automatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.
Question 3
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
- See the explanation
Correct answer: A
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. 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.
