MO-200

CORRECT TEXT 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.View AnswerAnswer: Select and press delete on the home tab.

Topic 1, Clothing Orders Case Study Exhibit. CORRECT TEXT 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.View AnswerAnswer: =IF(inventory level<15%), "low", ""). Select and drag to apply to...

CORRECT TEXT You are revising a sales summary report for Northwind Traders. On the ‘’Summary’’ worksheet, in cells F4:F11, use conditional formatting to apply the Yellow Fill with Dark Yellow Text format to cells that contain values greater than ‘’$5,000,000.’’View AnswerAnswer: Conditional formatting, highlight cell rules, greater than and then...

CORRECT TEXT On the ‘’Prices’’ worksheet, apply the Title style to cell A1.View AnswerAnswer: Home Tab/ Styles group/ cell styles

CORRECT TEXT On the ‘’Projections’ worksheet, in the ‘’Quarter2’’ column, enter a formula that multiples the value in the Quarter 1’’ column by the ‘Q2_increase’ named range. Use the range name in the formula instead of a cell reference or value.View AnswerAnswer:

Topic 2, Sales Summary Case Study Exhibit. CORRECT TEXT On the ‘Comparison’ chart sheet, swap the data the axis.View AnswerAnswer: Right click and open axis options. Check the box that says values in reverse order.

CORRECT TEXT On the ‘’Prices’’ worksheet, in the ‘’Tax column, enter a formula that multiples the value in the ‘’Unit Price’’ column by cell L2.View AnswerAnswer:

CORRECT TEXT On the ‘’Summary’ worksheet, in cell B15, use a function to display the highest sales amount from the ‘’Total Sales’’ column.View AnswerAnswer:

CORRECT TEXT On the ‘’Orders’’ worksheet, filter the table data to display only the orders from ‘’Alpine SKI House.’’View AnswerAnswer: On the data tab, click filter. Display only alpine.

CORRECT TEXT 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.View AnswerAnswer: Click chart, press layout, click chart title and add it. Press add chart element,...