Get 50% Flat Discount on This Special Offer | Limited Time Offer - Ends In COUPON: SAVE50

Practice Microsoft MO-200 Exam Questions

Page: 1/7
Total 35 Questions
Question No 1
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.
Choose the Choices:


Question No 2
On the ‘’Prices’’ worksheet, apply the Title style to cell A1.
Choose the Choices:


Question No 3
On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’
Choose the Choices:


Question No 4
On the ‘’Prices’’ worksheet, in the ‘’Tax column, enter a formula that multiples the value in the ‘’Unit Price’’ column by cell L2.
Choose the Choices:


Question No 5
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.
Choose the Choices:


Page: 1/7
Total 35 Questions