>

Excel module 4 sam project a - Sep 6, 2023 · New Perspectives Excel 2019 | Module 6:

Apr 23, 2022 · Shelly Cashman Excel 2019 | Module 4: SAM Project 1a Smith &amp

Excel Module 1 4 Sam Capstone Project, Free General Essays, Procedure To Publish A Research Paper, Expert Ghostwriting Yf, Student Life Essay Hindi Me, Essay 365, Grad School Thesis Statement 100% Success rate ...Question: Shelly Cashman Excel 365/2021 | Module 4: SAM Critical Thinking Project 1c Smith & Lyngate Insurance CREATE A LOAN ANALYSIS GETTING STARTED Save the file SC_EX365_2021_CT4c_FirstLastName_1.xlsx as SC_EX365_2021_CT4c_FirstLastName_2.xlsx Edit the file name by changing “1” to “2”.About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...New Perspectives Excel 2019 | Module 4: SAM Project 1b Stuarts Bank ANALYZE AND CHART FINANCIAL DATA Author: Note: Do not. AI Homework Help. Expert Help. Study Resources. ... View module sam 4.xlsx from ECON ECON 401 at California State University, Northridge. N... Related Textbook Solutions See more. Fundamentals of Financial Management.Question: New Perspectives Excel 2016 | Module 9: SAM Project 1b Danbury Drop-In Clinics FINANCIAL TOOLS AND FUNCTIONS GETTING STARTED Open the file NP_EX16_9b_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX16_9b_FirstLastName_2.xlsxby changing the "1" to a "2". Open the file NP_EX16_9b ...Question: strated Excel 2099 | Module 4: SAM Project 1b5. Move the chart legend to the Left position to provide more room for the data.6. Grace can see that Quarter 2 was the most profitable quarter of the year at 29%.Explode the largest slice of the pie (representing Quarter 2) by 10%.7. Go to the New Services worksheet.01 Cengage mindtap SAM Word module 4 project part 1. 01 Cengage mindtap SAM Word module 4 project part 1.Managing tasks efficiently is crucial for the success of any project. With the right tools and techniques, you can streamline your workflow and ensure that everything is on track. ...insert markers into a sparkline. 1. select the range of sparkline cells. 2. choose sparkline tools in the design tab. 3. in the styles group click the marker color button. 4. choose the desired marker color. 5. repeat as necessary. Using format painter. 1. click the desired cell you wish to copy the formatting of.Question: Shelly Cashman Excel 365/2021 | Module 4: SAM Critical Thinking Project 1c Smith & Lyngate Insurance CREATE A LOAN ANALYSIS GETTING STARTED Save the file SC_EX365_2021_CT4c_FirstLastName_1.xlsx as SC_EX365_2021_CT4c_FirstLastName_2.xlsx Edit the file name by changing “1” to “2”.Follow along as @4doxs1lab completes the Conyers Law Office assignment. Learn how to use PMT function and calculate total interest.Open the file NP_EX19_8a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX19_8a_FirstLastName_2.xlsx by changing the "1" to a "2". 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.Steps covered: Luis Palomba is in charge of community relations for Penta Insurance, a health insurance agency in Minneapolis.. Go to the Tutor Summary worksheet and then unprotect it so you can edit the contents. Luis wants to include an eye-catching title on the worksheet, which he shares with others at Penta Insurance. Insert and format WordArt as follows: a. Insert WordArt using the Fill ...Oct 3, 2023 · Excel hw 4.xlsx. School. Liberty University * *We aren't endorsed by this school. Course. BUSI 201 201. Subject. Accounting. Date. Oct 3, 2023. ... Home / Accounting; Capshaw Consulting Group INSERT AND MODIFY CHARTS Author: Madison Boyce Illustrated Excel 2019 | Module 4: SAM Project 1a Note: Do not edit this sheet. If …Click the Manage arrow, click the Excel Add-Ins option, and then click the Go button. In the Add-Ins dialog box, click the Solver Add-In check box and then click the OK button. Follow any remaining prompts to install Solver. PROJECT STEPS 1. Bruce and Doug Ferguson started Ferguson Fitness, providing comprehensive private and corporate fitness ...Click the View tab, click Page Layout tab, then click Insert tab. Make the cell active. Use the mouse. Use the arrow keys. Cell is active when a heavy border surrounds the cell. To Enter the Worksheet Titles. Run Excel and create a blank workbook in the Excel window. Click the A1 to make the cell A1 the active cell.Related Questions. New Perspectives Excel 2013 Tutorial 7 SAM Project 1b Fit Kix Footwear; Shelly Cashman Excel 2019 Module 9 SAM Critical Thinking Project 1c Maxwell Training FORMULA AUDITING DATA VALIDATION AND COMPLEX PROBLEM SOLVING GETTING STARTED Open the file SCEX19CT9cFirstLastName1Hempstead University FoundationCREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS---Disclaimer: Our videos are intended solely for educational purposes, ...Shelly Cashman Excel 2016 | Module 3: SAM Project 1a Pick Up Motors WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS GETTING STARTED Open the file SC_EX16_3a_FirstLastName_1.xlsx, Q&A Without using parentheses, enter a formula in cell F4 that determines the Projected 2022 Take-Home Pay for the employee by taking the value in cell ...Excel Modules 4-7: SAM Capstone Project. 5 May,2020. **Check The Instruction File and other files**. To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer: o Support_EX19_CS4-7a_Media.txt. o Support_EX19_CS4-7a_Properties.html.Create a formula using the PMT function. Click cell B9.Type -PMT ( in the current cell.Excel displays a ScreenTip with the arguments for the function. Note that you are using a - (negative) sign before the PMT function so that the formula will return a positive value.Click cell B6.This is the rate argument, specifying the monthly interest rate.New Perspectives Excel 365/2021 | Module 11: SAM Project 1a #newperspective #module11 #samproject1a If you directly want to get the project from us then cont...#Modules #Sam #Project#Module 1: end of module project 1 #Sam modules questions #New perspectives excel 2019 #Module 7: end of module project 1 #New perspec...#Modules #Sam #Project#Module 1: end of module project 1 #Sam modules questions #New perspectives excel 2019 #Module 7: end of module project 1 #New perspec...Computer Science questions and answers. 1. Darnell Gilliam is a sales manager at Entrée Sales, a merchandising company that provides services to retail stores. Darnell's area of concentration is grocery stores. He is using an Excel workbook to track the visits his sales representatives made and wants to eventually use the workbook to accept ...For convenience, many npm based development tools instruct users to install globally. It makes sense if the tool is used to initiate/create a project, but many such modules are als...Enter Average Weekly Usage (in Hours) in 2024 as the title of the chart. Modify the bins used in the chart by setting the Bin Width axis option to 10. New Perspectives Excel 2016 | Module 4: SAM Project la Inception Workspace ANALYZING AND CHARTING FINANCIAL DATA GETTING STARTED Open the file NP_EX16_4a_FirstLastName_1.xlsx, available …Mar 17, 2021 · Hope this helps since this one is also different than the actual practices in the lessons.Nov 30, 2021 · Shelly Cashman Excel 2019 | Module 4: SAM Project 1a Shelly Cashman Excel 2019 | Module 4: SAM Project 1a CREATE A LOAN ANALYSIS GETTING STARTED Open the file SC_EX19_4a_ FirstLastName _1.xlsx, available for download from the SAM website. Save the file as SC_EX19_4a_ FirstLastName _2.xlsx by changing the “1” to a …Shelly Cashman Excel 2019 | Module 8: Textbook Project Briana Jones GE ver. 12.0.0-rc0000 1. Non-graded - Project: Bell & Rodgers Accounting 2. To Create a 2-D Line Chart 3/3 To Format a 2-D Line Chart 0/3 In the Trendline Chart worksheet, the Line with Markers chart's title should be "Total Billable Hours 2016 - 2021". To Add a Trendline to a Chart 3/3 To Change the Theme 3/3 To Change the ...New Perspectives Excel 2019 | Module 6: SAM Project 1a #newperspective #excel #module6 #samproject1aIf you directly want to get the project from us then cont...How to complete the Excel SAM Modules 1-4 Capstone, Cello Worldwide from the Illustrated text. In this assignment we learn how to use the TODAY, IF, AND, CO...Midterm Shelly Cashman Excel 2016 Module 4 - SAM Project 1b. I can't upload the original file with the question, I can email the original file. GETTING STARTED. Open the file SC_EX16_4b_FirstLastName_1.xlsx , available for download from the SAM website. Save the file as SC_EX16_4b_FirstLastName_2.xlsx by changing the “1” to a “2”.Shelly Cashman Excel 2019Module 4 SAM Project 1b Ramos Family Home Purchase CREATE A LOAN ANALYSIS GETTING STARTED Open the file SCEX194bFirstLastName1; MOS Excel 2019 Module 6 SAM Project 1a City of Honu Point CREATE SORT AND QUERY TABLES GETTING STARTED Open the file …Computer Science. Computer Science questions and answers. helly Cashman Excel 2016 1 Module 4: SAM Project la Apply custom cell borders with a Green, Accent 6, Darker 50% (10th column, a. Add an Outline border with a Medium border style (2nd column, 5th row b. Add a Vertical Line border with a Light border style (1st column, 7th row) C. Add a ...Oct 17, 2021 ... CS110 PowerPoint Module 1 SAM Module Project 2 ... Project 2|New Perspective Excel ... Excel Module 4 End of Module Project 1: Conyers Law Offices.Excel Module 1 4 Sam Capstone Project - is a "rare breed" among custom essay writing services today. All the papers delivers are completely original as we check every single work for plagiarism via advanced plagiarism detection software.3. Create a single variable data table to determine the impact that the variable. interest rates (in the range A12:A22) will have on the total cost of the clinic. Shelly Cashman. Excel 2016 | Module 4: SAM Project 1b. a. In cell B11, create a formula without using a function that references cell. D5.Shelly Cashman Excel 2019 Module 2SAM Project 1b EdgertonNorris Shelly Cashman Excel 2019 Module 2 SAM Project 1b Format Worksheets GETTING STARTED Open the fileSCEX192bFirstLastName1; New Perspectives Excel 2016 Module 4 Textbook Project Patricia Sanders 1Are you a novice artist in need of extra color theory practice? Do you have experience and need inspiration or skills brush-up? The use of online color charts is an excellent way t...Final Excel walkthrough. Hope it's helpfulZoho is a powerful cloud-based business management software that offers a wide range of modules to help streamline various aspects of your business operations. One of the key areas...Question: Illustrated Excel 2019 | Modules 1-4: SAM Capstone Project 1a Cello Worldwide CREATE AND FORMAT A FINANCIAL ANALYSIS Illustrated Excel 2019 | Modules 1-4: SAM Capstone Project 1a Cello WorldwideNew Perspectives Excel 2019 Excel Module 3 SAM End of Module Project 1 Barrel Barnard Consulting Perform Calculations with Formulas and Functions GETTING STARTED Open the file NPEX19EOM31FirstLastName1 ... Excel SAM assesment Module 5 Exam Task EX9833 Trace errors in a formula ...Managing tasks efficiently is crucial for the success of any project. With the right tools and techniques, you can streamline your workflow and ensure that everything is on track. ...New Perspectives Excel 2019 | Module 5: SAM Project 1a #newperspective #module5 #samproject1a If you directly want to get the project from us then contact us...Apr 23, 2022 · Shelly Cashman Excel 2019 | Module 4: SAM Project 1a Smith & Lyngate InsuranceCREATE A LOAN ANALYSIS GETTING STARTED · Open the file SC_EX19_4a_ FirstLastName. Q&A Shelly Cashman Excel 2019 | Module 5: SAM Project 1a Media HubCONSOLIDATE WORKBOOK DATA GETTING STARTED · Open the file …Thank you for taking the time to watch our video on "Excel Module 5 SAM Project A. Media Hub." I sincerely hope that you find the information helpful and inf...Oct 13, 2023 · Join this channel to get access to perks:https://www.youtube.com/channel/UCrMkpdXba7ENnC0mpganL8g/joinProject Steps:1. Kayla Rowe is an investment banker at ...#Module_4:_SAM_Critical_Thinking_Project_1c | Shelly_Cashman_Access_365/2021 #Cengage #SC_AC365_2021_CT4c #SC_AC365_2021_CT4c #SC_AC365_2021_CT4c #SC_AC365#S...MS Excel. Open the file SC_EX19_CT6c_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as SC_EX19_CT6c_FirstLastName_2.xlsx by changing the "1" to a "2". 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.Gudrun is compiling spending data in preparation for a city bond offering for park funding. She wants to use Excel to create charts to illustrate some of her data and to apply a function to calculate the potential monthly and yearly costs to the city of different bond scenarios.New Perspectives Excel 2016 | Module 9: SAM Project 1a (completed solution) CMPTR Excel 2016 | Chapter 15: SAM Project 1b (completed solution) Illustrated PowerPoint 2016 | Modules 1-4: SAM Capstone Project 1a (completed solution)New Perspectives Excel 2019 | Module 10: SAM Project 1a #newperspective #module10 #samproject1aIf you directly want to get the project from us then contact u...Switch to the Spending worksheet. In the range E5:E10, add Conditional Formatting to show Solid Blue Data Bars. 2. In the range F5:F10, add Line sparklines based on the data in the range B5:E10. 3. Apply the Blue, Accent 1, Darker 25% (5th column, 5th row in the Theme Colors palette) sparkline color to the range F5:F10. #sam #spreadsheet #excel ...Sep 2, 2020 ... Excel Module 2 SAM Project A. 5.4K views · 3 years ago ...more. Linda Sessions. 5.34K. Subscribe. 19. Share. Save.View Homework Help - IL_EX19_4a_.xlsx from CISPROG-1 91345 at Chaffey College. Illustrated Excel 2019 | Module 4: SAM Project 1a Capshaw Consulting Group INSERT …Click . Click SAM assignments. Locate a project assignment and click . Click the file under Solution File to download it to your computer. Open the solution file. View the correct answers for SAM projects.insert markers into a sparkline. 1. select the range of sparkline cells. 2. choose sparkline tools in the design tab. 3. in the styles group click the marker color button. 4. choose the desired marker color. 5. repeat as necessary. Using format painter. 1. click the desired cell you wish to copy the formatting of.Subject: MS Excel Price: 10.99 Bought 12. Share With. New Perspectives Excel 2019 | Module 4: SAM Project 1a. 1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in preparation for a city bond offering for park funding. She wants to use Excel to create charts to illustrate some of her data and to ...Elden Reyes is an intern with FLO Biotech. Elden is preparing a sales summary, as well as a financial project for a prospective equipment purchase. He wants to use Excel to create charts to illustrate some of his data and to apply a function to calculate payments. Switch to the Sales by Product worksheet. In the range G7:G18, add column sparklines based on the data in the range B7:F18, and ...#Module_4:_SAM_Critical_Thinking_Project_1c | Shelly_Cashman_Access_365/2021 #Cengage #SC_AC365_2021_CT4c #SC_AC365_2021_CT4c #SC_AC365_2021_CT4c #SC_AC365#S...#Excel_Module_10_SAM_Project_B #ExcelModule10SAMProjectB #NP #EX19 #NP_EX19_10b #ExcelModule10SAMProject1b #Excel_Module_10 #ExcelModule10 #Excel_Module_10_S...MS Excel. Shelly Cashman Excel 2019 | Module 4: SAM Project 1a. CREATE A LOAN ANALYSIS. GETTING STARTED. Open the file SC_EX19_4a_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as SC_EX19_4a_FirstLastName_2.xlsx by changing the "1" to a "2". If you do not see the .xlsx file extension in the Save As ...Click . Click SAM assignments. Locate a project assignment and click . Click the file under Solution File to download it to your computer. Open the solution file. View the correct answers for SAM projects.Click Start. Download the project start file, instructions, and support files. Click Download All. Instructions tell you what you need to do to complete the project. Textbook projects don't include an instructions file. Click the module link to open the textbook for instructions. Start files are the Microsoft Office files you change when ...Aug 12, 2020 ... How to complete the Ferrante & Dahl assignment in Cengage Excel Module 1. You will learn how to copy/paste, resize columns, create a formula ...If cell B6 does not display your name, delete the file and download a new copy from the SAM website. 1 PROJECT STEPS Elden Reyes is an intern with FLO Biotech. Elden is preparing a sales summary, as well as a financial project for a prospective equipment purchase.DescriptionNew Perspectives Excel 2019 | Module 11: SAM Project 1b. Romano Collectibles. CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS. GETTING STARTED. •. Open the file NP_EX19_11b_FirstLastName_1.xlsx, available for download from the. SAM website. •. Save the file as NP_EX19_11b_FirstLastName_2.xlsx by changing the "1" to a ...Shelly Cashman Excel 2019 | Module 5: SAM Project 1a Media HubCONSOLIDATE WORKBOOK DATA GETTING STARTED · Open the file SC_EX19_5a_ FirstLastName _1.xlsx , Q&A. 1. Clients are eligible for a discount if they have a rating of "A" or do not require an email reminder. Provide this information for Brett as follows: a.New Perspectives Excel 2016 | Module 4: SAM Project 1b. Calorie Courier. ANALYZING AND CHARTING FINANCIAL DATA GETTING STARTED. Open the file NP_EX16_4b_FirstLastName_1.xlsx, available for download from the SAM website.; Save the file as NP_EX16_4b_FirstLastName_2.xlsx by changing the "1" to a "2".. If you do not see the .xlsx file extension in the Save As dialog box, do not type it.Shelly Cashman Excel 2019 | Module 4: SAM Project 1a 4. Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows: a. In cell D6, start to enter a formula using the PMT function. b. For the rate argument, divide the Rate by 12 to use the monthly interest rate. c.Cengage mindtap SAMMicrosoft Office To complete SAM Project assignments, you must use the correct installed or online version of Microsoft Office for the assigned project type.; Complete a Project To complete and submit a project assignment in SAM, download a start file, follow the project instructions and save your work, upload your files to SAM, and submit your work.Open the file NP_EX16_4b_FirstLastName_1.xlsx, available for download from the SAM website. Save the file as NP_EX16_4b_FirstLastName_2.xlsx by changing the "1" to a "2". 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.Shelly Cashman Excel 2019 Module 4: SAM Project 1b. Ramos Family Home Purchase. CREATE A LOAN ANALYSIS . GETTING STARTED. Open the file SC_EX19_4b_FirstLastName_1.xlsx, available for download from the SAM website.; Save the file as SC_EX19_4b_FirstLastName_2.xlsx by changing the “1” to a “2”.. If you do …Excel Module 1 4 Sam Capstone Project, Best Introduction In Essay For Friends, Master Coursework Or Research, How To Write A Voice Over In A Script, Free Argumentative Essays On Animal Testing, Buy World Affairs Homework, Cheap Admission Paper Writer Service UsaNew Perspectives Excel 2013 Tutorials 58 SAM Capstone Project 1a 1; New Perspectives Excel 2013 Tutorial 6 SAM Project 1a Miranda Holcomb 1; Shelly Cashman Excel 2019 Module 4 SAM Project 1a CREATE A LOAN ANALYSIS GETTING STARTED Open the file SCEX194aFirstLastName1When it comes to managing projects, having a well-structured plan is crucial for success. And what better way to create a project plan than by using an Excel template? With the wid...The. HEEEELP!! Shelly Cashman Excel 365/2021 | Module 4: SAM Project 1b. Ramos Family Home Purchase. CREATE A LOAN ANALYSIS. GETTING STARTED. Save the file SC_EX365_2021_4b_FirstLastName_1.xlsx as SC_EX365_2021_4b_FirstLastName_2.xlsx. Edit the file name by changing “1” to “2”. If you do not see the .xlsx file extension, do not type it.Open the file IL_EX19_7a_FirstLastName_1.xlsx, available for download from the SAM website. Click Continue to start the project. Save the file as IL_EX19_7a_FirstLastName_2.xlsx by changing the “1” to a “2”. 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 …New Perspectives Excel 2019 | Module 4: SAM Project 1b. Customize the new pie chart in the range G23:O39 as follows to clarify its purpose and match the format of the other pie chart: a. Enter Quarter 4 Expenses as the chart title. b. Apply Style 11 to the chart. Kayla also wants to compare the five types of expenses in each quarter.Follow along as Linda Sessions completes the Excel Module 3 SAM Project 1a: Raybridge Recruiting on Linda's Take. Learn how to enter sparklines, align text...Oct 8, 2023 · About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright ...Support: https://buymeacoffee.com/taandarWe've covered following topics:1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling ...Mar 31, 2023 · Topics covered:1. Switch to the All Employees worksheet. In cell E3, enter a formula using the HLOOKUP function as follows to determine an employee's potenti...Feb 4, 2022 · Follow along as Linda Sessions completes the Excel Module 3 SAM Project 1a: Raybridge Recruiting on Linda's Take. Learn how to enter sparklines, align text...Enter this information as follows: In cell B11, enter a formula that uses the SUM function to calculate the total profit of office supplies for 2019 (the range B5:B10 ). Copy the formula in cell B11, and then paste it in the range C11:E11, pasting the formulas only. In cell A13, insert the text 2019-2021 Profit after the word "Supplies" so that ...Sep 26, 2016 · Shelly Cashman Excel 2016 | Module 4: SAM Project 1b PT Associates FINANCIAL FUNCTIONS, DATA TABLES, AND AMORTIZATION SCHEDULES GETTING. Q&A. Please help me with this Excel assignment. These are the instructions. I have emailed the actual excel sheet and I have to follow these instructions below. Camile owns a …1. Benicio Cortez is a financial consultant with NewSight Consulting in Denver, Colorado..Go to the U.S. worksheet...2. Go to the All Locations worksheet, wh...4.8/5. Our best editors will run additional screenings to check the quality of your paper. Once your paper is completed it is check for plagiarism. Academic Level. 100% Success rate. Gombos Zoran. #21 in Global Rating. Essay, Discussion Board Post, Questions-Answers, Research paper, Coursework, Case Study, Powerpoint Presentation, Term paper ...New Perspectives Excel 2019 | Excel Module 4 SAM End of Module Project 1. 1. "Elden Reyes is an intern with, Shelly Cashman Excel 2019 | Module 4: SAM Project 1a Smith & Lyngate InsuranceCREATE A LOAN ANALYSIS GETTING , He has been tracking revenues and expenses along with customer data in an Exce, Question: Shelly Cashman Excel 365/2021 | Modules 4-7: SAM Capstone Project 1a Victoria Streaming ServiceCONSOLIDATE DA, the workbook, and then exit Excel. Follow the directions on the SAM website to submit your. completed project. Shell, Mar 28, 2023 · LINK _ https://docs.google.com/document/d/1uqwS8wMAMJuANh9lkcbRE, Shelly Cashman Excel 2019 | Module 4: SAM Project , New Perspectives Excel 2019 Excel Module 3 SAM End of Module Proje, Join our YouTube Membership community:https://www.youtube, Saxon Municipal Government1. Abdul Rassim is a fin, aragraph New Perspectives Excel 2019 | Module 10: SAM Project 1b Style, Questions covered: 9. Switch to the Profit Projections worksheet., If cell B6 does not display your name, delete the , Rio Hondo College , CIT 101 , SAM 27 POWERPOINT MODULE 1 PROJECT,, Thank you for taking the time to watch our video on "Exce, Apr 4, 2023 · About Press Copyright Contact us C, Step 1: 0.19Step 2: 1:18Step 3: 1:47Step 4: 3:04Step 5: 3:36Step 6:, Midterm Shelly Cashman Excel 2016 Module 4 - SAM Pro.