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
Q52: Clicking the _ button sums the adjacent
Q60: Q61: Critical Thinking Questions Q65: Identify the letter of the choice that Q66: Critical Thinking Questions Q291: A(n) _ is an equation in a Q296: The cell in which you are working Q301: Using the order of precedence for arithmetic Q309: =D8+E8*0.5 is a complex formula. Q312: An Excel complex formula uses more than
Case 1-1
You work
Case 1-2
You are
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents