please put the answers in excel formulas

9 Required: 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. 2 Note: You should use absolute references in the divisors of all formulas. 3. Use the Excel IF function and the completed vertical analysis above to answer each of the questions below