← Back to exam page

MO-200 – Microsoft Excel (Excel and Excel 2019)

Loading demo links...

Showing 4–5 of 5 questions

Question 4 (Sales SummaryCase Study Exhibit.)

CORRECT TEXT

On the ‘Comparison’ chart sheet, swap the data the axis.

Answer is in the explanation below.

Question 5 (Sales SummaryCase Study Exhibit.)

CORRECT TEXT

You are revising a sales summary report for Northwind Traders.

On the ‘’Summary’’ worksheet, in cells F4:F11, use conditional formatting to apply the

Yellow Fill with Dark Yellow Text format to cells that contain values greater than

‘’$5,000,000.’’

Answer is in the explanation below.