File Info
| Exam | Excel 2013 |
| Number | 77-420 |
| File Name | Microsoft.77-420.TestKing.2018-06-19.14q.tqb |
| Size | 3 MB |
| Posted | Jun 19, 2018 |
| Download | Microsoft.77-420.TestKing.2018-06-19.14q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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.
