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
On the `'Prices'' worksheet, apply the Title style to cell A1.
Home Tab/ Styles group/ cell styles
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.
On the `'Prices'' worksheet, in the `'Tax column, enter a formula that multiples the value in the `'Unit Price'' column by cell L2.
Post your Comments and Discuss Microsoft MO-200 exam with other Community members:
Our website is free, but we have to fight against bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the MO-200 content, but please register or login to continue.