Microsoft MO-210 Dumps

To transfer the formatting from theProfitsworksheet to theCostsworksheet while maintaining consistency, follow these steps:

Step 1: Copy the Source Formatting

Click on theProfitsworksheet tab at the bottom of your Excel window.

Select the cell rangeA2:G2.

On theHometab, in theClipboardgroup, click theFormat Painterbutton (it looks like a paintbrush).

Tip: Your cursor will now have a small paintbrush icon next to it, indicating the formatting is "loaded" and ready to be pasted.

Step 2: Apply Formatting to the Destination

Click on theCostsworksheet tab (the one shown in your provided image).

Click directly onCell A2(the cell containing "Production Costs (per pound)").

Excel will automatically apply the formatting across the range starting from A2 to match the original source.

Final Result

The cell range in theCostsworksheet should now match the style (font, background color, and borders) of theProfitsworksheet. The grey shading currently visible in your image in rangeB2:G2will be replaced by the style from the first sheet.

To completeTask 5: Apply Style 5 to the chart on the Feed Inventory worksheet, follow these exact steps:

Step 1: Select the "Feed Inventory" Worksheet

Ensure you are on the correct sheet by clicking theFeed Inventorytab at the bottom of your Excel window.

Step 2: Select the Chart

Click anywhere on theTotal Inventorypie chart to select it. When selected, you will see a border around the chart and new tabs will appear on the Ribbon.

Step 3: Open Chart Design Tools

With the chart selected, look at the top Ribbon and click on theChart Designtab (this tab only appears when a chart is active).

Step 4: Apply Chart Style 5

In theChart Stylesgroup, you will see a gallery of different looks for your chart.

Hover your mouse over the styles to see their names, or click theMorearrow (the small downward arrow at the bottom right of the styles gallery) to see all options.

Locate and click onStyle 5.

Note:Style 5 typically features a specific layout of data labels and a distinct background or border style that matches the "Farm Fresh Feeds" theme.

Final Result

The pie chart will update its appearance to match Style 5, adjusting the placement of the percentage labels and the overall color shading to remain consistent with your report's professional look.

To view two instances of your Excel workbook side-by-side, follow these steps:

Step 1: Open a Second Window

Go to theViewtab on the Ribbon.

In theWindowgroup, click onNew Window.

Note: This creates a second view of your current file. You will notice the file name in the title bar now says "Filename - 2".

Step 2: Arrange Side-by-Side

Navigate back to theViewtab.

In the sameWindowgroup, click theView Side by Sidebutton.

If the windows do not align automatically, clickArrange Alland selectVerticalto see them left-to-right.

Verification

You should now see two separate windows of the same "Clearance Sale" workbook on your screen. Any change you make in one window will instantly update in the other, allowing you to view different worksheets (like "Sold" and "Vehicles") at the same time.