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.
Answer(s): A
=IF(inventory level<15%), "low", ""). Select and drag to apply to other rows
CORRECT TEXT - (Topic 1)On the `'Prices'' worksheet, apply the Title style to cell A1.
Home Tab/ Styles group/ cell styles
CORRECT TEXT - (Topic 1)On the `'Orders'' worksheet, filter the table data to display only the orders from `'Alpine SKI House.''
On the data tab, click filter. Display only alpine.
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.
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.
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 prep with other Community members: