Step 1: Select the Data Range

Navigate to the Top 20 Videos worksheet.

Click on cell A4 (this contains the rank "#1").

Hold your left mouse button down and drag diagonally to cell C8 (this contains the year "2018").

Release the mouse button. The range from Rank #1 (Minecraft) to Rank #5 (Super Smash Brothers Ultimate) should be highlighted.

Step 2: Open the Cell Styles Gallery

Make sure you are on the Home tab of the Ribbon (at the top of the window).

Look for the Styles group (usually near the middle-right of the ribbon).

Click the Cell Styles button (it may look like a dropdown arrow or a box showing style previews).

Step 3: Apply "60% - Accent 1"

In the gallery that opens, look under the "Themed Cell Styles" section.

Locate the first column of accents (usually blue or the primary theme color).

Find and click on 60% - Accent 1 .

Result: The background color of the top 5 rows in your table will change to a lighter shade (likely light blue or orange, depending on the workbook theme), matching the style requirement.

To keep rows 1 through 3 visible while you scroll down the "Sold" worksheet, you will use the Freeze Panes feature.

Step-by-Step Solution

Select Row 4 : Click on the row number 4 on the far left of the screen to select the entire row.

Note: In Excel, "Freeze Panes" freezes everything above the currently selected row.

Navigate to the View Tab : Click on the View tab in the top Ribbon menu.

Click Freeze Panes : In the Window group, click the Freeze Panes button.

Select Freeze Panes : From the drop-down menu, select the first option, Freeze Panes .

Verification

Scroll down the worksheet using your mouse or the scroll bar. You should notice that the "Clearance Sale" header and the "Item Type/Description/etc." header row (rows 1-3) stay locked at the top of the screen while the data in row 4 and below moves.

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 the Insert tab on the Ribbon.

Look for the Text group (usually near the right side).

Click on the Header & Footer button.

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

On the Header & Footer tab (which appears in the Ribbon when you are in this mode), click the button labeled Go 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 the Right box.

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 the Header & Footer tab in the Ribbon.

In the Header & Footer Elements group, click the Current Date button.

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

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

Go to the View tab on the Ribbon.

In the Workbook Views group (far left), click on Normal .

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 ensure that the text in your heading row (the table headers) is fully visible without changing the column width, you will use the Wrap Text feature.

Step-by-Step Solution

Select the Header Row: In your "Rentals" worksheet, click and drag to select the cell range A2:F2 (the orange heading row containing "Capacity," "Fleet Name," etc.).

Navigate to the Home Tab: Ensure you are on the Home tab of the Ribbon.

Apply Wrap Text:

Look for the Alignment group.

Click the Wrap Text button (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.

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 choose Insert from the context menu.

Option B (Ribbon) : On the Home tab, go to the Cells group, click the arrow next to Insert , and select Insert Sheet Columns .

Verification

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

To achieve the look where the dollar symbol is left-aligned and the decimal points are perfectly aligned vertically, you need to apply the Accounting number format. This is a standard requirement for professional financial statements.

Step 1: Select the Data Range

Ensure you are on the Qtr 1 worksheet.

Using your mouse, click and drag to select the range from B10 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 the Home tab on the Ribbon.

In the Number group, click the small Dialog Box Launcher (the tiny arrow in the bottom-right corner of the group). Alternatively, you can press Ctrl + 1 on your keyboard.

Step 3: Configure Accounting Format

Once the Format Cells dialog box appears:

Select Accounting from the Category list on the left.

Set the Decimal places to 2 .

In the Symbol dropdown menu, ensure $ English (United States) is selected.

Click OK .

Key Difference: Accounting vs. Currency

Accounting Format: Aligns the $ symbol to the far left of the cell and the decimal points vertically in a column, making it easier to read large lists of numbers.

Currency Format: Places the $ symbol immediately to the left of the number, which does not allow for uniform vertical alignment of the symbols.

To complete Task 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 the Data tab on the top Ribbon.

In the Get & Transform Data group, click on From Text/CSV .

Step 2: Locate the File

A file browser window will open. Navigate to the GMetrixTemplates folder.

Select the file named NewFeeds.txt .

Click Import .

Step 3: Configure the Import Preview

A preview window will appear. Excel should automatically detect the delimiter (usually a tab or comma).

Ensure the File Origin and Delimiter look correct in the preview.

Instead of clicking "Load," click the arrow next to the Load button and select Load To... .

Step 4: Import as a Table on a New Worksheet

In the Import Data dialog box that appears, select the radio button for Table .

Under "Where do you want to put the data?", select New worksheet .

Click OK .

Final Result

Excel will create a brand new sheet (e.g., "Sheet2") and place the contents of NewFeeds.txt inside a formatted Excel Table.