Microsoft Excel 2013 Expert Part One - 77-427 FREE EXAM DUMPS QUESTIONS & ANSWERS

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?
Correct Answer: D Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You are trying to intersect two ranges that do not intersect each
other. Which of the following errors will be occurred in this situation?
Correct Answer: C Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

You work as an Office Assistant for Tech Perfect Inc.
You are working in a spreadsheet as shown below:
You want to use Excel Transpose Function for copying the contents of cells B1:B3 into cells A5:C5.
You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel #VALUE! error message because the cells are working independently and the function will not work for each individual cell. Therefore, it is required to make the cells A5:C5 work together as an ARRAY. For this purpose, you are required to use an array formula. Which of the following steps will you take to input Excel array formulas in the spreadsheet?
Each correct answer represents a part of the solution. Choose all that apply.
Correct Answer: A,B,C Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?
Correct Answer: A Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2013.
Your workbook includes several worksheets as shown in the image given below:
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?
Correct Answer: B Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
Correct Answer: A,B,D Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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?
Correct Answer: D Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
0
0
0
10