MO-200 無料問題集「Microsoft Excel (Excel and Excel 2019)」
On the ''Enrollment Summary'' worksheet, apply the Style 7 chart and the Monochromatic Palette 6 color to the chart.
Check the Solution below.
Check the Solution below.
正解：
Click and press chart design. Press chart 7. Click change colors.
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.'' Check the Solution below.
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.'' Check the Solution below.
正解：
Conditional formatting, highlight cell rules, greater than and then pick the color.
Topic 2, Clothing Orders
Exhibit.
Topic 2, Clothing Orders
Exhibit.
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).
Check the Solution below.
''Total Sales'' (Largest to Smallest).
Check the Solution below.
正解：
Click sort and filter. Press custom sort and add levels to sort by.
Topic 1, Sales SummaryCase Study
Exhibit.
Topic 1, Sales SummaryCase Study
Exhibit.
On the ''Summary'' worksheet, expand the chart to include the ''Current Year' data.
Check the Solution below.
Check the Solution below.
正解：
Right click inside chart. Press select data. Press add. Add series name and series value (make sure to delete previous data.
Topic 5, Insurance PoliciesCase Study
Exhibit.
Topic 5, Insurance PoliciesCase Study
Exhibit.