Free and Premium Microsoft MO-210 Dumps Questions Answers

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.

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.

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 ensure that only a specific range of cells is printed, you need to define aPrint Area. This prevents Excel from printing empty pages or extra data outside of your selection.

Step-by-Step Solution

Select the range:Use your mouse to click on cellA1and drag your cursor down to cellF11to highlight the entire area.

Navigate to Page Layout:Click on thePage Layouttab in the top Ribbon.

Set the Print Area:

Locate thePage Setupgroup.

Click on thePrint Areabutton.

From the drop-down menu, selectSet Print Area.

Once this is set, Excel will only print the content within A1:F11, even if there is data elsewhere on the 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 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 include theTotal Profitdata in your existing chart on theChartworksheet, follow these steps:

Step 1: Navigate to the Chart

Click on theChartworksheet tab at the bottom of the Excel window.

Click once on theFlavor Expenses, Income and Profitchart to select it. When selected, you will see theChart DesignandFormattabs appear on the Ribbon.

Step 2: Open the Select Data Source Window

Go to theChart Designtab.

In theDatagroup, click on theSelect Databutton. This will open theSelect Data Sourcedialog box.

Step 3: Add the Total Profit Series

In theLegend Entries (Series)section on the left side of the dialog box, click theAddbutton.

AnEdit Serieswindow will appear:

Series name:Click on theProfitsworksheet tab and select cellG3(which contains the header "Total Profit").

Series values:Clear any existing text in the box, then highlight the rangeG4:G23on theProfitsworksheet (containing the actual profit numbers).

ClickOKon the Edit Series window.

ClickOKagain on the Select Data Source dialog box to apply the changes.

Final Result

The chart will now display a third set of bars (likely orange, as seen in your preview) representing theTotal Profitfor each flavor alongside the existing Expense and Income data.

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.