MO-200 Online Practice Questions and Answers

Correct Answer: A

Click wrap text.

Correct Answer: A

Select a cell within your data. Press home and then format as table. Click the table style and select your range.

Correct Answer: A

Select a blank cell and press insert. Pick win/loss sparklines. Select the data range. Click and drag the bottom right corner for more.

Correct Answer: A

=UPPER(text)

Correct Answer: A

Right click on the chart. Click move chart. Click new sheet and rename it.

Correct Answer: A

Click on the green plus sign and press axis titles.

Correct Answer: A

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

Correct Answer: A

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

Correct Answer: A

=_*_

Correct Answer: A

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