Microsoft MO-210 Dumps Questions Answers

n Excel 365, the most efficient way to do this is using theAutoFillfeature or simply dragging the fill handle. Here is your step-by-step solution:

Step 1: Switch to the Correct Worksheet

Ensure you are on theAverage Call Timeworksheet. Click the red tab at the bottom of the screen to switch from the "Employee Hours" view (shown in your image) to the call time data.

Step 2: Identify the Sparkline

Locate the first cell in theTrendcolumn that already contains a Sparkline (likely cellF4or similar, depending on your layout).

Step 3: Use the Fill Handle to Copy

Hover your mouse over thebottom-right cornerof the cell containing the sparkline.

Your cursor will change from a thick white cross to athin black cross (+).

Click and dragthe fill handle down to the bottom of the column to fill all the vacant cells in the "Trend" column.

Pro Tip:Alternatively, you can simplydouble-clickthe thin black cross (fill handle), and Excel will automatically fill the sparklines down to the last row of your data.

Alternative Method: Using the Ribbon

If you prefer using the menu interface:

Select the cellwith the existing sparkline and all theempty cells below itwhere you want the sparklines to appear.

Go to theHometab.

In theEditinggroup, click theFillicon (downward arrow).

SelectDown.

To swap the data on the axes so that the months appear on the x-axis and the revenue values appear on the y-axis, you will use theSwitch Row/Columnfeature in Excel.

Step 1: Select the Chart

Go to theQtr 1worksheet.

Click once on the border of theQ1 Location Revenuechart to select it. This will reveal theChart DesignandFormattabs on the Ribbon.

Step 2: Switch Row/Column Data

With the chart selected, click on theChart Designtab at the top of the window.

Locate theDatagroup on the right side of the Ribbon.

Click theSwitch Row/Columnbutton.

Step 3: Verify the Change

The X-Axis (Horizontal):Should now display the month labels (Jan, Feb, Mar).

The Legend:Should now display the differentLocations(College Campus, Downtown, etc.) as the colored series.

The Y-Axis (Vertical):Will automatically scale to represent the revenue values.

To completeTask 1: Remove the conditional formatting from the table on the Feed Inventory worksheet, follow these steps:

Step 1: Select the Target Worksheet

First, ensure you are on the correct worksheet as specified in the instructions.

Click on theFeed Inventorytab at the bottom of your Excel workbook.

Step 2: Select the Table or Data Range

You can remove formatting from the entire sheet, but to be precise with the "table," follow these sub-steps:

Click anywhere inside the table (the area containing the SKU#, Brand, Description, etc.).

PressCtrl + Ato select the entire table range.

Step 3: Access the Conditional Formatting Menu

Go to theHometab on the top Ribbon.

In theStylesgroup, click on theConditional Formattingbutton.

Step 4: Clear the Rules

Hover your mouse overClear Rulesnear the bottom of the drop-down menu.

A side menu will appear. SelectClear Rules from Selected Cells(if you have the table selected) orClear Rules from Entire Sheetto ensure all formatting is removed.

Final Result

Once clicked, any data bars, color scales, or highlight rules (like the light green shading seen in your screenshot) that were applied via Conditional Formatting will be removed, leaving the standard table styling