MO-210 Dumps with Practice Exam Questions Answers

Task 1: Insert a new column before column A

To insert a new column at the very beginning of your worksheet, follow these steps:

Select Column A: Click directly on the letter'A'at the top of the first column to select the entire column.

Open the Insert Menu: There are two ways to do this:

Option A (Right-Click): Right-click anywhere on the selected column and chooseInsertfrom the context menu.

Option B (Ribbon): On theHometab, go to theCellsgroup, click the arrow next toInsert, and selectInsert Sheet Columns.

Verification

Once completed, your original "Item Type" column (previously Column A) will shift toColumn B, and you will have a brand new, emptyColumn Aat the start of your worksheet.

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.

To extract specific characters from the start of a text string in Excel, you use theLEFTfunction.

Step-by-Step Solution

Navigate to the Worksheet: Click on theVehiclesworksheet tab at the bottom of your Excel window.

Select Cell B4: Click on cellB4(under the "Code" column).

Enter the Formula: Type the following formula exactly as shown: =LEFT(D4, 2)

Press Enter: Once you press Enter, Excel will look at the "Vehicle Style" in cellD4and return only the firsttwoletters.

Explanation of the Formula

LEFT: This is the function used to start counting characters from the beginning (left side) of a cell.

D4: This tells Excel which cell contains the text you want to extract from (the Vehicle Style).

2: This specifies the number of characters you want to retrieve.

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