Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Accounting questions

Question

How do you know some orders were created after shipment?

Answered: 1 week ago

Question

What is the age of the oldest outstanding invoice?

Answered: 1 week ago