Microsoft MO-210 Practice Test Questions 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 transfer the formatting from theProfitsworksheet to theCostsworksheet while maintaining consistency, follow these steps:

Step 1: Copy the Source Formatting

Click on theProfitsworksheet tab at the bottom of your Excel window.

Select the cell rangeA2:G2.

On theHometab, in theClipboardgroup, click theFormat Painterbutton (it looks like a paintbrush).

Tip: Your cursor will now have a small paintbrush icon next to it, indicating the formatting is "loaded" and ready to be pasted.

Step 2: Apply Formatting to the Destination

Click on theCostsworksheet tab (the one shown in your provided image).

Click directly onCell A2(the cell containing "Production Costs (per pound)").

Excel will automatically apply the formatting across the range starting from A2 to match the original source.

Final Result

The cell range in theCostsworksheet should now match the style (font, background color, and borders) of theProfitsworksheet. The grey shading currently visible in your image in rangeB2:G2will be replaced by the style from the first 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 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 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.