ExamDumpster

Free 77-727 sample questions

The free 77-727 sample questions on this page cover core Excel 2016 skills, with answers and explanations. They cover cell ranges, table filters and chart formatting. They are a quick way to find the Excel tasks you still need to practise.

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

Showing 10 of 20 free sample questions.

Question 1Choose one

A company wants to add its logo to the top-right corner of every printed page of a workbook. The logo is saved as an image file. What is the proper method to achieve this?

Question 2Choose one

You have converted a range of data into an Excel table. What is the primary benefit of using structured references (e.g., `=[@Sales]`) in formulas within this table?

Question 3Choose one

A sales manager has a chart showing monthly sales for four different regions. To make the chart less cluttered, she wants to temporarily remove the 'West' region's data series from the chart without deleting the source data. What is the most direct way to do this?

Question 4Choose one

A user has pasted a list of names into a single column, but the alignment is inconsistent. Some names are left-aligned, some are centered, and some are right-aligned. To standardize the entire column to be left-aligned with a small space from the cell border, what should the user do?

Question 5Choose one

You have a workbook with sensitive financial data on a sheet named 'Q4-Internal'. You need to prevent other users from seeing this sheet, but still allow formulas on a 'Summary' sheet to reference its data. Which is the most appropriate action?

Question 6Choose one

Case Study: A small retail business, 'Urban Blooms', tracks its weekly sales in an Excel workbook. The workbook contains a separate sheet for each month. The owner wants to create a 'YearEndSummary' sheet to consolidate key metrics. Specifically, on this summary sheet, she needs to calculate the total annual revenue by summing cell F50 (which contains the monthly total) from every monthly sheet ('Jan' through 'Dec'). Which formula construction is the most efficient and scalable for calculating the grand total on the 'YearEndSummary' sheet?

Question 7Choose one

You have a list of product codes in the format 'CATEGORY-ID-YEAR', for example, 'ELE-A45-2023'. You need to extract only the middle part, the 'A45' ID. The ID is always 3 characters long and starts at the 5th character. Which formula will accomplish this?

Question 8Choose one

A financial analyst is preparing a report and needs to prevent any changes to a worksheet containing final calculations. However, they want to allow users to still view the data. Which protection feature is most suitable?

Question 9Choose one

When using the Remove Duplicates tool on an Excel table, the tool permanently deletes the entire row where a duplicate value is found.

Question 10Choose one

A data analyst needs to organize a large dataset of customer transactions into a hierarchical view, allowing them to expand and collapse details for each region. The data is sorted by Region, then by City. What is the most appropriate feature to create this collapsible structure? graph TD subgraph AllData [All Transactions] subgraph NorthAmerica [Region: North America] CityNY[City: New York] CityLA[City: Los Angeles] end subgraph Europe [Region: Europe] CityLON[City: London] CityPAR[City: Paris] end end

10 more free samples are waiting

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

Create account