Short Answer
Critical Thinking Questions
Case 1-1
You work in the Sales department of a company that has three store locations. You are creating a summarized worksheet about the company's sales to send to the General Manager. The accompanying figure is the worksheet that you have created so far.
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)
Correct Answer:

Verified
Correct Answer:
Verified
Q2: When you embed a worksheet object in
Q22: Which of the following removes only the
Q79: An Excel user should use a relative
Q173: An absolute cell reference changes the cell
Q296: The area inside the horizontal and vertical
Q397: Which of the following will NOT be
Q398: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX8818/.jpg" alt=" As shown in
Q400: Critical Thinking Questions <br>Case 1-1 <br>Your manager
Q404: Identify the letter of the choice that
Q405: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX8818/.jpg" alt=" In the accompanying