Certbus > Microsoft > Microsoft Office Specialist > 77-427 > 77-427 Online Practice Questions and Answers

77-427 Online Practice Questions and Answers

Questions 4

You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different reports for your company. Drag and drop the appropriate methods for efficient data entry in front of their descriptions.

Select and Place:

Browse 62 Q&As
Questions 5

You work as a Sales Manager for Maini Industries. Your company manufactures and sells

construction equipment. You have to create a report that will show the highest selling items of

each month. The report will be in the following format:

In a workbook, you create a table named Item_table as shown below:

You fill in the required entries in the workbook.

For the third column of the sheet, you want to use formulas to fill in the values. You want the

cells in the third column to get automatically filled with the names corresponding to ItemID in the second column. You want the exact values to be filled in the column. You select the C2 cell in the third column.

Which of the following formulas will you enter in order to accomplish the task?

A. =VLOOKUP(B2,Item_table,2,FALSE)

B. =VLOOKUP(B2,Item_table,2,TRUE)

C. =VLOOKUP(2,Item_table,B2,FALSE)

D. =VLOOKUP(2,Item_table,B2,TRUE)

Browse 62 Q&As
Questions 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

Browse 62 Q&As
Questions 7

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?

A. Select the sheets containing charts. Select the Colors option in the Themes group on the Page Layout page.

B. Select the sheets containing charts. Right-click on the sheet tabs.

C. Select the sheets containing charts. Right-click on the sheet tabs. Choose the Sheet Color Option from the shortcut menu.

D. Select the sheets containing charts. Select the Effects option in the Themes group on the Page Layout page.

Browse 62 Q&As
Questions 8

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. 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.

A. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.

B. Click Insert Slicer in the Sort and Filter group on the Options tab.

C. Hold down CTRL, and then click the items on which you want to filter.

D. Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.

E. Click anywhere in the PivotTable report for which you want to create a slicer.

Browse 62 Q&As
Questions 9

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. Which of the following are the reasons that are causing the above problem?

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

A. You are inserting a new column, next to a column that is already formatted as text.

B. Excel is trying to reference an invalid cell.

C. The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.

D. You are referencing an entire worksheet by clicking on the grey square at the top left of the worksheet.

Browse 62 Q&As
Questions 10

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

Browse 62 Q&As
Questions 11

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

Browse 62 Q&As
Questions 12

Which of the following can be defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter?

A. Accounting templates

B. ActiveX controls

C. Form controls

D. Slicers

Browse 62 Q&As
Questions 13

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly 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 required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

A. Create a copy of a slicer connected with the PivotTable.

B. Create a slicer connected with the PivotTable.

C. Create a slicer by disabling Macros associated with the PivotTable.

D. Use an existing slicer connected with another PivotTable.

Browse 62 Q&As
Questions 14

You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team

Using Microsoft Excel. You want the report to appear in the following format:

You want the Remark column to be filled through a conditional formula. The criteria to give the remark is as follows:

If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the sales of the First Quarter is less than 1200, display "Improve in Next Quarter"

You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:

Which of the following conditional formulas will you insert to accomplish the task?

A. =IF(E2>=1200,"Improve in Next Quarter","Well Done")

B. =IF(E2<=1200,"Well Done","Improve in Next Quarter")

C. =IF(E2>=1200,"Well Done","Improve in Next Quarter")

D. =IF(E2>1200,"Improve in Next Quarter","Well Done")

Browse 62 Q&As
Questions 15

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2013. The report worksheet will include the sales made by all the sales managers in the month of January.

In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?

A. Bar

B. Line

C. Column

D. Pie

Browse 62 Q&As
Questions 16

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?

A. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Vertical option.

B. Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.

C. Click the New Window option in the Window group on the View tab. Click the Arrange All option in the Window group on the View tab. Select the Cascade option.

D. Select the cell which is to be monitored. On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

Browse 62 Q&As
Questions 17

You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2013. You have arranged sales data as shown below:

You want to provide pictorial representation of the trend of the sales data in front of each row.

Which of the following actions will you take to accomplish the task with the least amount of administrative burden?

A. Use stand-alone slicers.

B. Configure form controls.

C. Create sparklines.

D. Create a PivotTable report.

Browse 62 Q&As
Questions 18

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

Browse 62 Q&As
Exam Code: 77-427
Exam Name: Excel 2013 Expert Part One
Last Update: Mar 25, 2024
Questions: 62 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99