Scrub Jay Peripherals Excel Module 3 SAM Project 1a (SOLUTION)

Complete step-by-step solution for Scrub Jay Peripherals Excel Module 3 SAM Project 1a | New Perspectives Excel Performing Calculations With Formulas And Functions within 15 minutes. In this video, I will provide a walkthrough for Scrub Jay Peripherals Excel Module 3 SAM Project 1a, so follow along to finish step-by-step solution of your assignment fast and correctly. PROJECT STEPS: Danilo Lewellen is an entrepreneur planning to manufacture and market an innovative handheld controller for virtual reality gaming. Danilo is building a business plan as he recruits investors and plans logistics for the launch of his new company, Scrub Jay Peripherals, and wants to use Excel to summarize data and create projections. 1. Switch to the Sales Projections worksheet. Use the values in the range B6:C6 to extend the incremented percentages to the range D6:H6. 2. Use the values in the range A7:A8 to extend the list of years to the range A9:A11. 3. Use AutoFill to fill the range A9:H11 with the formatting from the range A7:H8. 4. In cell B8, create a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. In this formula, use a mixed reference for cell B6 by including an absolute reference to row 6. Copy the formula from cell B8 to the range B9:B11 and then copy the formulas from the range B8:B11 to the range C8:H11. 5. Switch to the Cost Estimates worksheet. In cell A9, create a formula using the AVERAGE function that calculates the average of the values in the range A5:A7, then copy your formula to cell D9. 6. In cell A10, create a formula using the MAX function that identifies the maximum value in the range A5:A7 and then copy your formula to cell D10. 7. In cell A11, create a formula using the MIN function that identifies the minimum value in the range A5:A7 and then copy your formula to cell D11. 8. In cell B13, create a formula using the VLOOKUP function that looks up the value from cell A11 in the range A5:B7, returns the value in column 2, and specifies an exact match. Copy the formula to cell E13. 9. Switch to the Profit Projections worksheet. In cell H5, use the TODAY function to insert the current date. TIMESTAMPS 0:00 STEP 0 Introduction, Scrub J Peripherals - Performing Calculations with Formulas and Functions, Excel Module 3 SAM Project 1A 1:21 STEP 1 Switch to Sales Projections worksheet and extend percentage increment from B6:C6 to D6:H6 2:01 STEP 2 Use values in A7:A8 to extend the series to A9:A11 2:30 STEP 3 Use AutoFill to fill A9:H11 with formatting only from A7:H8 3:50 STEP 4 Create formula in B8 multiplying B7 by B6 with mixed reference, add B7, then copy to B9:B11 and C8:H11 6:24 STEP 5 Switch to Cost Estimates worksheet and create AVERAGE formula in A9, copy to D9 7:41 STEP 6 Create MAX formula in A10 8:19 STEP 7 Create MIN formula in A11, copy to D11 8:51 STEP 8 Create VLOOKUP formula in B3, copy to E13 10:36 STEP 9 Switch to Profit Projections worksheet and use TODAY function in H5 📩 Need help? I complete SAM Cengage & SIMnet projects for you. WhatsApp: +923205636783 Email: [email protected] By getting the best service ever for the Cengage & SIMnet Project, you will get 100% Score, Timely Delivery, Affordable Price, 24/7 Availability, and Customer Satisfaction Scrub Jay Peripherals Excel Module 3 SAM Project 1a #ScrubJayPeripherals #ExcelModule3 #samproject1a #Cengageprojects #samprojects #cengageassignments Subscribe for more!!