Illustrated Excel 2019 | Module 11: SAM Project 1b Top Hits скачать в хорошем качестве

Illustrated Excel 2019 | Module 11: SAM Project 1b Top Hits

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. Illustrated Excel 2019 | Module 11: SAM Project 1b Top Hits ANALYZE DATA AND CORRECT FORMULAS PROJECT STEPS Carla Amaya recently started a small business in Takoma Park, Maryland, specializing in search engine optimization (SEO) and social media marketing for other businesses. In an Excel workbook, Carla is tracking the projects she manages and their invoice amounts. She asks for your help in analyzing the project data and correcting errors. Go to the SEO Projects worksheet. Correct the errors in the worksheet as follows: In cell H7, trace the errors in the formula to identify the cause of the error message. Correct the formula so that the IF function tests whether the start date (the range named SEO_Start) is less than the date in cell C4. If it is, multiply the billable amount (cell G7) by the discount rate (cell H4) and return the result. If it is not, return the billable amount (cell G7) in cell H7. Copy the formula in cell H7 into the range H8:H16 to fix the errors in that range. In cell H17, use Error Checking to find the formula error, and then correct the formula. Correct the formula error in cell G17. After entering the project code data in the range E7:E16, Carla applied data validation to the range to make sure she and others entered the correct codes. Check for data-entry errors and correct them as follows: Circle invalid data in the worksheet. Change the circled value to 230 to use the correct project code. In the range J12:K17, Carla has created an area for analyzing the projects for specific types of services. She wants to analyze the sales of redesign projects because they have the highest billable amounts. Create formulas to analyze this data as follows: In cell K14, enter a formula using the COUNTIF function to count the number of redesign projects. Use the list of project codes (range E7:E16) as the range and the code for redesign services (250) as the criteria in your formula. In cell K15, enter a formula using the AVERAGEIF function to find the average billable amount for redesign projects. Use the list of project codes as the range, the code for redesign services as the criteria, and the discounted amounts (range H7:H16) as the range to average in your formula. In cell K16, use the SUMIF function to find the total billable amount of redesign projects. Use the list of project codes as the range, the code for redesign services as the criteria, and the discounted amounts as the range to sum in your formula. In cell K17, Carla wants to display the profit margin for redesign projects, which is contained in another worksheet. Create a formula using an external reference as follows to include the profit margin: Open the workbook Support_EX19_11b_Redesign.xlsx. In cell K17 of the SEO Projects worksheet, insert a formula that references cell C7 in the Support_EX19_11b_Redesign.xlsx workbook. Close the Support_EX19_11b_Redesign.xlsx workbook. Carla has defined a name for cell K17, but wants to change it to one more similar to the text in cell J17. Edit the defined name for cell K17 to use Profit_Margin as the name. [Mac Hint: Delete the old defined name and create a new defined name.] Go to the Social Media Projects worksheet. In the range F7:F15, Carla needs to enter a formula to calculate the end dates for the projects, which have a duration of 90 days. She wants to use a defined name in the formula as she did on the SEO Projects worksheet. Calculate the expiration dates as follows: Examine the formula in cell H7, which uses a defined name to calculate the sale price. Assign the same defined name (Social_Start) to the range D7:D15, which resolves the errors in column H. In cell F7, enter a formula without using a function to determine the project end date by adding 90 to the defined name Social_Start. Fill the range F8:F15 with the formula in cell F7. The workbook contains a defined name Carla no longer needs. Delete the defined name inv_num (but not the data) from the workbook. In the range J6:M11, Carla wants to list data about new social media clients who have not signed a contract yet. On a separate worksheet named New Clients, she imported the data, but it did not appear in #samproject1b #samprojects #cengageassignments #IL_EX19_11b #IL_EXCEL #excel_assignments #excel_sam_projects #Module11SamProjectb #top_hits #illustrated_excel #IL_EX19_11b_FirstLastName_1.xlsx #IL_EX19_11b_FirstLastName_2.xlsx