MO-210 Exam Dumps : Microsoft Excel (Microsoft 365 Apps)

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 1: Select the Data Range

Navigate to theTop 20 Videosworksheet.

Click on cellA4(this contains the rank "#1").

Hold your left mouse button down and drag diagonally to cellC8(this contains the year "2018").

Release the mouse button. The range from Rank #1 (Minecraft) to Rank #5 (Super Smash Brothers Ultimate) should be highlighted.

Step 2: Open the Cell Styles Gallery

Make sure you are on theHometab of the Ribbon (at the top of the window).

Look for theStylesgroup (usually near the middle-right of the ribbon).

Click theCell Stylesbutton (it may look like a dropdown arrow or a box showing style previews).

Step 3: Apply "60% - Accent 1"

In the gallery that opens, look under the "Themed Cell Styles" section.

Locate the first column of accents (usually blue or the primary theme color).

Find and click on60% - Accent 1.

Result:The background color of the top 5 rows in your table will change to a lighter shade (likely light blue or orange, depending on the workbook theme), matching the style requirement.

To completeTask 4: Format a range as a table with a specific style on the Organic Feed worksheet, follow these steps:

Step 1: Select the "Organic Feed" Worksheet

Navigate to the correct worksheet by clicking theOrganic Feedtab at the bottom of the Excel window.

Step 2: Select the Data Range

Highlight the specific range mentioned in the task:

Click and drag your mouse to select cells fromA3toF10.

Ensure the selection includes the header row (SKU#, Brand, Description, etc.) and all data rows down to row 10.

Step 3: Format as Table

Go to theHometab on the Ribbon.

In theStylesgroup, click theFormat as Tablebutton.

Step 4: Apply the Specific Table Style

A gallery of styles will appear. Look for theLightsection.

Find and click onLime, Table Style Light 14(this is usually the last style in the second row of the Light section, featuring a lime green header).

Step 5: Confirm Headers

A small "Format As Table" dialog box will pop up.

Ensure the checkbox forMy table has headersischecked.

ClickOK.

Final Result

The data range will now be converted into a functional table with filter buttons in the header row and the lime green styling applied.