Excel Module 1 SAM End of Module Project 2 | NP_EX19_EOM1-2 | Ortiz-MacMalley Electric | Project 2
#Excel Module 1 SAM End of Module Project 2 | NP_EX19_EOM1-2
#Module 1 SAM End of Module Project 2#Excel Module 1 SAM End of Module Project 2#Module 1 SAM End of Module
#NP_EX19_EOM1-2#OrtizMacMalleyElectric#Ortiz_MacMalley_Electric#NP#End_of_Module
#Cengage#SAM#NP_EX19_EOM1-2_FirstLastName_1.xlsx
Contact:
WhatsApp : +92 3261513851
Email : mypearson100@gmail.com
Direct WhatsApp link
[ Ссылка ]
• Open the file NP_EX19_EOM1-2_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as NP_EX19_EOM1-2_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• With the file NP_EX19_EOM1-2_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
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.
2. Cut the contents of the range A16:B19 and paste them into the range A12:B15.
3. Adjust the width of column B to 14.00.
4. Adjust the height of row 1 to 24.00.
5. Select cells A4 and D4, then change the font size to 12 point.
6. Enter the values shown in Table 1 into the corresponding cells in the range F6:G9.
Table 1: Data for the Range F6-G9
F G
6 1 8.00
7 1 15.25
8 2 42.50
9 2 42.50
7. In cell D7, change the contents to read Senior electrician (instead of just Electrician).
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.
9. Select the formula in cell H6, then copy it to the range H7:H9.
10. In cell B12, add a cell reference to the value of cell B10
