MO-210 Microsoft Excel (Microsoft 365 Apps) Questions and Answers

To complete this task in Microsoft Excel 365, follow these steps to adjust your worksheet layout.

Step 1: Switch to Page Break Preview

Open theCostsworksheet (as shown in your image).

Go to theViewtab on the top Ribbon.

In theWorkbook Viewsgroup, click onPage Break Preview.

Note: Your screen will change to show blue lines indicating where pages currently end.

Step 2: Insert the Manual Page Break

LocateRow 21(the row containing "Raspberry Chocolate").

Click on therow header for Row 21to select the entire row. This ensures the break is placedabovethis row, separating it from "Cracker Jack" (Row 20).

Navigate to thePage Layouttab on the Ribbon.

Click theBreaksbutton in the Page Setup group.

SelectInsert Page Breakfrom the dropdown menu.

Final Result

You will now see asolid blue linebetween Row 20 and Row 21. This indicates a manual page break has been set. As per your instructions, leave the worksheet in this view.

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 ensure that the text in your heading row (the table headers) is fully visible without changing the column width, you will use theWrap Textfeature.

Step-by-Step Solution

Select the Header Row:In your "Rentals" worksheet, click and drag to select the cell rangeA2:F2(the orange heading row containing "Capacity," "Fleet Name," etc.).

Navigate to the Home Tab:Ensure you are on theHometab of the Ribbon.

Apply Wrap Text:

Look for theAlignmentgroup.

Click theWrap Textbutton (usually represented by an "ab" icon with a curved arrow).

Verify the Result:The text in your headers will now automatically wrap to multiple lines if it exceeds the current width of the column.

Here are the step-by-step instructions to add theOpencommand to your Quick Access Toolbar in Excel 365:

Step-by-Step Solution

Look at the very top-left corner of your Excel window (above theFileandHometabs). This area is theQuick Access Toolbar.

Click the smalldownward-pointing arrow(Customize Quick Access Toolbar) located at the right end of the toolbar. 3. A drop-down menu will appear with a list of common commands.

Find and click onOpenin the list.

A checkmark will appear next to "Open," and theOpen icon(a yellow folder) will now permanently appear in your Quick Access Toolbar for easy access.

To keep rows 1 through 3 visible while you scroll down the "Sold" worksheet, you will use theFreeze Panesfeature.

Step-by-Step Solution

Select Row 4: Click on the row number4on the far left of the screen to select the entire row.

Note: In Excel, "Freeze Panes" freezes everythingabovethe currently selected row.

Navigate to the View Tab: Click on theViewtab in the top Ribbon menu.

Click Freeze Panes: In theWindowgroup, click theFreeze Panesbutton.

Select Freeze Panes: From the drop-down menu, select the first option,Freeze Panes.

Verification

Scroll down the worksheet using your mouse or the scroll bar. You should notice that the "Clearance Sale" header and the "Item Type/Description/etc." header row (rows 1-3) stay locked at the top of the screen while the data in row 4 and below moves.

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