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)

Question

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)

Quizplus · Accepted Answer

The correct formula for finding the Yearly Sales figures is "=SUM(B4:E4)" because it adds the quarterly sales figures for Downtown. TOT and ADD are not functions in Excel, and AVERAGE would give the average quarterly sales, not the yearly sales.

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