MO-210 Sample Questions Answers

To completeTask 4: Format a range as a table with a specific style on the Organic Feed worksheet, follow these steps:

Step 1: Select the "Organic Feed" Worksheet

Navigate to the correct worksheet by clicking theOrganic Feedtab at the bottom of the Excel window.

Step 2: Select the Data Range

Highlight the specific range mentioned in the task:

Click and drag your mouse to select cells fromA3toF10.

Ensure the selection includes the header row (SKU#, Brand, Description, etc.) and all data rows down to row 10.

Step 3: Format as Table

Go to theHometab on the Ribbon.

In theStylesgroup, click theFormat as Tablebutton.

Step 4: Apply the Specific Table Style

A gallery of styles will appear. Look for theLightsection.

Find and click onLime, Table Style Light 14(this is usually the last style in the second row of the Light section, featuring a lime green header).

Step 5: Confirm Headers

A small "Format As Table" dialog box will pop up.

Ensure the checkbox forMy table has headersischecked.

ClickOK.

Final Result

The data range will now be converted into a functional table with filter buttons in the header row and the lime green styling applied.

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 group multiple worksheets and change their tab colors simultaneously in Microsoft Excel 365, follow these steps:

Step 1: Group the Worksheets

Look at the worksheet tabs at the bottom of your Excel window.

Click on the first tab,Profits.

Hold down theCtrlkey on your keyboard.

While holdingCtrl, click on theCoststab and then theCharttab.

Note: You will notice all three tabs now have a white background, indicating they are grouped together.

Step 2: Change the Tab Color

Right-clickon any of the selected (grouped) tabs.

Hover your mouse overTab Colorin the pop-up menu.

In the color palette that appears, locate theTheme Colorssection.

Find and selectPink, Accent 4(this is usually the 8th color in the top row of the Theme Colors section).

Step 3: Ungroup the Worksheets

To finish,right-clickon any of the tabs again.

SelectUngroup Sheetsfrom the menu.

Alternatively, you can click on any worksheet tab that is not part of the group to ungroup them.

Final Result

TheProfits,Costs, andCharttabs will now all display the samePink, Accent 4color at the bottom of your workbook.

Would you like me to help you with the next task or another project?

Task 1: Insert a new column before column A

To insert a new column at the very beginning of your worksheet, follow these steps:

Select Column A: Click directly on the letter'A'at the top of the first column to select the entire column.

Open the Insert Menu: There are two ways to do this:

Option A (Right-Click): Right-click anywhere on the selected column and chooseInsertfrom the context menu.

Option B (Ribbon): On theHometab, go to theCellsgroup, click the arrow next toInsert, and selectInsert Sheet Columns.

Verification

Once completed, your original "Item Type" column (previously Column A) will shift toColumn B, and you will have a brand new, emptyColumn Aat the start of your worksheet.

To display the formulas within the cells of the Qtr 2 worksheet instead of the resulting values, you can use the Show Formulas command.

Step 1: Navigate to the Qtr 2 Worksheet

Open your Excel workbook.

Click on the Qtr 2 sheet tab at the bottom of the screen.

Step 2: Enable "Show Formulas" via the Ribbon

Go to the Formulas tab on the Ribbon at the top of the Excel window.

Locate the Formula Auditing group.

Click the Show Formulas button.

Alternative Method: Keyboard Shortcut

You can quickly toggle this view on and off by pressing:

Ctrl + ` (the accent mark or backtick key, usually located to the left of the "1" key).

What to Expect

Once activated, Excel will:

Expand column widths to accommodate the formula text.

Hide the calculated results and show the actual syntax (e.g., instead of seeing $411,912, you will see =SUM(B10:D10)).

To include theTotal Profitdata in your existing chart on theChartworksheet, follow these steps:

Step 1: Navigate to the Chart

Click on theChartworksheet tab at the bottom of the Excel window.

Click once on theFlavor Expenses, Income and Profitchart to select it. When selected, you will see theChart DesignandFormattabs appear on the Ribbon.

Step 2: Open the Select Data Source Window

Go to theChart Designtab.

In theDatagroup, click on theSelect Databutton. This will open theSelect Data Sourcedialog box.

Step 3: Add the Total Profit Series

In theLegend Entries (Series)section on the left side of the dialog box, click theAddbutton.

AnEdit Serieswindow will appear:

Series name:Click on theProfitsworksheet tab and select cellG3(which contains the header "Total Profit").

Series values:Clear any existing text in the box, then highlight the rangeG4:G23on theProfitsworksheet (containing the actual profit numbers).

ClickOKon the Edit Series window.

ClickOKagain on the Select Data Source dialog box to apply the changes.

Final Result

The chart will now display a third set of bars (likely orange, as seen in your preview) representing theTotal Profitfor each flavor alongside the existing Expense and Income data.

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.