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

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

New Perspectives Excel 2019 | Module 1: End of Module Project 2 #newperspectives #module1 #eom2 If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇 https://wa.me/message/PPXGSJS2TLWUA1 Whatsapp Contact Number: +91 8114420233 Email ID: [email protected] 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 Verde worksheet. 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. new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 module 2 end of module project 1,new perspectives excel 2019 module 1 sam project 1a,shelly cashman excel 2019 | module 1: sam project 1b,module 1: end of module project 2,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 | module 7: end of module project 1,module 1: end of module project 1,new perspectives excel 2019