Tabs
Row of tabs and icons at the top of the Excel window
What do you call the ribbon?
Helps you clean and organize data, as well as set rules that will be followed in the future
What is Power Query?
T or F: Power Pivot is capable of handling large volumes of data.
What is true?
What is the Fx button used for?
What are Formulas and Functions?
Control C and V
What are the shortcuts for copy and paste?
Look here if you want to add a pivot table.
What is Insert Tab?
4 Digits to the right of the decimal
What is how is currency displayed?
Visualization
What is Power Pivot's purpose?
also known as worksheets in Excel; data is entered in them
What are spreadsheets?
Used to select 2 or more non-contiguous columns
What is the Control Key?
Sort and Filter are located under which tab?
What is the data tab?
15
How many decimal places does Power Query hold?
A chart that provides a graphical representation of the data in a pivot table.
What is a pivot chart?
1985
When was Microsoft Excel first used?
Cut content & place on the clipboard
What is SHORTCUT: Control X?
Functions, Tables, Illustrations, Add-ins, Charts, Links, Comments
What are possible functions under the Insert Tab?
Text Files, CSV Files, Web
What are some file types that excel can import?
When building a pivot table, what do you drag and drop in to the grid at the bottom of the pivot table task pane?
What are fields?
32,767
How many characters can each cell in excel contain?
Control + Shift + Arrow Key
How do you extend data selection?
The number type can be defined in which tab?
What is the home tab?
Data Transformation List
What is the applied steps list?
Total, Grand Total, or Subtotal
What type of data is in the new column and row that is automatically created when you build a pivot table?
Are labeled alphabetically and are vertical
What is a column?
Control + F1
How do you show/hide the ribbon?