Microsoft MO-210 Microsoft Excel (Microsoft 365 Apps) Exam Practice Test

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

Step-by-Step Instructions

Navigate to the Correct Worksheet:

Click on the tab labeled Top 20 Videos at the bottom of the Excel window to ensure you are on the correct sheet.

Select Column C:

Click on the letter C in the column header to select the entire column.

Open Column Width Settings:

Method A (Ribbon): Go to the Home tab. In the Cells group (towards the right), click Format. Select Column Width... from the dropdown menu.

Method B (Right-click): Right-click directly on the column header "C". A context menu will appear. Click Column Width...

Enter the Width:

A small dialog box labeled "Column Width" will appear.

Type 2 in the box.

Click OK.

Visual Verification

Before: Column C (containing the "Year" data) is likely wider, fitting the four-digit years comfortably.

After: Column C will become very narrow. The "Year" header and the dates (like 2011, 1984) might display as hashes (####) because the column is now too narrow to display the numbers, or the text will simply be cut off. This is expected behavior for the exam task; do not widen it back out unless instructed to do so.

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 group multiple worksheets and change their tab colors simultaneously in Microsoft Excel 365, follow these steps:

Step 1: Group the Worksheets

Look at the worksheet tabs at the bottom of your Excel window.

Click on the first tab,Profits.

Hold down theCtrlkey on your keyboard.

While holdingCtrl, click on theCoststab and then theCharttab.

Note: You will notice all three tabs now have a white background, indicating they are grouped together.

Step 2: Change the Tab Color

Right-clickon any of the selected (grouped) tabs.

Hover your mouse overTab Colorin the pop-up menu.

In the color palette that appears, locate theTheme Colorssection.

Find and selectPink, Accent 4(this is usually the 8th color in the top row of the Theme Colors section).

Step 3: Ungroup the Worksheets

To finish,right-clickon any of the tabs again.

SelectUngroup Sheetsfrom the menu.

Alternatively, you can click on any worksheet tab that is not part of the group to ungroup them.

Final Result

TheProfits,Costs, andCharttabs will now all display the samePink, Accent 4color at the bottom of your workbook.

Would you like me to help you with the next task or another project?

To completeTask 5: Apply Style 5 to the chart on the Feed Inventory worksheet, follow these exact steps:

Step 1: Select the "Feed Inventory" Worksheet

Ensure you are on the correct sheet by clicking theFeed Inventorytab at the bottom of your Excel window.

Step 2: Select the Chart

Click anywhere on theTotal Inventorypie chart to select it. When selected, you will see a border around the chart and new tabs will appear on the Ribbon.

Step 3: Open Chart Design Tools

With the chart selected, look at the top Ribbon and click on theChart Designtab (this tab only appears when a chart is active).

Step 4: Apply Chart Style 5

In theChart Stylesgroup, you will see a gallery of different looks for your chart.

Hover your mouse over the styles to see their names, or click theMorearrow (the small downward arrow at the bottom right of the styles gallery) to see all options.

Locate and click onStyle 5.

Note:Style 5 typically features a specific layout of data labels and a distinct background or border style that matches the "Farm Fresh Feeds" theme.

Final Result

The pie chart will update its appearance to match Style 5, adjusting the placement of the percentage labels and the overall color shading to remain consistent with your report's professional look.

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 completeTask 2, you need to enable theTotal Rowfeature for the table on theEmployee Hoursworksheet. This is the most efficient way to automatically calculate sums in an Excel table.

Step 1: Select the Worksheet

Click on theEmployee Hourstab at the bottom of your Excel window to ensure you are on the correct sheet.

Step 2: Activate the Table

Click anywhere inside the data table (for example, click on cellA4where it says "emilio"). Once you click inside the table, a new tab calledTable Designwill appear at the very top of your Ribbon.

Step 3: Enable the Total Row

Go to theTable Designtab on the Ribbon.

In theTable Style Optionsgroup, check the box labeledTotal Row.

Result:A new row labeled "Total" will immediately appear at the bottom of your data (Row 15).

Step 4: Configure the Total Hours Calculation

By default, Excel might place a count or sum in the last column. You need to ensure theTotal Hourscolumn (Column J) is calculating correctly:

Click on the cell at the bottom of theTotal Hourscolumn (J15).

A smalldrop-down arrowwill appear next to the cell. Click it.

SelectSumfrom the list.

Final Result

Your table will now have a dedicated row at the bottom that automatically updates the total hours whenever you add or change employee data.

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.

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