Question: Steps to complete this project: Mark the steps as checked when you complete them. Open the start file EX 2 0 2 1 - SkillReview

Steps to complete this project: Mark the steps as checked when you complete them. Open the start file EX2021-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. 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 B2(the cell displaying the staff members 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 B2 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 B4(the cell displaying the staff members billable rate). This cell is formatted with the Accounting Number Format number format. Look in the Number Format box and note that the format for this cell is Accounting. 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 B8(the cell displaying the number of hours for Monday, August 1). This cell is formatted with the Comma cell style. Look in the Number Format box and note that the format for this cell is also Accounting. 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 B4(Accounting Number Format, Currency style) and cell B8(Accounting Number Format, Comma style). Click cell B7(the cell displaying the date 8/1/2022). This cell is formatted using the Short Date format. Note that the Number Format box displays Date. Double-click cell B14. 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: =B12*$B$4 Note that cells B12 and B4 are highlighted with colors matching the cell references in the formula. Note that the reference to cell B4 is an absolute reference ($B$4). Press Esc to exit Edit mode. Double-click cell B12. 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(B8:B11) In this case, the SUM function uses a single argument B8:B11 to indicate the range of cells to total. Note that the cell range B8:B11 is highlighted with the color matching the argument in the SUM function formula. Note that the reference to the cell range B8:B11 uses relative references. Press Esc to exit Edit mode. Press Tab to move to cell C12. Look in the formula bar and note that this cell contains a similar formula to the one in cell B12: =SUM(C8:C11) Press to move through cells D12 through H12. Note the formula in the formula bar for each cell. Did you notice that the cell references in the formulas in cells C12 through H12 all use relative references? The Stevens Hours worksheet contains a stacked column chart. Review the chart so you can recreate it on the Jarvis Hours worksheet. The stacked column chart to the right of the hours for the week of August 1 represents the hours worked for each client each day. The column height for each day represents the total hours worked. Each column is divided into segments representing the hours worked for each client. The number of hours worked is represented on the y axis. The dates are represented along the x axis. The chart title has been changed to: Week of 8/1/22 Now you are ready to complete the worksheet for Brian Jarvis. Navigate to the Jarvis Hours worksheet by clicking the Jarvis Hours worksheet tab. The staff members last name is spelled incorrectly. Navigate to cell B2 and edit the text so the last name is spelled correctly (Jarvis with an a instead of an e). Use Edit mode. Double-click cell B2. Edit the text to:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!