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

To display the formulas within the cells of the Qtr 2 worksheet instead of the resulting values, you can use the Show Formulas command.

Step 1: Navigate to the Qtr 2 Worksheet

Open your Excel workbook.

Click on the Qtr 2 sheet tab at the bottom of the screen.

Step 2: Enable "Show Formulas" via the Ribbon

Go to the Formulas tab on the Ribbon at the top of the Excel window.

Locate the Formula Auditing group.

Click the Show Formulas button.

Alternative Method: Keyboard Shortcut

You can quickly toggle this view on and off by pressing:

Ctrl + ` (the accent mark or backtick key, usually located to the left of the "1" key).

What to Expect

Once activated, Excel will:

Expand column widths to accommodate the formula text.

Hide the calculated results and show the actual syntax (e.g., instead of seeing $411,912, you will see =SUM(B10:D10)).

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.