EXCEL - Chapter 5, EXCEL Chapter 7, Excel Chapter 7, Excel Chapter 5
Wildcard
A character such as an asterisk(* ) used to search a field when you are uncertain of the value or when you want to widen the search to include more records.
AutoFilter menu
A menu of filtering commands that display when you click one of the filter arrows in an Excel table.
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet.
template
A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets.
The term that describes filtering actions in which each additional filter that you apply is based on the current filter is?
Additive
Record
All the categories of data pertaining to one person, place, thing, event, or idea.
Wrap Text
Allows for more than one line of text within a cell. Found on the Home tab.
PowerPivot
Allows you to analyze data from multiple sources, work with multiple data tables, and create relationships between tables
PowerView
Allows you to create and interact with multiple charts, slicers, and other data visualizations in a single worksheet
Quick Explore
Allows you to drill down through PivotTable data with a single click
Workbook
An Excel file. It contains 3 worksheets by default but can have more added.
Spreadsheet
An application used to store and analyze data.
FILTER area
An area in the lower portion of the PivotTable Fields pane to position fields by which you want to filter the PivotTable report, enabling you to display a subset of data in the PivotTable report.
Conditional formatting
Formatting that is applied to a cell when a specified condition is met.
dummy data
Information you should use in place of actual data to verify the formulas in the template
Formula
Mathematical statement used to calculate a value. A formula must always begin with an equal sign.
Value
Numeric data that can be used in calculations.
Add-ins
Optional commands and features that are not immediately available; you must first install and/or active this before you can use it.
The file type developed by Adobe Systems that is a visual representation of a document is?
A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a?
Pane
Headings
Row numbers and column letters.
The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is?
Scaling
Source
Selected cells to be copied or moved.
Worksheet
Sheets in an Excel workbook.
Gridlines
Solid lines that mark off the rows and columns in a worksheet.
To organize data in a particular order is a?
Sort of
Active cell
The cell displayed with a bold border. Also called the selected cell.
Cell reference
The column letter and row number that identify a cell, such as B3.
Field names
The column titles from source data that form the categories of data for a PivotTable.
Layout section
The lower portion of the PivotTable Fields pane containing the four areas for layout; use this area to rearrange and reposition fields in the PivotTable.
Cell styles
Used to apply several formats in one step.
Orientation
Used to change text orientation. Found on the Home tab.
Sheet tab
Used to display a worksheet.
Borders
Used to format cell borders. Found on the Home tab.
Business Intelligence Tools
Used to perform data analysis and create sophisticated charts and reports
Columns
Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD.
The file type developed by Microsoft that is the visual representation of the document is?
XPS
Access
a Microsoft application used to create a database
Clustered Cone Chart
similar to a 3-D Bar chart that show trends or illustrates comparisons among items
fixed width file
stores data in columns that have a specific number of characters designated for each column.
Import Data
to bring data created in one software program into another application
transposed
to reverse or switch in placement or order; data may be easier to work with if columns and rows are switched
Arrange All
The command that tiles all open program windows on the screen.
Refresh
The command to update a worksheet to reflect the new data.
Comparison operators
=,<,> used singly or in combinations to compare two values
Field button
A button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.
Filtering button
A button on a slicer which you use to select the item by which to filter.
Clear Filter
A button that removes a filter.
Relative cell reference
A cell reference that reflects the row or column it has been copied to.
The command to find and select specific text, formatting, or type of information within a workbook quickly is?
Find
Range
Selection of two or more cells.
query
A database object which enables you to locate multiple records matching specified criteria.
PivotChart report
A graphical representation of the data in a PivotTable report.
Template
A master workbook that includes the basic elements for a particular type of workbook.
Cell Style
A set of formatting characteristics that you can apply to a cell.
Field
A single piece of information that is stored in every record.
PivotTable Fields pane
A window that lists, at the top, all of the fields—column titles—from the source data for use in the PivotTable report and at the bottom, an area in which you can arrange the fields in the PivotTable.
VALUES area
An area to position fields that contain data that is summarized in a PivotTable report or PivotChart report. The data placed here is usually numeric or financial in nature and the data is summarized—summed. You can also perform other basic calculations such as finding the average, the minimum, or the maximum.
COLUMNS area
An area to position fields that you want to display as columns in the PivotTable report. Field names placed here become column titles, and the data is grouped in columns by these titles.
ROWS area
An area to position fields that you want to display as rows in the PivotTable report. Field names placed here become row titles, and the data is grouped by these row titles.
Relationship
An association between tables that share a common field.
Circular reference
An error that occurs when a formula references the cell it is stored in.
PivotTable
An interactive Excel report that summarizes and analyzes large amounts of data.
Database
An organized collection of facts related to a specific topic.
The operator that requires each and every one of the comparison criteria that you specify must be true is the?
And operator
Adjacent cells
Cells that are next to each other.
Pointing
Clicking a cell to place its reference in a formula.
Hyperlink
Colored and underlined text that, when clicked takes you to another location in the worksheet, to another file, to a web page on the internet, or on your organization's intranet.
Format Painter
Copies cell formatting from one cell to another. Found on the Home tab.
Move data
Delete data from a worksheet and then place that data at a different location in the workbook or into another file.
Numbers sorted from highest to lowest are sorted in?
Descending order
Formula bar
Displays the active cell's contents. Located above the cells.
Name box
Displays the cell reference of the active cell. Located at the top of the worksheet.
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.
SmartArt Graphics
Graphical illustrations available within Word from a list of various categories, including List diagrams, Process diagrams, Cycle diagrams, Hierarchy diagrams, Relationship diagrams, Matrix diagrams, and Pyramid diagrams, and Picture diagrams
Row
Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576.
HTML
Hypertext Markup language. A file format used for storing Web pages.
Selected cell
Indicated by a heavy black border around the cell; also called the active cell.
Label
Text stored in a cell that cannot be used in calculations.
Associated PivotTable report
The PivotTable report in a workbook that is graphically represented in a PivotChart.
Extract area
The area where you place the results when copying the results of a filter to another location in the worksheet.
Boundary
The bar separating the column letters at the top of the worksheet.
Freeze Panes
The command to set the column and row headings so that they remain on the screen while scroll to other parts of the worksheet.
Source data
The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.
CSV (comma separated values)
The file type that saves an Excel file so that there is comma between each cell and a paragraph return at the end of each row.
Tab delimited text file
The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row.
Cell
The intersection of a row and column.
Fill handle
The solid square in the lower-right corner of a selected cell that is dragged to copy the contents of a cell to adjacent cells.
Query
The term that refers to asking a question of the data in a database.
Criteria
The term used for collections that you specify that must be matched for the record to be included in the search results.
Slicer header
The top of a slicer that indicates the category of the slicer items
Field section
The upper portion of the PivotTable Fields pane containing the fields—column titles—from your source data; use this area to add fields to and remove fields from the PivotTable.
Destination
The upper-left cell of the range where data is to be pasted.
A predesigned set of colors, fonts, lines, and fill effects that look good together is a?
Theme
Display formulas
To display formulas in the worksheet, press Ctrl + ` or Formulas - Show Formulas
Filter
To limit the display of data to only specific information.
Duplicate data
To make a copy of data and then place that copy at a different location in the worksheet or into a completely different document.
Find and Replace
a feature that scans a document, searches for occurrences of specific text, symbols or formatting, and allows a user to replace it with new text, symbols or formatting.
text file
a file that holds text without any formatting and can be opened in numerous applications
screen shots
a screen capture of whole windows or part of a window
string
a single character, word, or phrase in a cell on a worksheet
WordArt tool
allows you to make shadowed, skewed, rotated and stretched text on a chart sheet of a worksheet
screen clippings
image captures of only the part of your screen that you have selected
delimited file
one in which fields of data are separated by a character such as a comma or a tab.
