Microsoft 77-427 Excel 2013 Expert Part One Exam Practice Test

Page: 1 / 14
Total 62 questions

Question 1

You work as a Project Manager for Blue Well Inc. The company has a Windows-based network. You want to rename a worksheet as Important.

Which of the following steps will you take to accomplish the task?

Each correct answer represents a part of the solution. Choose all that apply.



Answer : B, C

Question 2

Rick works as an Office Assistant for Tech Perfect Inc. He is responsible for preparing sales reports of the company. He has created a sales report in a workbook of Excel 2013 and this workbook contains various worksheets as shown in the image given below:

Rick wants the sheet tabs of the sheets containing charts to appear in red color. Which of the following steps will Rick take to accomplish the task?



Answer : B

Question 3

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to delete the slicer. Which of the following steps can you take to accomplish the task?

Each correct answer represents a complete solution. Choose all that apply.



Answer : C, D

Question 4

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?



Answer : C

Question 5

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets change. She requests that you help her out to accomplish the task. Which of the following steps would you suggest she take in order to accomplish the task?



Answer : B

Page:    1 / 14   
Total 62 questions