excel

16. The formula to put in E176 that will give me the sum of all the units sold by the indicated sales rep and product Total Units Che Product Product 1 1270 SalesRep 9/21/2013 Sloux 9/24/2013 Sioux 9/24/2013 Phil 9/22/2013 Phil 9/23/2013 Chelia 9/24/2013 Sloux 9/23/2013 Chelia 9/24/2013 Sioux Product 1 Product 2 Product Product 2 Product 1 Product 1 Product 1 Product 2 1897 1062 581 383 601 3. SUM[F179:F186,=IF(D176="Product 1",#AND#,C176="Chelia")) b. SUMIES(F179:F186,D179:D186,C176,E179:E186,D176) IFSUM(F179:F186),C176-"Chelia"&D176="Product 1" d. There is no such formula 17. The keyboard shortcut to toggle between anchored cells (S) and unanchored cells (no S) is: 3. FA b. Alt+F4 c. Crl+S d. Alt+s