Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please give me right answers to the questions please Question 12: Musheer created a table showing the quarterly sales for each of his four stores.
please give me right answers to the questions please
Question 12: Musheer created a table showing the quarterly sales for each of his four stores. What happens when he creates an AutoSum function in cell E3? 4 5 6 1 Total Sales by Quarter (in thousands) 2 Central Midwest Northeast South 3 Answer: A B stion 12 but C. D. 22.8 65.9 35.6 34.2 19.5 36.7 45.6 21.5 9.9 10.6 D 22.3 11 29.9 21.5 5.6 16.3 O Nothing, because column E is not part of the table. O Column E becomes a calculated column, and the Sum function is automatically copied to all four table rows O The Sum function is automatically copied to all four table rows column E remains independent from the table O The Sum function is automatically copied to all table rows and columns Question 13: Which statement about structured references is true? Answer: A. B. C. D. You must enter them into the worksheet before creating a table. O Structured references modify the result of the formula in the cell they are applied. O Symbols such as + and are not used. - They are associated with Excel tables but not standard worksheet data. Question 14: Tables cannot be filtered by Answer: A. B. C. D. O text color Ocell fill color O cell contents Ocell location Question 15: What feature allows you to display only rows that meet certain criteria in a table? Answer: A. B. C. D. Filter Calculated Columns Sort Quick Analysis Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started