Free Microsoft Excel (Excel and Excel 2019) Exam MO-200 Exam Practice Test

On the ''Prices'' worksheet, in the ''inventory Notice'' column, use a function to display ''Low'' if the '' inventory Level % is below 15%. Otherwise, leave the ''Inventory Notice'' blank.

• Explanation: =IF(inventory level<15%), 'low', ''). Select and drag to apply to other rows

On the 'Comparison' chart sheet, swap the data the axis.

• Explanation: Right click and open axis options. Check the box that says values in reverse order. Topic 3, Class Schedule Case Study Exhibit.

On the ''Instructional Hours'' worksheet, adjust the width of columns B,G to exactly 12.

• Explanation: Home tab, cells group, click format. Click column width.

You are compiling data about courses at Bellows College.On the ''Last Semester'' worksheet configure A3:F3 to automatically wrap the text.

• Explanation: Click wrap text.

On the ''Enrollment Summary'' worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.

• Explanation: Click and press chart design. Press chart 7. Click change colors.

You are analyzing insurance sales data for the first six months of the year.On the ''New Policies'' worksheet change the horizontal alignment of the ''Agent'' names to Left (Indent). Set the indent to 1.

• Explanation: In the alignment tab, click increase indent.

On the ''New Policies'' worksheet, in the ''Inactive Months column, use a function to count the number of months with no new policies, by Agent.

• Explanation: =COUNTIFS(***

On the ''Prices'' worksheet, apply the Title style to cell A1.

• Explanation: Home Tab/ Styles group/ cell styles

On the ''Region 1'' worksheet, perform a multi-level sort, Sort table data by ''Product'' (A to Z) and then by ''Total Sales'' (Largest to Smallest).

• Explanation: Click sort and filter. Press custom sort and add levels to sort by.

On the ''Summary'' worksheet, expand the chart to include the ''Current Year' data.

• Explanation: Right click inside chart. Press select dat a. Press add. Add series name and series value (make sure to delete previous data. Topic 5, Insurance Policies Case Study Exhibit.