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

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.

Here are the step-by-step instructions to add theOpencommand to your Quick Access Toolbar in Excel 365:

Step-by-Step Solution

Look at the very top-left corner of your Excel window (above theFileandHometabs). This area is theQuick Access Toolbar.

Click the smalldownward-pointing arrow(Customize Quick Access Toolbar) located at the right end of the toolbar. 3. A drop-down menu will appear with a list of common commands.

Find and click onOpenin the list.

A checkmark will appear next to "Open," and theOpen icon(a yellow folder) will now permanently appear in your Quick Access Toolbar for easy access.

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

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

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.

To completeTask 3, you will use theIF functionto create a logical test that checks the total hours worked and returns a specific text result.

Step 1: Navigate to the Correct Cell

Ensure you are on theEmployee Hoursworksheet and click on cellH4(the first cell under theOvertimecolumn).

Step 2: Enter the IF Function

Type the following formula into cellH4:

=IF(J4>40, "Yes", "No")

Breakdown of the formula:

J4>40: This checks if the value in theTotal Hourscolumn is greater than 40.

"Yes": The value to display if the condition isTrue.

"No": The value to display if the condition isFalse.

Step 3: Copy the Function (H4:H16)

Since your data is formatted as an Excel Table, the formula might automatically fill down. If it doesn't, follow these steps to copy it to the remaining cells:

Click on cellH4to select it.

Hover your mouse over thebottom-right cornerof the cell until the cursor turns into athin black cross (+).

Click and dragthe handle down to cellH16.

Release the mouse button to apply the logic to all employees.

Final Check

Emilio (J4 = 38): Cell H4 should now displayNo.

Evan (J5 = 50): Cell H5 should now displayYes.