New Perspectives Excel 365 | Module 1: SAM Project B Evergreen Technology скачать в хорошем качестве

New Perspectives Excel 365 | Module 1: SAM Project B Evergreen Technology

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here, Whatsapp Contact Link: https://api.whatsapp.com/message/4B6N... Whatsapp Number: +919116641093 Gmail Id: singhal.agrawal.bharati@gmail.com We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English. New Perspectives Excel 365 | Module 1: SAM Project B Evergreen Technology PROJECT STEPS Kayla Friedrich is a sales manager at Evergreen Technology, a company that sells solar panels. She uses Excel to maintain data about the sales made by the company's sales agents. She asks you as her financial assistant to finalize the Sales and Expenses worksheets for the week. Begin on the Sales worksheet by cutting the contents of the range D1:D3 and pasting them into the range A1:A3. Adjust the width of column A using AutoFit. In cell A3, enter the text Week of May 25, 2029 to note the week. Change the width of column B to 15.00 to narrow the column. Enter the values shown in Table 1 into the corresponding cells in the range D15:D17. Table 1: Data for the Range D15-D17 Enter robin.merritt@cengage.com in cell E6. Select the range E6:E17, and then use the Flash Fill command to automatically enter email addresses into the remaining cells in the range. Change the width of column E to 35.00 to display the full text of each email address in the cell. Enter the word Total in cell B18 to identify the results of the calculations you are about to make. Kayla needs you to determine the total amount of sales made by each sales agent. In cell C18, create a formula using the SUM function to total the sales amounts (the range C6:C17). Copy the formula you created in cell C18 to cell D18 to total the expenses. Kayla also wants you to complete the summary statistics at the bottom of the worksheet. Enter the text Average Expenses in cell A22 to identify the data in cell B22. In cell B20, create a formula using the COUNTA function to determine the number of sales agents employed by the company by counting the sales agent names (the range A6:A17). Add an Outside Border to the range B20:B22 to set the cells apart from other cells in the worksheet. Switch to the Expenses worksheet. Kayla wants to make this worksheet easier to read and print. Change the orientation to Landscape. Change the Zoom level to 130% to better read the worksheet contents. In cell A2, edit the text so that it reads Expenses: Week of May 25, 2029 to include the correct date. Select the column headings (the range B5:F5) and the cell A10, and then increase the font size of the cells to 12 point to make the text more prominent. Kayla also needs you to complete the calculations on the worksheet. In cell B8, enter a formula without using a function to determine the net expenses in the North region by subtracting the Commissions (cell B7) from the Expenses amount (cell B6). Copy the formula you created in cell B8 to the range C8:E8 to display the income for the other regions. Next, calculate the total expenses, commissions, and net expenses for all four regions. Select the range F6:F8, and then apply AutoSum to calculate the totals. Apply the Wrap Text formatting to cell A10 to fit the contents within the cell borders. Adjust the height of row 10 using AutoFit to display all the text in cell A10. In cell B11, enter 5/25/2029 as the forecast date of the last update. Since you just calculated the income and totals, you no longer need the brown tip instructions in cell D11. Delete the contents of cell D11. In preparation for tracking new sales data, insert a new worksheet in the workbook, rename the worksheet Agents, and if necessary, move the new worksheet after the Expenses worksheet. | D 15 | 30,300 16 | 21,500 17 | 35,700 #samproject1b #samprojects #cengageassignments #NP_EX365_1b #NP_EXCEL #excel_assignments #excel_sam_projects #Module1SamProjectb #evergreen_technology #new_perspectives_excel #NP_EX365_1b_FirstLastName_1.xlsx #NP_EX365_1b_FirstLastName_2.xlsx