MO-210 Microsoft Excel (Microsoft 365 Apps) Question and Answers

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.

Step 1: Select the Data Range

Navigate to theTop 20 Videosworksheet.

Click on cellA4(this contains the rank "#1").

Hold your left mouse button down and drag diagonally to cellC8(this contains the year "2018").

Release the mouse button. The range from Rank #1 (Minecraft) to Rank #5 (Super Smash Brothers Ultimate) should be highlighted.

Step 2: Open the Cell Styles Gallery

Make sure you are on theHometab of the Ribbon (at the top of the window).

Look for theStylesgroup (usually near the middle-right of the ribbon).

Click theCell Stylesbutton (it may look like a dropdown arrow or a box showing style previews).

Step 3: Apply "60% - Accent 1"

In the gallery that opens, look under the "Themed Cell Styles" section.

Locate the first column of accents (usually blue or the primary theme color).

Find and click on60% - Accent 1.

Result:The background color of the top 5 rows in your table will change to a lighter shade (likely light blue or orange, depending on the workbook theme), matching the style requirement.

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.

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?

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.

Step 1: Select the Table

Navigate to theRecent Releasesworksheet.

Clickanywhereinside the data table (for example, click on the text "A Little to the Left").

Note:You do not need to highlight the whole table; just clicking one cell inside it is enough to activate the hidden menu.

Step 2: Go to the "Table Design" Tab

Look at the Ribbon at the very top of the Excel window.

Because you clicked inside the table, a new tab calledTable Design(or sometimes justDesign) will appear on the far right side of the Ribbon.

Click on theTable Designtab.

Step 3: Click "Convert to Range"

In theTable Designtoolbar, look for theToolsgroup (usually on the left side).

Click the button labeledConvert to Range.

Visual Reference:

Step 4: Confirm the Action

A confirmation dialog box will pop up asking:"Do you want to convert the table to a normal range?"

ClickYes.

Result:The table functionality (like the little filter arrows next to the headers) will disappear, but the cell colors and data will remain exactly where they are. The data is now a standard "Range."

To extract specific characters from the start of a text string in Excel, you use theLEFTfunction.

Step-by-Step Solution

Navigate to the Worksheet: Click on theVehiclesworksheet tab at the bottom of your Excel window.

Select Cell B4: Click on cellB4(under the "Code" column).

Enter the Formula: Type the following formula exactly as shown: =LEFT(D4, 2)

Press Enter: Once you press Enter, Excel will look at the "Vehicle Style" in cellD4and return only the firsttwoletters.

Explanation of the Formula

LEFT: This is the function used to start counting characters from the beginning (left side) of a cell.

D4: This tells Excel which cell contains the text you want to extract from (the Vehicle Style).

2: This specifies the number of characters you want to retrieve.