Skill Review $1\mathrm{.}1$

The workbook for this project generates client bills from staff hours in multiple worksheets. In this project, you will complete the worksheet for staff member Jarvis to calculate the daily bill, the total billable hours per week, and the total weekly bill. The worksheet for staff member Stevens has been completed. You may use it for reference as necessary.

Skills needed to complete this project:

Working in Protected View $($Skill $1\mathrm{.}3)$

Navigating a Workbook $($Skill $1\mathrm{.}2)$

Exploring Charts $($Skill $1\mathrm{.}8)$

Entering and Editing Text and Numbers in Cells $($Skill $1\mathrm{.}4)$

Applying Number Formats $($Skill $1\mathrm{.}5)$

Entering Dates and Applying Date Formats $($Skill $1\mathrm{.}6)$

Inserting Data Using AutoFill $($Skill $1\mathrm{.}7)$

Understanding Absolute and Relative References $($Skill $1\mathrm{.}11)$

Entering Simple Formulas $($Skill $1\mathrm{.}10)$

Calculating Totals with the Quick Analysis Tool $($Skill $1\mathrm{.}14)$

Using the Recommended Charts Feature $($Skill $1\mathrm{.}9)$

Previewing and Printing a Worksheet $($Skill $1\mathrm{.}20)$

IMPORTANT: If you are a Canadian user, be sure to verify that your browser and Microsoft Office use the same country settings. See here for a Help topic on how to change your settings.

Steps to complete this project:

Mark the steps as checked when you complete them.

Open the start file EX$2021-$SkillReview$-1-1.$ The file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor, and save it$.$

If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.

NOTE: If group titles are not visible on your Ribbon, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Click the View button and check the Group Titles check box under In Ribbon, Show. Close the Excel Preferences dialog box.

Explore the workbook. If you accidentally make changes while exploring, press Ctrl $+$ Z to undo the change.

Click the worksheet tab labeled Stevens Hours.

If necessary, use the vertical scroll bar to scroll down so you can see both weeks of billable hours. $($If necessary, use the vertical scroll bar again to return to the top of the worksheet.$)$

Click cell B$2($the cell displaying the staff member$$s last name, Stevens$).$ This is the cell at the intersection of column B and row $2.$

Note that the column B and row $2$ selector boxes highlight.

Note that the status bar displays Ready, indicating that you are in Ready mode.

On the Home tab, in the Number group, look at the Number Format box at the top of the group. Note that the format for this cell is General.

Double$-$click cell B$2$ to switch to Edit mode. Note that the status bar now displays Edit, and the blinking cursor appears within the cell. If you needed to$,$ you could edit the text directly in the cell.

Press Esc to exit Edit mode and return to Ready mode.

Press Enter twice to move to cell B$4($the cell displaying the staff member$$s billable rate$).$ This cell is formatted with the Accounting Number Format $($or Custom$)$ number format.

Look in the Number Format box and note that the format for this cell is Accounting $($or Custom$).$

On the Home tab, in the Styles group, look in the Cell Styles gallery, and note that the cell style Currency is highlighted. $($If the Cell Styles gallery is collapsed on your Ribbon, click the Cell Styles button to display it$.)$

Click cell B$8($the cell displaying the number of hours for $8/1/2022).$ This cell is formatted with the Comma cell style.

Look in the Number Format box and note that the format for this cell is Accounting $($or Custom$).$

On the Home tab, in the Styles group, look in the Cell Styles gallery, and note that the cell style Comma is highlighted for this cell. $($If the Cell Styles gallery is collapsed on your Ribbon, click the Cell Styles button to display it$.)$

Note the style differences between cell B$4($Accounting Number Format, Currency style$)$ and cell B$8($Accounting Number Format, Comma style$).$

Click cell B$7($the cell displaying the date $8/1/2022$ or $8/1/22).$ This cell is formatted using the Short Date format. Note that the Number Format box displays Date.

Double$-$click cell B$14.$

Note that the status bar now displays Edit, indicating that you are in Edit mode.

This cell contains a formula to calculate the daily bill for Monday, August $1$: $=$B$12*$$B$$4$

Note that cells B$12$ and B$4$ are highlighted with colors matching the cell references in the formula.

Note that the reference to cell B$4$ is an absolute reference $($$B$$4).$

Press Esc to exit Edit mode.

Double$-$click cell B$12.$

Note that once again the status bar displays Edit, indicating that you are in Edit mode.

This cell contains a formula using the SUM function to calculate the total billable hours for Monday, August $1$: $=$SUM$($B$8$:B$11)$

In this case, the SUM function uses a single argument B$8$:B$11$ to indicate the range of cells to total.

Note that the cell range B$8$:B$11$ is highlighted with the color matching the argument in the SUM function formula.

Note that the reference to the