Microsoft MO-200 Exam Questions
Microsoft Excel (Excel and Excel 2019) (Page 3 )

Updated On: 21-Feb-2026
View Related Case Study

CORRECT TEXT - (Topic 1)
On the `'Prices'' worksheet, in the `'inventory Notice'' column, use a function to display `'Low'' if the `' inventory Level % is below 15%. Otherwise, leave the `'Inventory Notice'' blank.

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

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



View Related Case Study

CORRECT TEXT - (Topic 1)
On the `'Prices'' worksheet, apply the Title style to cell A1.

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

Home Tab/ Styles group/ cell styles



View Related Case Study

CORRECT TEXT - (Topic 1)
On the `'Orders'' worksheet, filter the table data to display only the orders from `'Alpine SKI House.''

  1. Please refer to Explanation below for the answer.

Answer(s): A

Explanation:

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



View Related Case Study

CORRECT TEXT - (Topic 1)
On the `'Prices'' worksheet, in the `'Tax column, enter a formula that multiples the value in the `'Unit Price'' column by cell L2.

  1. Please refer to Explanation below for the answer.

Answer(s): A



View Related Case Study

CORRECT TEXT - (Topic 1)
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.






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

Join the MO-200 Discussion