New Perspectives Excel 2019 | Module 1: End of Module Project 2 Deepak Singh 1

New Perspectives Excel 2019 | Module 1: End of Module Project 2

Deepak Singh

1. Verdie Hansen is a student in an electrician training program. As part of her internship with Ortiz-MacMalley Electric, she uses Excel to update price estimates for projects that the company is bidding on. Begin on the Val Verde worksheet by inserting a new column to the left of column C, and selecting the format same as right column button from the Insert Column options menu. Then change the width of the new column to 2.25.

Insert a column.

Change the column width.

2. Cut the contents of the range A16:B19 and paste them into the range A12:B15.

Cut and paste a range of values.

3. Adjust the width of column B to 14.00

.

Change the column width.

4. Adjust the height of row 1 to 24.00

.

Change the row height.

5. Select cells A4 and D4, then change the font size to 12 point.

Change the font size.

Change the font size.

6. Enter the values shown in Table 1 into the corresponding cells in the range F6:G9.

Enter numbers in a range.

7. In cell D7, change the contents to read Senior electrician (instead of just Electrician).

Update a value in a cell.

8. In cell H10, create a formula to total the cost of labor for the current estimate by using the AutoSum

button to sum the values in the range H6:H9

Create a formula using a function.

9.  Select the formula in cell H6, then copy it to the range H7:H9.

Copy a formula into a range.

10. In cell B12, add a cell reference to the value of cell B10

.

Create a formula.

11 .In cell B13, add a cell reference to the value of cell H10

Create a formula.

12. In cell B14, enter a formula that first adds the values of cells B12 and B13 , and then multiplies the result by 0.15

Create a formula.

.

13. In cell B15, create a formula using the SUM function to determine the total bid by adding the values in the range B12:B14

.

Create a formula using a function.

14. Add a default border to all sides of cell B15.

Add a border to a cell.

15. The next bid you expect to receive estimates on is for a company called TechHive. To set up the

worksheet for this bid, create a copy of the Val Verde worksheet within the current document, then rename the new worksheet TechHive , and if necessary move it after the Val Verdeworksheet.

Copy a worksheet.

Move a worksheet.

16. On the TechHive worksheet, update the customer name in cell A1 to TechHive . Then select the range A6:G9, and clear the contents of the selection.

Clear cell contents.