If you want to summarize data from multiple places and want to use formulas with cell references or 3-D references to the other worksheets that you are combining because you do not have a consistent position or category of data to use, you would use the ________ option
A) consolidate by formula
B) consolidate by position
C) consolidate by category
D) PivotTable report
Answer: A
You might also like to view...
Which of the following would be an appropriate loop header when reading data from a file to fill an array defined by:
float grades[MAX]; a) for (int i = 0; i < MAX; i++) b) for (int i = 0; i < MAX –1; i++) c) while (!fileIn.eof( )) d) while (!fileIn.eof( ) && i < MAX)
Suppose that the class Mystery is derived from the class Secret. Consider the following statements.Secret secRef = new Secret();Mystery mysRef = new Mystery();Which of the following statements is legal in Java?(i) secRef = mysRef;(ii) mysRef = secRef;
A. Only (i) B. Only (ii) C. Both (i) and (ii) D. None of these
____________________ controls are security processes that are designed by strategic planners and implemented by the security administration of the organization.
Fill in the blank(s) with the appropriate word(s).
Which of te following properties stores the index of the item selected in a list box?
Index Selection SelectedIndex SelectionIndex