MO-210 Microsoft Excel (Microsoft 365 Apps) Free Practice Exam Questions (2026 Updated)

To transfer the formatting from theProfitsworksheet to theCostsworksheet while maintaining consistency, follow these steps:

Step 1: Copy the Source Formatting

Click on theProfitsworksheet tab at the bottom of your Excel window.

Select the cell rangeA2:G2.

On theHometab, in theClipboardgroup, click theFormat Painterbutton (it looks like a paintbrush).

Tip: Your cursor will now have a small paintbrush icon next to it, indicating the formatting is "loaded" and ready to be pasted.

Step 2: Apply Formatting to the Destination

Click on theCostsworksheet tab (the one shown in your provided image).

Click directly onCell A2(the cell containing "Production Costs (per pound)").

Excel will automatically apply the formatting across the range starting from A2 to match the original source.

Final Result

The cell range in theCostsworksheet should now match the style (font, background color, and borders) of theProfitsworksheet. The grey shading currently visible in your image in rangeB2:G2will be replaced by the style from the first sheet.

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 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 move the pie chart to its own dedicated chart sheet without using the "New Sheet" button, follow these steps:

Step 1: Select the Pie Chart

Click anywhere on the Pie Chart located on the Qtr 2 worksheet. This action will activate the contextual chart tabs on the Ribbon.

Step 2: Open the Move Chart Dialog

Once the chart is selected, look at the top of your Excel window:

Go to the Chart Design tab (this tab only appears when a chart is selected).

On the far right of the Ribbon, in the Location group, click the Move Chart button.

Step 3: Configure the New Chart Sheet

A Move Chart dialog box will appear. To move the chart to its own sheet:

Select the New sheet: radio button.

In the text box next to "New sheet:", delete the default text and type Qtr 2 Chart.

Click OK.

Result

Excel will create a new sheet tab at the bottom of your workbook named Qtr 2 Chart that contains only the pie chart, scaled to fill the entire page.

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.

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.

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 ensure every other row is shaded and that this formatting updates automatically when new rows are added, you should use theBanded Rowsfeature within theTable Designoptions.

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 theSoldworksheet (for example, cellB5). This will make the contextual "Table Design" tab appear in the Ribbon.

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

Enable Banded Rows: In theTable Style Optionsgroup, check the box labeledBanded 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 selectingInsertto see how the shading shifts automatically to maintain the pattern.