Practice Free MO-210 Microsoft Excel (Microsoft 365 Apps) Exam Questions Answers With Explanation

To save a specific worksheet as a CSV file, you need to use theSave Asfunction. This allows you to change the file format from a standard Excel Workbook to a Comma Separated Values file.

Step-by-Step Solution

Ensure you are currently on theRentalsworksheet (look for the tab name at the bottom of your screen).

Click theFiletab in the top-left corner.

SelectSave Asfrom the left-hand menu.

ClickBrowseto open the File Explorer window.

In the File Explorer, navigate to theGmetrixTemplatesfolder (usually located in your Documents folder).

In theFile namebox, typeRentals.

Click theSave as typedrop-down menu and selectCSV (Comma delimited) (*.csv).

ClickSave.

Note:If Excel displays a warning message stating that some features in your workbook might be lost when saving as CSV, clickYesto continue.

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

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