MO-210 Exam Dumps - Microsoft Office Specialist: Microsoft Word Expert (Word and Word 2019) Questions and Answers

Project 1: Video Games - Task 5 Solution

Task:Insert a Footer that displays today's date on the right and then return to Normal view.

Step 1: Open the Header & Footer View

Go to theInserttab on the Ribbon.

Look for theTextgroup (usually near the right side).

Click on theHeader & Footerbutton.

Note:This will automatically switch your screen to "Page Layout" view, and you will see the header area at the top of the page.

Visual Reference:(Look for this icon in the Insert tab) [ Header & Footer ]

Step 2: Navigate to the Footer

You are currently in the Header. You need to go to theFooter.

On theHeader & Footertab (which appears in the Ribbon when you are in this mode), click the button labeledGo to Footer.

Alternative:You can simply scroll down to the bottom of the page until you see the footer boxes "Click to add footer".

Visual Reference:(Button in the Navigation group) [ Go to Footer ]

Step 3: Select the Right Section

The footer is divided into three boxes: Left, Center, and Right.

Click inside theRightbox.

Visual Reference:[ Left Box ] [ Center Box ] [ *Click Here (Right Box)* ]

Step 4: Insert the Current Date

With your cursor flashing in the right footer box, look at theHeader & Footertab in the Ribbon.

In theHeader & Footer Elementsgroup, click theCurrent Datebutton.

You will see the code &[Date] appear in the box. This is correct; it will turn into the actual date once you click away.

Visual Reference:(Icon looks like a small calendar) [ Current Date ] -> Displays as &[Date]

Step 5: Return to Normal View

Clickanywhere inside the worksheet cells(outside the footer area) to apply the change.

Go to theViewtab on the Ribbon.

In theWorkbook Viewsgroup (far left), click onNormal.

Visual Reference:(View Tab > Workbook Views) [ Normal ]

Result:You have successfully added the date to the footer. In "Normal" view, you won't see the footer anymore, but it is there and will appear when printed.

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.

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.

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.

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.

Task 1: Insert a new column before column A

To insert a new column at the very beginning of your worksheet, follow these steps:

Select Column A: Click directly on the letter'A'at the top of the first column to select the entire column.

Open the Insert Menu: There are two ways to do this:

Option A (Right-Click): Right-click anywhere on the selected column and chooseInsertfrom the context menu.

Option B (Ribbon): On theHometab, go to theCellsgroup, click the arrow next toInsert, and selectInsert Sheet Columns.

Verification

Once completed, your original "Item Type" column (previously Column A) will shift toColumn B, and you will have a brand new, emptyColumn Aat the start of your worksheet.

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

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.