CORRECT TEXT - (Topic 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.
Answer(s): A
Select and press delete on the home tab.
CORRECT TEXT - (Topic 2)On the `Comparison' chart sheet, swap the data the axis.
Right click and open axis options. Check the box that says values in reverse order.
CORRECT TEXT - (Topic 2)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.''
Conditional formatting, highlight cell rules, greater than and then pick the color.
CORRECT TEXT - (Topic 2)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.
CORRECT TEXT - (Topic 2)On the `'Summary' worksheet, in cell B15, use a function to display the highest sales amount from the `'Total Sales'' column.
Post your Comments and Discuss Microsoft MO-200 exam prep with other Community members:
Our website is free, but we have to fight against AI 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.