Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
Scrum
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. MO-200

Free MO-200 Exam Braindumps (page: 3)

Page 2 of 9
PDF with 146 Questions
View Related Case Study

On the `'Inventory' chart sheet, insert a chart title above the chart, at the top of the plot area. Display the percentage values as data labels to the right of each data bar.

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

Click chart, press layout, click chart title and add it. Press add chart element, data labels, more detailed options, uncheck value and check percentage.



View Related Case Study

You are updating the sales spreadsheet for an online clothing store.

On the "Quote'' worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

Select and press delete on the home tab.



View Related Case Study

On the `Comparison' chart sheet, swap the data the axis.

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

Right click and open axis options. Check the box that says values in reverse order.



View Related Case Study

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.''

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

Conditional formatting, highlight cell rules, greater than and then pick the color.






Post your Comments and Discuss Microsoft MO-200 exam with other Community members: