Download Excel 2013.77-420.SelfTestEngine.2017-07-15.17q.tqb
| Vendor: | Microsoft |
| Exam Code: | 77-420 |
| Exam Name: | Excel 2013 |
| Date: | Jul 15, 2017 |
| File Size: | 4 MB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
Crop the picture.
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.
- Use the following steps to complete this task in 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 2
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
- Use the following steps to complete this task in 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.
Question 3
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
- Use the following steps to complete this task in explanation.
Correct answer: A
Explanation:
Step 1: Click cell C7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, 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 cell C7 downwards until cell C29.
Result will be like: Step 1: Click cell C7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGE, 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 cell C7 downwards until cell C29.
Result will be like:
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!