Pass MO-210 Exam Guide

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.