Microsoft Excel (Excel and Excel 2019) - MO-200 Exam Questions
QUESTION NO: 1
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.
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.
Correct Answer:
Conditional formatting, highlight cell rules, greater than and then pick the color.
Topic 2, Clothing Orders
Exhibit.
Topic 2, Clothing Orders
Exhibit.
QUESTION NO: 2
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.
Check the Solution below.
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.
Check the Solution below.
Correct Answer:
=COUNTIFS(***
QUESTION NO: 3
On the ''Summary'' worksheet, expand the chart to include the ''Current Year' data.
Check the Solution below.
On the ''Summary'' worksheet, expand the chart to include the ''Current Year' data.
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.
QUESTION NO: 4
At NOD Publishers, you are preparing a workbook for the company's annual review.
On
the ''Summary worksheet, from the existing text in cell A2, insert a hyperlink to
''http://www:nodpublishers.com with a ScreenTip that displays ''Company Website''.
Check the Solution below.
At NOD Publishers, you are preparing a workbook for the company's annual review.
On
the ''Summary worksheet, from the existing text in cell A2, insert a hyperlink to
''http://www:nodpublishers.com with a ScreenTip that displays ''Company Website''.
Check the Solution below.
Correct Answer:
Insert, hyperlink.
