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 are cleaning a dataset of customer feedback. Column C contains comments in all uppercase letters. To convert these comments to title case (e.g., "CUSTOMER IS VERY SATISFIED" becomes "Customer Is Very Satisfied"), which function should you use in column D?
A data analyst needs to visualize the daily temperature fluctuations over a month. The data is in two columns: 'Date' and 'Temperature'. Which chart type is most appropriate for displaying this time-series data to show trends?
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?
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.