MO-210 Practice Exam Questions | Microsoft Office Specialist: Microsoft Word Expert (Word and Word 2019)

To filter theProfitsworksheet to display only the flavors with aTotal Profitthat isAbove Average, follow these steps:

Step 1: Access the Profits Worksheet

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

Step 2: Apply the Above Average Filter

Look at theTotal Profitheader (CellG3). If you don't see a small drop-down arrow next to it, go to theDatatab and clickFilter.

Click theFilter Drop-down Arrowin theTotal Profitheader cell.

Hover your mouse overNumber Filtersin the menu that appears.

From the side menu, selectAbove Average.

Step 3: Verify the Results

Excel will automatically calculate the average of all values in the "Total Profit" column and hide any rows that fall below that number.

You will notice the row numbers on the left are now blue, indicating a filter is active.

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 completeTask 5, you will create a 3-D Clustered Column chart on theAverage Call Timeworksheet to visualize the weekly performance of each salesperson.

Step 1: Navigate to the Worksheet

Click on theAverage Call Timetab at the bottom of your Excel window to switch views.

Step 2: Select the Data Range

You need to select the names and the call times for all five days (Monday through Friday), butexcludethe "Trend" column:

Click and drag to select cellsA3 to F14.

Note:This includes the header row (Salesperson, Mon, Tue, etc.) and all employee rows down to Michael.

Step 3: Insert the 3-D Clustered Column Chart

Go to theInserttab on the Ribbon.

In theChartsgroup, click theInsert Column or Bar Charticon (it looks like small vertical bars).

Under the3-D Columnsection, select the first option:3-D Clustered Column.

Step 4: Add the Chart Title

Click once on the default text that says "Chart Title" at the top of the new chart.

TypeAverage Call Timeand pressEnter(or click outside the text box).

Step 5: Position the Chart

Hover your mouse over a blank area of the chart (the chart area).

Click and drag the chart so it is positionedbelow the table.

Placement Tip:Usually, starting the chart around row 17 or 18 is ideal so it doesn't overlap your data.