Microsoft MO-200 Actual Free Exam Questions & Community Discussion
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.
Correct Answer:
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 ''Contact'' worksheet, in the ''Email Address'' column, use a functional to construct email addresses for each person using the first name and ''@humongousinsurance.com,'' Check the Solution below.
Correct Answer:
=LOWER(LEFT(FIRST), LAST), "@domain.com"
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.
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.
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.
0
0
0
10