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

To completeTask 4, you will use theUPPER functionin Excel. This function converts all characters in a specified cell into capital letters.

Step 1: Navigate to Cell I4

Ensure you are on theEmployee Hoursworksheet and click on cellI4(the first cell under theNamecolumn).

Step 2: Enter the UPPER Function

Type the following formula into cellI4:

=UPPER(A4)

A4: This refers to the cell containing the name "emilio".

UPPER: This command tells Excel to change those letters to "EMILIO".

Step 3: Fill the Column

Since your data is in a table format, Excel may automatically populate the rest of the column. If it does not:

Click on cellI4.

Hover over thebottom-right cornerof the cell until you see thethin black cross (+).

Double-clickthat cross ordrag it downto cellI14to convert the remaining names to uppercase.

Final Result Check:

CellA4shows "emilio".

CellI4should now showEMILIO.

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.

To completeTask 3, you will use theIF functionto create a logical test that checks the total hours worked and returns a specific text result.

Step 1: Navigate to the Correct Cell

Ensure you are on theEmployee Hoursworksheet and click on cellH4(the first cell under theOvertimecolumn).

Step 2: Enter the IF Function

Type the following formula into cellH4:

=IF(J4>40, "Yes", "No")

Breakdown of the formula:

J4>40: This checks if the value in theTotal Hourscolumn is greater than 40.

"Yes": The value to display if the condition isTrue.

"No": The value to display if the condition isFalse.

Step 3: Copy the Function (H4:H16)

Since your data is formatted as an Excel Table, the formula might automatically fill down. If it doesn't, follow these steps to copy it to the remaining cells:

Click on cellH4to select it.

Hover your mouse over thebottom-right cornerof the cell until the cursor turns into athin black cross (+).

Click and dragthe handle down to cellH16.

Release the mouse button to apply the logic to all employees.

Final Check

Emilio (J4 = 38): Cell H4 should now displayNo.

Evan (J5 = 50): Cell H5 should now displayYes.

To display the formulas within the cells of the Qtr 2 worksheet instead of the resulting values, you can use the Show Formulas command.

Step 1: Navigate to the Qtr 2 Worksheet

Open your Excel workbook.

Click on the Qtr 2 sheet tab at the bottom of the screen.

Step 2: Enable "Show Formulas" via the Ribbon

Go to the Formulas tab on the Ribbon at the top of the Excel window.

Locate the Formula Auditing group.

Click the Show Formulas button.

Alternative Method: Keyboard Shortcut

You can quickly toggle this view on and off by pressing:

Ctrl + ` (the accent mark or backtick key, usually located to the left of the "1" key).

What to Expect

Once activated, Excel will:

Expand column widths to accommodate the formula text.

Hide the calculated results and show the actual syntax (e.g., instead of seeing $411,912, you will see =SUM(B10:D10)).

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 add a value to theTitleproperty of an Excel document, you need to access the Backstage view. This metadata is helpful for organizing and searching for files.

Step-by-Step Solution

Click on theFiletab in the top-left corner of the Excel ribbon.

Ensure thatInfois selected in the left-hand sidebar.

On the right side of the screen, you will see a section labeledProperties.

Locate the field namedTitle. If it says "Add a title," click directly on that text.

TypeNew Ratesinto the text box.

Click anywhere else on the screen or pressEnterto save the property.

Click theBack arrowin the top-left corner to return to your worksheet.

To completeTask 1: Remove the conditional formatting from the table on the Feed Inventory worksheet, follow these steps:

Step 1: Select the Target Worksheet

First, ensure you are on the correct worksheet as specified in the instructions.

Click on theFeed Inventorytab at the bottom of your Excel workbook.

Step 2: Select the Table or Data Range

You can remove formatting from the entire sheet, but to be precise with the "table," follow these sub-steps:

Click anywhere inside the table (the area containing the SKU#, Brand, Description, etc.).

PressCtrl + Ato select the entire table range.

Step 3: Access the Conditional Formatting Menu

Go to theHometab on the top Ribbon.

In theStylesgroup, click on theConditional Formattingbutton.

Step 4: Clear the Rules

Hover your mouse overClear Rulesnear the bottom of the drop-down menu.

A side menu will appear. SelectClear Rules from Selected Cells(if you have the table selected) orClear Rules from Entire Sheetto ensure all formatting is removed.

Final Result

Once clicked, any data bars, color scales, or highlight rules (like the light green shading seen in your screenshot) that were applied via Conditional Formatting will be removed, leaving the standard table styling

n Excel 365, the most efficient way to do this is using theAutoFillfeature or simply dragging the fill handle. Here is your step-by-step solution:

Step 1: Switch to the Correct Worksheet

Ensure you are on theAverage Call Timeworksheet. Click the red tab at the bottom of the screen to switch from the "Employee Hours" view (shown in your image) to the call time data.

Step 2: Identify the Sparkline

Locate the first cell in theTrendcolumn that already contains a Sparkline (likely cellF4or similar, depending on your layout).

Step 3: Use the Fill Handle to Copy

Hover your mouse over thebottom-right cornerof the cell containing the sparkline.

Your cursor will change from a thick white cross to athin black cross (+).

Click and dragthe fill handle down to the bottom of the column to fill all the vacant cells in the "Trend" column.

Pro Tip:Alternatively, you can simplydouble-clickthe thin black cross (fill handle), and Excel will automatically fill the sparklines down to the last row of your data.

Alternative Method: Using the Ribbon

If you prefer using the menu interface:

Select the cellwith the existing sparkline and all theempty cells below itwhere you want the sparklines to appear.

Go to theHometab.

In theEditinggroup, click theFillicon (downward arrow).

SelectDown.