MO-210 Questions and Answers

To move the pie chart to its own dedicated chart sheet without using the "New Sheet" button, follow these steps:

Step 1: Select the Pie Chart

Click anywhere on the Pie Chart located on the Qtr 2 worksheet. This action will activate the contextual chart tabs on the Ribbon.

Step 2: Open the Move Chart Dialog

Once the chart is selected, look at the top of your Excel window:

Go to the Chart Design tab (this tab only appears when a chart is selected).

On the far right of the Ribbon, in the Location group, click the Move Chart button.

Step 3: Configure the New Chart Sheet

A Move Chart dialog box will appear. To move the chart to its own sheet:

Select the New sheet: radio button.

In the text box next to "New sheet:", delete the default text and type Qtr 2 Chart.

Click OK.

Result

Excel will create a new sheet tab at the bottom of your workbook named Qtr 2 Chart that contains only the pie chart, scaled to fill the entire page.

To ensure that the text in your heading row (the table headers) is fully visible without changing the column width, you will use theWrap Textfeature.

Step-by-Step Solution

Select the Header Row:In your "Rentals" worksheet, click and drag to select the cell rangeA2:F2(the orange heading row containing "Capacity," "Fleet Name," etc.).

Navigate to the Home Tab:Ensure you are on theHometab of the Ribbon.

Apply Wrap Text:

Look for theAlignmentgroup.

Click theWrap Textbutton (usually represented by an "ab" icon with a curved arrow).

Verify the Result:The text in your headers will now automatically wrap to multiple lines if it exceeds the current width of the column.

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 keep rows 1 through 3 visible while you scroll down the "Sold" worksheet, you will use theFreeze Panesfeature.

Step-by-Step Solution

Select Row 4: Click on the row number4on the far left of the screen to select the entire row.

Note: In Excel, "Freeze Panes" freezes everythingabovethe currently selected row.

Navigate to the View Tab: Click on theViewtab in the top Ribbon menu.

Click Freeze Panes: In theWindowgroup, click theFreeze Panesbutton.

Select Freeze Panes: From the drop-down menu, select the first option,Freeze Panes.

Verification

Scroll down the worksheet using your mouse or the scroll bar. You should notice that the "Clearance Sale" header and the "Item Type/Description/etc." header row (rows 1-3) stay locked at the top of the screen while the data in row 4 and below moves.

To completeTask 3: Remove the hyperlink functionality from cell C27 on the Feed Inventory worksheet, follow these specific steps to ensure the text remains while the link is deleted.

Step 1: Select the "Feed Inventory" Worksheet

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

Step 2: Navigate to Cell C27

Locate cellC27in the Description column. Based on your project files, this is likely a URL or a linked piece of text at the bottom of the table.

Step 3: Remove the Hyperlink

You want to strip the "clickable" link without deleting the actual words inside the cell.

Right-clickdirectly on cellC27.

From the context menu that appears, selectRemove Hyperlink(it is usually located at the very bottom of the list).

Step 4: Verify the Text Remains

The text should change from blue/underlined back to standard black text, but the characters themselves will stay in the cell.