I need help 12K113MAGNFile7Default60111213141516AutoSave Off 19 NP_EX16_3b_Raven MarieJones_1 ✓H Keep1718192021222324252627Home Insert Page Layout Formulas Data Review View Automate HelpNew Perspectives Excel 2016 | Module 3: SAM Project 1bYou've Got Style4 PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONSReadyExit New OptionsSheet ViewX✓ fxNormal Page Break Page CustomPreview Layout ViewsWorkbook ViewsDocumentationBCircular References: M689s sheet. If your name does not appear in cell B6, please download a new copy of thefile from the SAM website.10#NAME?Product Lookup OrdersAccessibility: InvestigateNavigation+✔Ruler0Gridlines HeadingsSearchсShow0Formula BarD0EZoom 100% Zoom toSelection0FZoom0G0New Arrange FreezeWindow All PanesHA0I0JSplitHideUnhide0KView Side by Side[DI Synchronous ScrollingReset Window PositionWindow0L0Marie JonesMBNMJSwitchWindowsEOCommentsIMacrosMacros0000Po o o o o0+ŌShareQX100% AutoSave Off 19 Instructions_NP_EX16_3b • Saved to this PC ✓File Home Insert Draw Design LayoutShow All ✔Page 2 of 41052 wordsN Text Predictions: OnReferencesAccessibility: InvestigateMailings9.Review View10.SearchIn cell C14, create a formula using the COUNTA function to count the numberof components in the Bizzy Caz clothing set (the range B20:F20). Copy theformula from cell C14 to fill the range C15:C17 without formatting to count thenumber of components for the rest of the clothing sets.The data section called Product Information Lookup uses a mix of user inputcells, output cells, and calculated cells to display various information for asingle clothing set. Format the section as follows:Apply the Input cell style to cell 15.Apply the Output cell style to the range 16:18.Apply the Calculation cell style to cell 19.11. In cell 16, create a formula using the VLOOKUP function to display the numberof items in the selected clothing set. Use the clothing set listed in cell 15 as thelookup value, the range A14:D17 as the table array, column number 2 as thecolumn index number, and FALSE as the range lookup value. Use absolutereferences for cell 15 and the range A14:D17.a.b.HelpC.12. In cell 19, create a formula without using a function that first adds the selectedboxed set's net weight (cell 18) to the packing weight (cell F5), and thendivides the value by 16 to show the shipping weight in pounds.13. The delivery service used by the company charges a higher rate for packagesweighing over 40 lbs.In cell I10, create a formula that uses the IF function to determine if apackaged clothing set is overweight by checking if the shipping weight (cell 19)is greater than 40. If this condition is true, the cell should display Yes, and if itis false, the cell should display No. (Hint: Use "Yes" for the value if true, and"No" for the value if false.)14. The company can make more profit by keeping shipping costs to a minimum.Felicia has been put in charge of the packaging redesign project, and she needsFocusMarie Jones MJComments80eEditing ✓+Ō XShare ✔100%

Question

I need help 12K113MAGNFile7Default60111213141516AutoSave Off 19 NP_EX16_3b_Raven MarieJones_1 ✓H Keep1718192021222324252627Home Insert Page Layout Formulas Data Review View Automate HelpNew Perspectives Excel 2016 | Module 3: SAM Project 1bYou've Got Style4 PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONSReadyExit New OptionsSheet ViewX✓ fxNormal Page Break Page CustomPreview Layout ViewsWorkbook ViewsDocumentationBCircular References: M689s sheet. If your name does not appear in cell B6, please download a new copy of thefile from the SAM website.10#NAME?Product Lookup OrdersAccessibility: InvestigateNavigation+✔Ruler0Gridlines HeadingsSearchсShow0Formula BarD0EZoom 100% Zoom toSelection0FZoom0G0New Arrange FreezeWindow All PanesHA0I0JSplitHideUnhide0KView Side by Side[DI Synchronous ScrollingReset Window PositionWindow0L0Marie JonesMBNMJSwitchWindowsEOCommentsIMacrosMacros0000Po o o o o0+ŌShareQX100% AutoSave Off 19 Instructions_NP_EX16_3b • Saved to this PC ✓File Home Insert Draw Design LayoutShow All ✔Page 2 of 41052 wordsN Text Predictions: OnReferencesAccessibility: InvestigateMailings9.Review View10.SearchIn cell C14, create a formula using the COUNTA function to count the numberof components in the Bizzy Caz clothing set (the range B20:F20). Copy theformula from cell C14 to fill the range C15:C17 without formatting to count thenumber of components for the rest of the clothing sets.The data section called Product Information Lookup uses a mix of user inputcells, output cells, and calculated cells to display various information for asingle clothing set. Format the section as follows:Apply the Input cell style to cell 15.Apply the Output cell style to the range 16:18.Apply the Calculation cell style to cell 19.11. In cell 16, create a formula using the VLOOKUP function to display the numberof items in the selected clothing set. Use the clothing set listed in cell 15 as thelookup value, the range A14:D17 as the table array, column number 2 as thecolumn index number, and FALSE as the range lookup value. Use absolutereferences for cell 15 and the range A14:D17.a.b.HelpC.12. In cell 19, create a formula without using a function that first adds the selectedboxed set's net weight (cell 18) to the packing weight (cell F5), and thendivides the value by 16 to show the shipping weight in pounds.13. The delivery service used by the company charges a higher rate for packagesweighing over 40 lbs.In cell I10, create a formula that uses the IF function to determine if apackaged clothing set is overweight by checking if the shipping weight (cell 19)is greater than 40. If this condition is true, the cell should display Yes, and if itis false, the cell should display No. (Hint: Use &#34;Yes&#34; for the value if true, and&#34;No&#34; for the value if false.)14. The company can make more profit by keeping shipping costs to a minimum.Felicia has been put in charge of the packaging redesign project, and she needsFocusMarie Jones MJComments80eEditing ✓+Ō XShare ✔100%

Accepted Answer

MS Excel is a powerful spreadsheet software program developed by Microsoft for Windows, macOS,…

9. In cell C14, create a formula using the COUNTA function to count the number of components in the Bizzy Caz clothing set (the range B20:F20). Copy the formula from cell C14 to fill the range C15:C17 without formatting to count the number of components for the rest of the clothing sets.