Sign in

Free 77-427 sample questions

Real questions from the Excel 2013 Expert practice bank, with the correct answer and an explanation for each one. No junk, no filler.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 10 of 20 free sample questions.

Question 1Choose one

You are managing a shared workbook that tracks quarterly sales data. Multiple regional managers update this single file. To maintain data integrity, you need to accept or reject changes made by others. However, the 'Accept/Reject Changes' button in the 'Changes' group on the 'Review' tab is greyed out and unavailable. What is the most likely cause of this issue?

Question 2Choose one

A data analyst has a PivotTable summarizing sales by `Region` (Rows), `Product Category` (Rows), and `Year` (Columns). They need to add a new column directly within the PivotTable that calculates a 5% commission for each `Product Category` based on the total sales amount. This calculation should update dynamically as the PivotTable is filtered or refreshed. What is the most appropriate tool to achieve this?

Question 3Choose one

You need to apply conditional formatting to a range of project deadlines (B2:B50). You want to highlight any date that falls on a Saturday or a Sunday. Which formula should be used in the conditional formatting rule to correctly identify weekend dates?

Question 4Choose one

True or False: The 'Compare and Merge Workbooks' feature can be used to merge changes from multiple copies of a shared workbook, even if those copies have been saved with different file names.

Question 5Choose 2

A sales manager is creating a dashboard. They want to include a small, in-cell chart next to each salesperson's total sales figure to show their sales trend over the last 12 months. The chart should also highlight the highest and lowest sales months. Which combination of Excel features is best suited for this task? (Select TWO)

Question 6Choose one

An HR manager has a worksheet with employee data. They need to ensure that when a user enters a new employee's department in column D, the entry must be one of the values from a master list of departments located in the named range `DeptList`. Additionally, when a user selects a cell in column D, an input message should appear instructing them to 'Select a department from the list'. Which feature should be configured on column D to meet all these requirements?

Question 7Choose one

You are auditing a complex workbook. In cell F10, there is a formula `=SUM(Sheet2!C5, Sheet3!D8)`. You need to quickly navigate to cell C5 on Sheet2 to examine its value. Which is the most direct method to do this using Excel's formula auditing tools?

Question 8Choose one

A financial analyst needs to create a chart that compares monthly revenue (in millions of dollars) against the number of units sold (in thousands). Because the scales of these two data series are vastly different, plotting them on a single value axis makes the 'units sold' series appear almost flat and unreadable. What type of chart and feature should be used to visualize this data effectively?

Question 9Choose one

A researcher has a dataset of experiment results. They have created a PivotTable to summarize the average result by 'Experiment Type' and 'Date'. The dates in the row labels are currently showing individual days (e.g., 2013-01-05, 2013-01-06, ...). They want to analyze trends by month and quarter. What is the most efficient way to achieve this within the PivotTable?

Question 10Choose 2

You are preparing a workbook template for your department. To ensure accessibility for users with screen readers, you must add descriptive alternative text to all charts and images. You also need to verify that there are no other accessibility issues, such as merged cells with no clear header or insufficient color contrast. Which two tools in Excel 2013 should you use to accomplish these tasks? (Select TWO)

10 more free samples are waiting

Create a free account to unlock the whole 77-427 sample bank, or get full access to all 155 practice questions in the simulator.

Create account