MO-200 Online Practice Questions and Answers

Correct Answer: A

[Send us your suggestions on it.]

Correct Answer: A

Select the range and type the name

Correct Answer: A

=LOWER(LEFT(FIRST), LAST), "@domain.com"

Correct Answer: A

Click chart and press "chart design" click style 3.

Correct Answer: A

Click design and press total row. Click and drag.

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

Right click inside chart. Press select data. Press add. Add series name and series value (make sure to delete previous data.

Correct Answer: A

=IF(books sold>10,000, "500", "100"). Select and drag to apply to other rows

Correct Answer: A

File. Open.

Correct Answer: A

Home tab, cells group, click format. Click column width.

Correct Answer: A

design, convert to range

Correct Answer: A

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

Correct Answer: A

[Send us your Suggestion on it.]

Correct Answer: A

=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows

Correct Answer: A

On the data tab, click filter. Display only alpine.