If you want to summarize data from multiple places and want to arrange the data in all the worksheets in identical order and location, you would use the ________ option

A) consolidate by category
B) consolidate by formula
C) PivotTable report
D) consolidate by position


Answer: D

Computer Science & Information Technology

You might also like to view...

Macros are susceptible to a virus attack.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A(n) ____ converts and executes one statement at a time while the program is running.

A. source code B. object code C. compiler D. interpreter

Computer Science & Information Technology

With the vertical-align dimension property, the value is used to raise or lower an element by length.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Match the following terms with their description

I. BI II. Digital dashboard III. KPI IV. Data model V. Relational data A. "Big picture" view of the business B. Used to analyze an organization's data C. Collection of tables D. Quantifiable measure E. Examples include a person, place, or event

Computer Science & Information Technology