MO-200 Microsoft Excel (Excel and Excel 2019) Question and Answers

You are updating the sales spreadsheet for an online clothing store.

On the "Quote’’ worksheet move the cells E8:F32 up to correct the alignment by deleting cells E7:F7.

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.