EXCEL - Chapter 5, EXCEL Chapter 7, Excel Chapter 7, Excel Chapter 5
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.
Relative cell reference
A cell reference that reflects the row or column it has been copied to.
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
HTML
Hypertext Markup language. A file format used for storing Web pages.
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.
Field names
The column titles from source data that form the categories of data for a PivotTable.
Arrange All
The command that tiles all open program windows on the screen.
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.
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.
Extract area
The area where you place the results when copying the results of a filter to another location in the worksheet.
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.
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
Data Model
A method of incorporating data from multiple, related tables into an Excel worksheet.
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.
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
Wrap Text
Allows for more than one line of text within a cell. Found on the Home tab.
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.
The operator that requires each and every one of the comparison criteria that you specify must be true is the?
And operator
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.
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.
Value
Numeric data that can be used in calculations.
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
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.
Range
Selection of two or more cells.
To organize data in a particular order is a?
Sort of
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.
Cell styles
Used to apply several formats in one step.
Orientation
Used to change text orientation. Found on the Home tab.
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
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
query
A database object which enables you to locate multiple records matching specified criteria.
The command to find and select specific text, formatting, or type of information within a workbook quickly is?
Find
Conditional formatting
Formatting that is applied to a cell when a specified condition is met.