New Perspectives Excel 2019 | Module 1: End of Module Project 2 Ortiz-MacMalley Electric скачать в хорошем качестве

New Perspectives Excel 2019 | Module 1: End of Module Project 2 Ortiz-MacMalley Electric

If you directly want to get the project from us then contact us on our Whatsapp. Link is given below, https://wa.me/message/PPXGSJS2TLWUA1 Whatsapp Contact Number: +91 8114420233 Email ID: excelprojectshelp@gmail.com New Perspectives Excel 2019 | Module 1: End of Module Project 2 Ortiz-MacMalley Electric Getting Started with Excel PROJECT STEPS 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. Cut the contents of the range A16:B19 and paste them into the range A12:B15. Adjust the width of column B to 14.00. Adjust the height of row 1 to 24.00. Select cells A4 and D4, then change the font size to 12 point. Enter the values shown in Table 1 into the corresponding cells in the range F6:G9. Table 1: Data for the Range F6-G9 In cell D7, change the contents to read Senior electrician (instead of just Electrician). 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. Select the formula in cell H6, then copy it to the range H7:H9. In cell B12, add a cell reference to the value of cell B10. In cell B13, add a cell reference to the value of cell H10. In cell B14, enter a formula that first adds the values of cells B12 and B13, and then multiplies the result by 0.15. In cell B15, create a formula using the SUM function to determine the total bid by adding the values in the range B12:B14. Add a default border to all sides of cell B15. 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 Verde worksheet. 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. | F | G 6 | 1 | 8.00 7 | 1 | 15.25 8 | 2 | 42.50 9 | 2 | 42.50 #samprojects #cengageassignments #NP_EX19_EOM1-2 #NP_EXCEL #excel_assignments #excel_sam_projects #Module1EndOfModuleProject2 #ortizmacmalley_electric #new_perspectives_excel #NP_EX19_EOM1-2_FirstLastName_1.xlsx #NP_EX19_EOM1-2_FirstLastName_2.xlsx