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

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

Step-by-Step Solution

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

Select Cell B4 : Click on cell B4 (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 cell D4 and return only the first two letters.

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.

Project 1: Video Games - Task 5 Solution

Task: Insert a Footer that displays today's date on the right and then return to Normal view.

Step 1: Open the Header & Footer View

Go to the Insert tab on the Ribbon.

Look for the Text group (usually near the right side).

Click on the Header & Footer button.

Note: This will automatically switch your screen to "Page Layout" view, and you will see the header area at the top of the page.

Visual Reference: (Look for this icon in the Insert tab) [ Header & Footer ]

Step 2: Navigate to the Footer

You are currently in the Header. You need to go to the Footer .

On the Header & Footer tab (which appears in the Ribbon when you are in this mode), click the button labeled Go to Footer .

Alternative: You can simply scroll down to the bottom of the page until you see the footer boxes "Click to add footer".

Visual Reference: (Button in the Navigation group) [ Go to Footer ]

Step 3: Select the Right Section

The footer is divided into three boxes: Left, Center, and Right.

Click inside the Right box.

Visual Reference: [ Left Box ] [ Center Box ] [ *Click Here (Right Box)* ]

Step 4: Insert the Current Date

With your cursor flashing in the right footer box, look at the Header & Footer tab in the Ribbon.

In the Header & Footer Elements group, click the Current Date button.

You will see the code & [Date] appear in the box. This is correct; it will turn into the actual date once you click away.

Visual Reference: (Icon looks like a small calendar) [ Current Date ] - > Displays as & [Date]

Step 5: Return to Normal View

Click anywhere inside the worksheet cells (outside the footer area) to apply the change.

Go to the View tab on the Ribbon.

In the Workbook Views group (far left), click on Normal .

Visual Reference: (View Tab > Workbook Views) [ Normal ]

Result: You have successfully added the date to the footer. In "Normal" view, you won't see the footer anymore, but it is there and will appear when printed.

To ensure every other row is shaded and that this formatting updates automatically when new rows are added, you should use the Banded Rows feature within the Table Design options.

Since your data is already formatted as a Table (indicated by the filter arrows in the header row), follow these steps:

Step-by-Step Solution

Select the Table : Click anywhere inside the data on the Sold worksheet (for example, cell B5 ). This will make the contextual "Table Design" tab appear in the Ribbon.

Go to Table Design : Click on the Table Design tab at the top of the Excel window.

Enable Banded Rows : In the Table Style Options group, check the box labeled Banded Rows .

Why this works:

Automatic Updating : Because this is a Table feature rather than manual cell shading, if you insert a new row between existing data, Excel will automatically re-calculate the "every other row" pattern to maintain the shading.

Consistency : This method ensures that even if you sort or filter the data, the alternating stripes remain consistent visually.

Verification

Look at your table; you should see that rows 4, 6, 8, etc., have a different background color than rows 5, 7, 9. Try right-clicking a row and selecting Insert to see how the shading shifts automatically to maintain the pattern.

To complete Task 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 the Feed Inventory tab at the bottom of the window.

Step 2: Navigate to Cell C27

Locate cell C27 in 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-click directly on cell C27 .

From the context menu that appears, select Remove 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 keep rows 1 through 3 visible while you scroll down the "Sold" worksheet, you will use the Freeze Panes feature.

Step-by-Step Solution

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

Note: In Excel, "Freeze Panes" freezes everything above the currently selected row.

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

Click Freeze Panes : In the Window group, click the Freeze Panes button.

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 complete Task 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 the Feed Inventory tab at the bottom of your Excel window.

Step 2: Select the Chart

Click anywhere on the Total Inventory pie 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 the Chart Design tab (this tab only appears when a chart is active).

Step 4: Apply Chart Style 5

In the Chart Styles group, you will see a gallery of different looks for your chart.

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

Locate and click on Style 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 complete Task 2 , you need to enable the Total Row feature for the table on the Employee Hours worksheet. This is the most efficient way to automatically calculate sums in an Excel table.

Step 1: Select the Worksheet

Click on the Employee Hours tab at the bottom of your Excel window to ensure you are on the correct sheet.

Step 2: Activate the Table

Click anywhere inside the data table (for example, click on cell A4 where it says "emilio"). Once you click inside the table, a new tab called Table Design will appear at the very top of your Ribbon.

Step 3: Enable the Total Row

Go to the Table Design tab on the Ribbon.

In the Table Style Options group, check the box labeled Total Row .

Result: A new row labeled "Total" will immediately appear at the bottom of your data (Row 15).

Step 4: Configure the Total Hours Calculation

By default, Excel might place a count or sum in the last column. You need to ensure the Total Hours column (Column J) is calculating correctly:

Click on the cell at the bottom of the Total Hours column ( J15 ).

A small drop-down arrow will appear next to the cell. Click it.

Select Sum from the list.

Final Result

Your table will now have a dedicated row at the bottom that automatically updates the total hours whenever you add or change employee data.