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.
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?
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?
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?
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?
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?
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?
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?
When using the Remove Duplicates tool on an Excel table, the tool permanently deletes the entire row where a duplicate value is found.
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.