how do you do this with formulas?

I A | a c o E MM" = r - i -. m ' Required: ' 1. Use appropriate Excel formulas to perform 1irertiincal analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. Note: Foo should use absolute references in the divisors of oiiformuios. " 2._ Use the Excel IF function and the completed vertical analysis above to answer each ot the l questions below: 5 Which product line has the highest gross prot 913? I ' Which product line has the highest net income 3355? _