77-427 Exam Questions

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 ca...

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?

You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Ex...

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: I...

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 w...

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 i...

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You are facing a problem that when you type in a function and press Enter, the cell shows th...

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 20...

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 passwo...

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...

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 co...

Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2013. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer mess...

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values. You get a...

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You want to export XMLdata to your Excel 2013 worksheet. On expo...

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You want to change values in cells to observe the way in which those changes are affecting...

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...

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell: VLOOKUP(12, A2:C10, 3, FALSE ) Which o...

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You are creating a hot spot on a graphic that other users can click to run a macro. Whic...

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You want to summarize a large amount of data to analyze numerica...

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...

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. Rick has to perform the following tasks: - Summarize large amounts of data. - Anal...

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2013. While creating forms for a number of users, he is required to repea...

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 select the Encrypt wi...

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 openi...

You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook contai...

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You are creating a chart in Excel 2013. You want to show the slope of data points in the...

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 funct...

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. Rick wants to display data series, categories, data markers, and axes in the repor...

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. Rick is creating a project through Microsoft Excel 2013. The project on which he i...

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 t...

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values in the col...

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is n...

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have included various subtotals in a worksheet in the report...

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You input a formula for calculating the monthly sel...

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 o...

You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report of the Sales department. You use Microsoft Excel 2013 to prepare sales reports. You...

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 t...

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...

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...

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking. Which option can be use...

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 fo...

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial c...

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2013. Rick wants to interact with cell data but his computer does not contai...

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step...

Which of the following steps will you take to merge copies of a shared workbook? Each correct answer represents a part of the solution. Choose all that apply.

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 wa...

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 ident...

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...

Hotspot Question You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2013. You want to insert flow-chart in the sheet. Mark the option...

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 t...