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

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

Step-by-Step Instructions (Text Only)

Step 1: Activate the correct worksheet

Open the Excel workbook provided for the project.

At the bottom of the workbook, click the Recent Releases worksheet tab to make it active.

Step 2: Select the named range “No Platform”

Click anywhere inside the worksheet.

Go to the Formulas tab on the Excel ribbon.

In the Defined Names group, click Name Manager.

In the Name Manager dialog box:

Locate the named range called No Platform.

Click No Platform to select it.

Click Close.

Excel will automatically highlight all cells included in the No Platform named range.

(Alternative method if allowed)

Click the Name Box (left of the formula bar), type No Platform, and press Enter.

Step 3: Select entire rows for the named range

With the No Platform cells selected:

Move the cursor to the row numbers on the left side of the worksheet.

Click the row number of one selected cell.

Hold down the Ctrl key.

Click each additional row number that corresponds to the selected No Platform cells until all required rows are selected.

Step 4: Delete the selected rows

Go to the Home tab on the ribbon.

In the Cells group, click the Delete drop-down arrow.

Select Delete Sheet Rows.

Step 5: Verify the result

Confirm that:

All video game titles that had no platform information are removed.

All remaining rows and worksheet content are intact.

Ensure no extra cells, columns, or headers were deleted.

Final Result

All rows associated with the No Platform named range are deleted.

All other data on the Recent Releases worksheet remains unchanged.

Task 1 is completed correctly according to Excel 365 simulation requirements.

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.

To view two instances of your Excel workbook side-by-side, follow these steps:

Step 1: Open a Second Window

Go to theViewtab on the Ribbon.

In theWindowgroup, click onNew Window.

Note: This creates a second view of your current file. You will notice the file name in the title bar now says "Filename - 2".

Step 2: Arrange Side-by-Side

Navigate back to theViewtab.

In the sameWindowgroup, click theView Side by Sidebutton.

If the windows do not align automatically, clickArrange Alland selectVerticalto see them left-to-right.

Verification

You should now see two separate windows of the same "Clearance Sale" workbook on your screen. Any change you make in one window will instantly update in the other, allowing you to view different worksheets (like "Sold" and "Vehicles") at the same time.

To completeTask 4, you will use theUPPER functionin Excel. This function converts all characters in a specified cell into capital letters.

Step 1: Navigate to Cell I4

Ensure you are on theEmployee Hoursworksheet and click on cellI4(the first cell under theNamecolumn).

Step 2: Enter the UPPER Function

Type the following formula into cellI4:

=UPPER(A4)

A4: This refers to the cell containing the name "emilio".

UPPER: This command tells Excel to change those letters to "EMILIO".

Step 3: Fill the Column

Since your data is in a table format, Excel may automatically populate the rest of the column. If it does not:

Click on cellI4.

Hover over thebottom-right cornerof the cell until you see thethin black cross (+).

Double-clickthat cross ordrag it downto cellI14to convert the remaining names to uppercase.

Final Result Check:

CellA4shows "emilio".

CellI4should now showEMILIO.