SOLVE WITH FORMULA MATRIX EXCEL

3 For each applied problem, use Excel formulas and functions to calculate the solutions. 5 Problem 1: Two saleersons sell two models of new cars. luxury and compact. The August and 6 eptember gross dollar sales for each month are recorded in the matrices below. September August Compact Luxury Compact Luxury 11 Salesperson 1 54,000.00 88,000.00 Salesperson 1 $228,000.00 368,000.00 Salesperson 2 $304,000.00 s 322,000.00 salesperson 2 $126,000.00 14 What were the combined gross dollar sales in August and September for each salesperson and model typ Problem 1 Problem 2 Problem 3 Problem 4 Problem 5 Problem 6 Problem 7 Prob x H 1 Formula B 0:19 A