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

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

On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’

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.

On the ‘’New Policies’’ worksheet, add a Total Row to the table. Configure the Total Row to display the number of new policies for each month and for the 6-month total.

On the ‘Historical Sales’’ Worksheet display the formulas instead of the values.