Microsoft Excel (Excel and Excel 2019) - MO-200 Exam Practice Test
Question 1
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.
Correct Answer:
Click and press chart design. Press chart 7. Click change colors.
Question 2
On the ''Classes'' worksheet, convert the table to a cell rang. Keep the formatting.
Check the Solution below.
Check the Solution below.
Correct Answer:
design, convert to range
Question 3
On the ''Last Semester'' worksheet, remove the table row that contains '' Agriculture'' data. Do not change outside the table.
Check the Solution below.
Check the Solution below.
Correct Answer:
On the home tab, click find and select and click find. Type agriculture and press find all. Select all and then delete them with the home tab by clicking delete sheet rows.
Question 4
On the ''Summary'' worksheet, expand the chart to include the ''Current Year' data.
Check the Solution below.
Check the Solution below.
Correct Answer:
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.
