MO-201 Practice Questions

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.

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.

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"...

On the "Volunteer Analysis" chart sheet, drill down into the data to display the number of volunteer hours for each month.

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.

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...

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.

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...

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...

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.

Configure Excel to disable all macros in the workbook without notification.

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".

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...

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.

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".

Configure Excel to automatically evaluate formulas only when a workbook is saved, and not each time data changes.

Require users enter the password "Pr@5word" before they can make structural changes to the workbook.

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...

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.

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...

On the "Regional Sales" worksheet, modify the PivotTable to display the "Territory" rows within each region.

On the "Inventory" worksheet, use an Excel feature to remove the duplicate records from the "Products" cell range.

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-...

On the "Retail" worksheet, display arrows that indicate the cell values that are dependent on the value in C4.

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.