Free 77-727 sample questions
Real questions from the Excel 2016: Core Data Analysis, Manipulation, and Presentation 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.
You have a large table of employee data and have applied a filter to show only employees from the 'Sales' department. You now need to sort this filtered view by 'Hire Date' from oldest to newest. What is the correct procedure?
A user wants to copy cell formatting (font color, fill color, and border) from cell A1 to a non-adjacent range C5:E10. What is the most efficient way to accomplish this?
You are creating a budget spreadsheet. You need to reference the tax rate, located in cell H1, in multiple formulas across the worksheet. When you copy these formulas to other cells, the reference to H1 must not change. Which reference style should you use for cell H1?
True or False: Using the 'Hide Sheet' command makes the worksheet's data inaccessible to formulas on other visible sheets.
To ensure a workbook created in Excel 2016 can be opened and fully functional in Excel 2003, which TWO actions should be performed before distribution? (Select TWO)
A marketing manager is analyzing campaign performance. The data is organized in an Excel table. To quickly see a visual representation of each campaign's performance directly within a cell next to its data, which feature should be used?
You need to sum the total sales from column D, but only for transactions that occurred in the 'North' region, which is specified in column A. Which formula correctly calculates this conditional sum?
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?
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?
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.