Please please step by step I’m confused ??? Working with Large Worksheets, Charting, and What-If Analysis Excel Module 3 EX 1752. Enter a formula in cell G5 that divides the sum of cells C5 through F5 by cell B5. Writethe formula so that when you copy the formula to cells G6 and G7, Excel adjusts all the cellreferences according to the destination cells. Verify your formula by checking it against thevalues found in cells G5, G6, and G7 in Figure 3-83.3. Enter a formula in cell C9 that divides the sum of cells C5 through C7 by cell C4. Write theformula using an absolute cell reference so that when you copy the formula to cells D9:F9, cellC4 remains absolute. Verify your formula by checking it against the values found in cells C9,D9, E9, and F9 in Figure 3-83.4. Enter a formula in cell H5 that divides the sum of cells C5:F5 by cell B5. Write the formulausing an absolute cell reference so that when you copy the formula to cells H6 and H7, cell B5remains absolute. Verify your formula by checking it with the values found in cells H5, H6, andH7 in Figure 3–83.5. Apply the worksheet name, Cell References, to the sheet tab and apply the Orange, Accent 2Theme color to the sheet tab.6. If requested by your instructor, add a dash followed by your name to the worksheet title in cell A1.7. Save the workbook using the file name, Apply 3-1 Absolute Cell References Complete. Submitthe revised workbook as specified by your instructor.8. * How would you rewrite the formula in cell H5 using relative and mixed cell referencesonly, to come up with the same result as showing in Figure 3–83, and to produce the resultscurrently showing in cells G6 and G7 in cells H6 and H7 when the formula in cell H5 is copiedto those cells?STUDENT ASSIGNMENTS Excel Module 3 EX 174 Excel Module 3 Working with Large Worksheets, Charting, and What-If AnalysisApply Your KnowledgeReinforce the skills and apply the concepts you learned in this module.Note: To complete this assignment, you will be required to use the Data Files. Please contact yourinstructor for information about accessing the required files.Understanding Logical Tests and Absolute Cell ReferencingInstructions Part 1: For each of the following logical tests, indicate whether an IF function in Excelwould return a value of True or False; given the following cell values: C2 = 88; H12 = 15; L3 = 24;M14 = 150; and G4 = 5.%3DReturned value:1. C2 > H122. L3 = G43. M14 + 15 *H12 / 10 <= L34. M14 – G4 = L3 – (C2 / 4) * 2Returned value:6. L3 + 300 > H12 * G4 + 10Returned value:7. G4 * M14 >= 2 * (H12 + 25)Returned value:8. H12 = 10 * (C2 / 8)Returned value:Instructions Part 2: Write cell L23 as a relative reference, absolute reference, mixed reference withthe column varying, and mixed reference with the row varying.smoue o isco sluiho en of sulsv aInstructions Part 3: Run Excel. Open the workbook Apply 3-1 Absolute Cell References. You willre-create the numerical grid pictured in Figure 3-83.FileHomensertPage LayoutFoirX Cut11 -A A-Wiap TestCalibriGeneralB CopyPaste** Conditional FormatFormatting- TableBIU- 8 -O A. Marge & Cente$- % *Format PainterClipboardFontArgumantNumberStylesA2EG 4ABDKLMNWriting Formulas with Absolute and Re2.344325347421 7.333333 7.33333366635 6.6666677.65473.5444693.232.410Figure 3-83Perform the following tasks:1. Enter a formula in cell C8 that divides the sum of cells C5 through C7 by cell C4. Write theformula so that when you copy it to cells D8:F8, Excel adjusts all the cell references accordingto the destination cells. Verify your formula by checking it against the values found in cells C8,D8, E8, and F8 in Figure 3-83.

Description of what needs to be done is in the question itself. And so refering to the formula in…

Working with Large Worksheets, Charting, and What-If Analysis Excel M 2. Enter a formula in cell G5 that divides the sum of cells C5 through F5 by cell B5. Write the formula so that when you copy the formula to cells G6 and G7, Excel adjusts all the cell references according to the destination cells. Verify your formula by checking it against the values found in cells G5, G6, and G7 in Figure 3-83.