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 created 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 the Total row, cell C8 to calculate the second quarter sales for the three stores.
A) =SUM(C4:C6)
B) =TOT(C4-C6)
C) =TOT(C4:C6)
D) =SUM(C4_C6)

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 created 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 the Total row, cell C8 to calculate the second quarter sales for the three stores.
A) =SUM(C4:C6)
B) =TOT(C4-C6)
C) =TOT(C4:C6)
D) =SUM(C4_C6)

Quizplus · Accepted Answer

The formula for summing up the sales for the second quarter for all three stores is =SUM(C4:C6). This adds up the sales for the second quarter (columns C through E) for all three store locations (rows 4 through 6) and gives the total sales for the three stores in the second quarter. Choice A is the correct formula. Choice B is not a valid formula. Choice C has a typo (should be SUM instead of TOT) but still refers to the correct range. Choice D uses an underscore instead of a colon in the range, which is not valid.

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