How To Pass New 77-427 Exam: PassLeader now is offering the latest and 100 percent pass ensure 77-427 80q braindump, we guarantee our 77-427 80q exam questions are the newest and most accurate, which will help you passing 77-427 exam easily and quickly. Visit the our site passleader.com and get the free 77-427 exam vce and pdf dumps and FREE VCE PLAYER!
Vendor: Microsoft
Exam Code: 77-427
Exam Name: Microsoft Excel 2013 Expert Part 1
QUESTION 1
You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?
A. Goal Seek
B. Data table
C. Scenario
D. Solver add-in
Answer: C
QUESTION 2
Which of the following is used to display a trend based on adjacent data in a clear and compact graphical representation by taking up a small amount of space?
A. Trendline
B. Line chart
C. Sparkline
D. Backstage view
Answer: C
QUESTION 3
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2013 for creating various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided in the B7 cell. Which of the following formulas will provide the required result?
A. COUNTIF(B2:C5,”=Yes”)
B. COUNTIFS(B2:C5,”=Yes”)
C. COUNTIF(B2:B5,”=Yes”,C2:C5,”=Yes”)
D. COUNTIFS(B2:B5,”=Yes”,C2:C5,”=Yes”)
Answer: D
QUESTION 4
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?
A. Mark as Final
B. Encrypt with Password
C. Protect Current Sheet
D. Protect Workbook Structure
Answer: C
QUESTION 5
Microsoft Excel 2013. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task? Each correct answer represents a part of the solution. Choose all that apply.
A. Click on the ‘Macros’ icon in the ‘Developer’ tab under the ‘Code’ category to run a Macro.
B. The Macro will be run in any worksheet of the Workbook.
C. Put the workbook in a trusted location.
D. The Macro dialogue box appears on the screen which contains a list of Macros in it. Select the Macro to run and click the Run button.
E. Run the created Macro by using the shortcut key specified while creating the Macro.
Answer: ABDE
QUESTION 6
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data. Which of the following options will you choose to accomplish the task?
A. Mark as Final
B. Protect Current Sheet
C. Encrypt with Password
D. Protect Workbook Structure
Answer: D
QUESTION 7
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2013. Rick wants to trace the project with the actual requirements. For this purpose, he is required to compare month to month, actual v budget, quarter to quarter, year to year variances. Which of the following will Rick use to accomplish the task?
A. Evaluate Formula
B. Accounting template
C. Form control
D. Trust Center
Answer: B
QUESTION 8
You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have a formula that uses one or two variables or multiple formulas that all use one common variable. You want to examine a range of possibilities at a glance. Which of the following will you use to accomplish the task?
A. Goal Seek
B. Solver add-in
C. Data table
D. Scenario
Answer: C