Microsoft Microsoft Excel (Microsoft 365 Apps) MO-210 Exam Dumps: Updated Questions & Answers (March 2026)

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 3, you will use theIF functionto create a logical test that checks the total hours worked and returns a specific text result.

Step 1: Navigate to the Correct Cell

Ensure you are on theEmployee Hoursworksheet and click on cellH4(the first cell under theOvertimecolumn).

Step 2: Enter the IF Function

Type the following formula into cellH4:

=IF(J4>40, "Yes", "No")

Breakdown of the formula:

J4>40: This checks if the value in theTotal Hourscolumn is greater than 40.

"Yes": The value to display if the condition isTrue.

"No": The value to display if the condition isFalse.

Step 3: Copy the Function (H4:H16)

Since your data is formatted as an Excel Table, the formula might automatically fill down. If it doesn't, follow these steps to copy it to the remaining cells:

Click on cellH4to select it.

Hover your mouse over thebottom-right cornerof the cell until the cursor turns into athin black cross (+).

Click and dragthe handle down to cellH16.

Release the mouse button to apply the logic to all employees.

Final Check

Emilio (J4 = 38): Cell H4 should now displayNo.

Evan (J5 = 50): Cell H5 should now displayYes.

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 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 ensure every other row is shaded and that this formatting updates automatically when new rows are added, you should use theBanded Rowsfeature within theTable Designoptions.

Since your data is already formatted as a Table (indicated by the filter arrows in the header row), follow these steps:

Step-by-Step Solution

Select the Table: Click anywhere inside the data on theSoldworksheet (for example, cellB5). This will make the contextual "Table Design" tab appear in the Ribbon.

Go to Table Design: Click on theTable Designtab at the top of the Excel window.

Enable Banded Rows: In theTable Style Optionsgroup, check the box labeledBanded Rows.

Why this works:

Automatic Updating: Because this is a Table feature rather than manual cell shading, if you insert a new row between existing data, Excel will automatically re-calculate the "every other row" pattern to maintain the shading.

Consistency: This method ensures that even if you sort or filter the data, the alternating stripes remain consistent visually.

Verification

Look at your table; you should see that rows 4, 6, 8, etc., have a different background color than rows 5, 7, 9. Try right-clicking a row and selectingInsertto see how the shading shifts automatically to maintain the pattern.

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.

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 move the pie chart to its own dedicated chart sheet without using the "New Sheet" button, follow these steps:

Step 1: Select the Pie Chart

Click anywhere on the Pie Chart located on the Qtr 2 worksheet. This action will activate the contextual chart tabs on the Ribbon.

Step 2: Open the Move Chart Dialog

Once the chart is selected, look at the top of your Excel window:

Go to the Chart Design tab (this tab only appears when a chart is selected).

On the far right of the Ribbon, in the Location group, click the Move Chart button.

Step 3: Configure the New Chart Sheet

A Move Chart dialog box will appear. To move the chart to its own sheet:

Select the New sheet: radio button.

In the text box next to "New sheet:", delete the default text and type Qtr 2 Chart.

Click OK.

Result

Excel will create a new sheet tab at the bottom of your workbook named Qtr 2 Chart that contains only the pie chart, scaled to fill the entire page.

To add a value to theTitleproperty of an Excel document, you need to access the Backstage view. This metadata is helpful for organizing and searching for files.

Step-by-Step Solution

Click on theFiletab in the top-left corner of the Excel ribbon.

Ensure thatInfois selected in the left-hand sidebar.

On the right side of the screen, you will see a section labeledProperties.

Locate the field namedTitle. If it says "Add a title," click directly on that text.

TypeNew Ratesinto the text box.

Click anywhere else on the screen or pressEnterto save the property.

Click theBack arrowin the top-left corner to return to your worksheet.

here is the step-by-step solution for Task 1:

Step 1: Navigate to the Correct Worksheet

Click on theQtr 2worksheet tab at the bottom of the Excel window to ensure you are working on the correct data set.

Step 2: Insert the Column Sparkline

Click on cellF10(this is where the first sparkline will reside).

Go to theInserttab on the Ribbon.

In theSparklinesgroup, click onColumn.

A dialog box will appear. ForData Range, select the cells representingApr through Junfor the first row (likelyB10:D10).

Ensure theLocation Rangeis set to$F$10.

ClickOK.

Step 3: Apply the Specific Sparkline Style

With cellF10still selected, a newSparklinetab will appear at the top of your Ribbon.

Click on theSparklinetab.

Click theMorearrow (the small downward arrow at the bottom right) of theStylesgallery to see all options.

Hover over the styles to find the specific name:Gold, Sparkline Style Accent 2, Darker 25%.

Click to apply it.

Step 4: Copy the Sparkline to Remaining Cells

Select cellF10.

Hover your mouse over theFill Handle(the small green square in the bottom-right corner of the cell).

Click and drag the handle down to cellF14.

Excel will automatically generate sparklines for the other locations (Downtown, Eastside, etc.) using the same style and corresponding data rows.