Critical Thinking Questions Case 1-1 You Work in the Sales

Multiple Choice

Critical Thinking Questions Case 1-1 You work in the Sales department of a company that has three store locations; Downtown, Midtown, and Uptown. You are creating a summarized worksheet about the company's sales to send to the General Manager. So far, you have create a worksheet that lists each store location in cells A4 through A6. Quarterly sales for Downtown are in cells B4 through E4, Midtown are in cells B5 through E5, and Uptown quarterly sales are in  cells B6 through E6.  Write the complete formulas for finding the Yearly Sales figures in cell F4 for the Downtown store.

A) =TOT(B4:E4)
B) =SUM(B4:E4)
C) =AVERAGE(B4:E4)
D) =ADD(B4:E4)