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

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

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.

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 completeTask 2: Import NewFeeds.txt as a table on a new worksheet, follow these exact steps in Microsoft Excel 365:

Step 1: Open the Import Tool

Go to theDatatab on the top Ribbon.

In theGet & Transform Datagroup, click onFrom Text/CSV.

Step 2: Locate the File

A file browser window will open. Navigate to theGMetrixTemplatesfolder.

Select the file namedNewFeeds.txt.

ClickImport.

Step 3: Configure the Import Preview

A preview window will appear. Excel should automatically detect the delimiter (usually a tab or comma).

Ensure theFile OriginandDelimiterlook correct in the preview.

Instead of clicking "Load," click thearrow next to the Load buttonand selectLoad To....

Step 4: Import as a Table on a New Worksheet

In theImport Datadialog box that appears, select the radio button forTable.

Under "Where do you want to put the data?", selectNew worksheet.

ClickOK.

Final Result

Excel will create a brand new sheet (e.g., "Sheet2") and place the contents of NewFeeds.txt inside a formatted Excel Table.

To completeTask 2, you need to enable theTotal Rowfeature for the table on theEmployee Hoursworksheet. This is the most efficient way to automatically calculate sums in an Excel table.

Step 1: Select the Worksheet

Click on theEmployee Hourstab 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 cellA4where it says "emilio"). Once you click inside the table, a new tab calledTable Designwill appear at the very top of your Ribbon.

Step 3: Enable the Total Row

Go to theTable Designtab on the Ribbon.

In theTable Style Optionsgroup, check the box labeledTotal 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 theTotal Hourscolumn (Column J) is calculating correctly:

Click on the cell at the bottom of theTotal Hourscolumn (J15).

A smalldrop-down arrowwill appear next to the cell. Click it.

SelectSumfrom 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.

To achieve the look where the dollar symbol is left-aligned and the decimal points are perfectly aligned vertically, you need to apply theAccountingnumber format. This is a standard requirement for professional financial statements.

Step 1: Select the Data Range

Ensure you are on theQtr 1worksheet.

Using your mouse, click and drag to select the range fromB10 to E14. This range covers all the monthly revenue data for the various locations.

Step 2: Open the Number Format Options

You can do this quickly using the Ribbon or with more precision via the Format Cells dialog:

Go to theHometab on the Ribbon.

In theNumbergroup, click the smallDialog Box Launcher(the tiny arrow in the bottom-right corner of the group). Alternatively, you can pressCtrl + 1on your keyboard.

Step 3: Configure Accounting Format

Once theFormat Cellsdialog box appears:

SelectAccountingfrom theCategorylist on the left.

Set theDecimal placesto2.

In theSymboldropdown menu, ensure$ English (United States)is selected.

ClickOK.

Key Difference: Accounting vs. Currency

Accounting Format:Aligns the$ symbol to the far leftof the cell and thedecimal points verticallyin a column, making it easier to read large lists of numbers.

Currency Format:Places the$ symbol immediately to the leftof the number, which does not allow for uniform vertical alignment of the symbols.

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 theInserttab on the Ribbon.

Look for theTextgroup (usually near the right side).

Click on theHeader & Footerbutton.

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 theFooter.

On theHeader & Footertab (which appears in the Ribbon when you are in this mode), click the button labeledGo 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 theRightbox.

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 theHeader & Footertab in the Ribbon.

In theHeader & Footer Elementsgroup, click theCurrent Datebutton.

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

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

Go to theViewtab on the Ribbon.

In theWorkbook Viewsgroup (far left), click onNormal.

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.