Match the following terms to their meanings:
I. PowerPivot
II. Relationship
III. Add-in
IV. PivotChart
V. Slicer
A. A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly
B. An interactive graphical representation of the data in a PivotTable
C. An association between two related tables where both tables contain a related field of data, such as IDs
D. A built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources, create a relationship between two or more related tables within one workbook, and maintain connections
E. A third party application that adds additional functionality to Excel
D, C, E, B, A
You might also like to view...
Answer the following statements true (T) or false (F)
1. In a C# application, all buttons on a form must share the same Click event handler in form’s source code file. 2. At run time, you should not use the Designer, Toolbox, Properties window, or code editor to modify the program. 3. The terms run time, run time, and run-time all typically mean the same thing. 4. Once you have placed a Label control on a form, set its Text property to the string you want to display.
Case-Based Critical Thinking QuestionsCase 7-1Ethan is studying for a test about file names, extensions, and types. Answer the questions. Which of the following operating systems has executable files for applications with extension .app?
A. Microsoft Windows B. Apple OS X C. Sun Unix D. None of the above
When a workbook is sent as a(n) ________ via email, anyone can edit the file and any changes will need to be merged
Fill in the blank(s) with the appropriate word(s).
What do you click in the Macro dialog box after selecting the macro to which you want to apply modifications?
A. Run B. Edit C. Create D. Options