hello i was looking for some help with these question im newer to marco and am not exactly sure what im doing.

AutoSave OFF " HP ? C ... Assignment 4 - Document Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 10 AA ag Wrap Text General V v Paste BI UV A Merge & Center v v % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data X V fx B C D E G H K M N 0 10 Complete the following steps for the Formula Auditing worksheet: 8. Display the direct precedents for the Cone Volume formula in cell E3. How many direct precedents does 11 2 cell E3 have? Answer with a number in cell E9. You can remove the precedent arrows when you are done. 9. Display all the dependents (direct and indirect) for the Radius in cell B6. In cell E10 list all of the dependents for cell B6, separated by commas. For example, if there are two dependents - Al and A2, then list them as A1,A2. You 12 4 can remove the dependent arrows when you are done. 13 14 W N N 0.0 60 0 .0% Grading Button Form Control Formula Auditing Checking for Issues Government Addresses Measurement Converter + Ready - + 100%AutoSave OFF " HP ? C ... Assignment 4 - Document Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 10 AA ag Wrap Text v General V v Paste BIUv A Merge & Center v % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data C27 X V fx D G H M N Grade Available 1. Save the file with the name Firstname Lastname - Assignment 4, where Firstname and Lastname are replaced with your first and last names. Note that this file is of type Excel Macro-Enabled Workbook. Make sure to keep it in this format otherwise not 1 all of your answers will be saved and therefore cannot be graded. Complete the following steps for the Button Form Control worksheet: 2. Create a button form control and assign it to the pre-existing macro named Hello. 2 3. Change the text in the button form control to the word Hello. 6 2 4. Change the text font size of the button to 20 and the font to Stencil 5. Change the dime form control to a height of 2 cm (0.79 inches) and a width of 4 cm (1.57 inches). 2 Make sure you know which measurement units that you have Excel set to - cm or inches. 1 6. Move the button so that the upper left corner is located in cell A3 1 7. Test the button form control on cells E3 and F4 to ensure that it runs the macro. 10 N W N N 0.0 60 31 0.0% 32 39 40 Grading Button Form Control Formula Auditing Checking for Issues Government Addresses Measurement Converter + Ready - + 100%AutoSave OFF WAPV C... Assignment 4 - Document Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 16 AA D Wrap Text v General Paste BIUV A Sort & Analyze = Merge & Center v v % 9 00 Conditional Format Cell Insert Delete Format Find & Formatting as Table Styles Filter Select Data A1 X V fx Button Form Control A B C G H M N 0 P Q R U V W X AA Button Form Control N N H Grading Button Form Control Formula Auditing Checking for Issues Government Addresses Measurement Converter + Ready + 100%AutoSave OFF Assignment 4 - Document Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 18 A 207 D Wrap Text v General Paste BIUV A Merge & Center v v % 9 Conditional Format Cell Insert Delete Format Sort & Find & Analyze ormatting as Table Styles Filter Select Data A1 X V fx Calculating Total Volume of a Cone and Cylinder A B G H K L M N P Q R S U V W Calculating Total Volume of a Cone and Cylinder Diameter: Cone Volume: 0.5236 Cylinder Volume: 2.3562 Cone Height T W N H Cylinder Height: 6 Radius Total Volume: 2.8798 Cone Height How many direct precedents does cell E3 have? List all the dependents of the Radius (cell B6): Cylinder Height Diameter Grading Button Form Control Formula Auditing Checking for Issues Government Addresses Measurement Converter + Ready - + 100%