MO-201 Practice Questions
25 real MO-201 exam questions with expert-verified answers and explanations. Page 1 of 1.
- Question #1Manage workbook options and settings
You are analyzing data about the number of visitors to U.S. National Parks. Configure Excel so that you can edit content using Albanian as the editing language.
Excel optionsLanguage preferencesEditing language - Question #2Manage and format data
On the "2019 Visitors" worksheet, modify the conditional formatting rule to format rows for parks that have a "Size" greater than 1,000 square miles.
Conditional FormattingModify RulesRow FormattingRule Conditions - Question #3Manage and format data
On the "Summary" worksheet, starting in cell A4, consolidate data from the 2014-2018 "By Region" worksheets. Display the average number of the "Recreation Visits" for each "Region"...
Data ConsolidationAverage aggregationMulti-sheet referencesLabels - Question #4Manage advanced charts and tables
On the "Volunteer Analysis" chart sheet, drill down into the data to display the number of volunteer hours for each month.
Chart interactionDrill downData granularityData visualization - Question #5Manage and format data
On the 'Regional Sales' worksheet, in cells D4:F7, use the Fill Series feature to complete the sales projections using a linear growth rate of 500,000 per year.
Fill SeriesLinear growthData SeriesProjections - Question #6Create advanced formulas and macros
On the 'Employees' worksheet, in cell C4, enter a formula that returns the office phone number from the 'Contact_Information' cell range using an exact match for the 'Contact_Infor...
Lookup functionsExact matchData retrievalFormula creation - Question #7Create advanced formulas and macros
On the 'Financials' worksheet, in cell C2, enter a formula that sums the 'Actual Sales' column for all sales that occurred between 1/1/2019 and 1/31/2019, inclusive.
FormulasSUMIFS functionConditional aggregationDate criteria - Question #8Create advanced formulas and macros
From the "Employees" worksheet, create a macro named "Header". Store the macro in the current workbook. Configure the macro to insert the "Sheet Name" in the left header cell of th...
Macro creationHeader customizationPage SetupVBA - Question #9Manage advanced charts and tables
On the "Plan Analysis" worksheet, modify the PivotTable to group the data by the values in the "Full Package Price" column. Group the values in steps of 100 beginning at 0 and endi...
PivotTableData GroupingNumerical DataData Analysis - Question #10Manage and format data
On the "Popular Videos" worksheet, for cells B4:C17, create a conditional formatting rule that displays the five lowest values in bold Dark Red font.
Conditional FormattingTop/Bottom RulesCell FormattingData Display - Question #11Manage workbook options and settings
Configure Excel to disable all macros in the workbook without notification.
Macro SecurityDisable MacrosExcel OptionsTrust Center - Question #12Manage and format data
On the "New Titles" worksheet, for cells E4:E24, create and apply a custom number format that displays the dates in the format "2020 January 01".
Custom number formatDate formattingNumber formattingData formatting - Question #13Create advanced formulas and macros
On the "Royalty" worksheet, the existing formula in the "Royalty Due" column calculates the royalties due to each author. On cell F4, modify the existing formula to return the amou...
IF FunctionConditional LogicFormula Modification - Question #14Manage advanced charts and tables
On the "Sales Analysis" worksheet, insert a slicer that allows users to filter the PivotTable by "Category". Then use the slicer to display only "Psychology" books.
SlicersPivotTablesFiltering data - Question #15Manage advanced charts and tables
In the 'Royalty Analysis' worksheet, add the "Title ID" field as a PivotChart filter. Apply the filter to the chart to display only results for title ID "CO20".
PivotChartFiltering dataChart manipulation - Question #16Manage workbook options and settings
Configure Excel to automatically evaluate formulas only when a workbook is saved, and not each time data changes.
Excel configurationCalculation optionsFormula evaluationWorkbook settings - Question #17Manage workbook options and settings
Require users enter the password "Pr@5word" before they can make structural changes to the workbook.
Password protectionWorkbook securityProtect workbook structure - Question #18Manage and format data
On the "Sales Conference" worksheet, configure cells A4:A12 to allow only whole numbers from 1 to 9. Otherwise, display a Stop error with the title "Invalid" and the message "1 to...
Data ValidationWhole number validationError alerts - Question #19Create advanced formulas and macros
On the "Year-to-Date Sales" worksheet, in cells L5:L15, enter a formula that returns the average "Total Sales" for the region in cell J5 and the "Representative" in cell K5.
FormulasAVERAGEIFSMultiple CriteriaConditional Aggregation - Question #20Manage advanced charts and tables
On the "Sales Summary" worksheet, create one chart that displays each representative's "Total Sales" as an Area chart and the "Grand Total Percentage" as a secondary axis Line char...
Chart creationCombo chartsSecondary axisChart types - Question #21Manage advanced charts and tables
On the "Regional Sales" worksheet, modify the PivotTable to display the "Territory" rows within each region.
PivotTablePivotTable fieldsData displayField arrangement - Question #22Manage and format data
On the "Inventory" worksheet, use an Excel feature to remove the duplicate records from the "Products" cell range.
Remove DuplicatesData CleansingData Management - Question #23Create advanced formulas and macros
On the "Employee" worksheet, in cell F4, enter a formula that returns the employee's bonus from the 'Years of Service Bonus' table. Adjust the formula and then copy it to cells F5-...
Lookup functionsCell referencingFormulasData retrieval - Question #24Create advanced formulas and macros
On the "Retail" worksheet, display arrows that indicate the cell values that are dependent on the value in C4.
Trace DependentsFormula AuditingCell Dependencies - Question #25Manage advanced charts and tables
On the "New Products" worksheet, create a Histogram chart that shows the "Retail Price" of the products in bins with widths of $10. The chart size and position do not matter.
Histogram chartChart creationStatistical chartsChart formatting