SPREAD SHEET EXAM 2
Scaling
The group of commands by which you can reduce the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify.
Detail Data
The subtotaled rows that are totaled and summarized; typically adjacent to and either above or to the left of the summary data.
Ascending
The term that refers to the arrangement of text that is sorted alphabetically from A to Z, numbers sorted from lowest to highest, or dates and times sorted from earliest to latest.
Descending
The term that refers to the arrangement of text that is sorted alphabetically from Z to A, numbers sorted from highest to lowest, or dates and times sorted from latest to earliest.
Slicer Header
The top of a slicer that indicates the category of the slicer items.
Sparklines
Tiny charts that fit within a cell and give a visual trend summary alongside data.
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 used to select the item by which to filter.
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 and at the bottom, an area in which you can arrange the fields in the PivotTable.
criteria
Conditions that you specify in a logical function or filter.
Extract Area
The location to which you copy records when extracting filtered rows.
Area 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.
Sort
The process of arranging data in a specific order.
Extract
The process of pulling out multiple sets of data for comparison purposes.
Scale
The range of numbers in the data series that controls the minimum, maximum, and incremental values on the value axis.
tick marks
The short lines that display on an axis at regular intervals.
Clear Filter
A button that removes a filter.
Picture
A category of SmartArt graphics that is used to display pictures in a diagram.
Smart art relationships
A category of SmartArt graphics that is used to illustrate connections.
Process
A category of SmartArt graphics that is used to show steps in a process or timeline.
Custom Filter
A filter with which you can apply complex criteria to a single column.
Trendline
A graphic representation of trends in a data series, such as a line sloping upward to represent increased sales over a period of months.
Pivot Chart
A graphical representation of the data in a PivotTable report.
HTML (Hypertext Markup Language)
A language web browsers can interpret.
Data model
A method of incorporating data from multiple, related tables into an Excel worksheet.
Major unit value
A number that determines the spacing between tick marks and between the gridlines in the plot area.
Pane
A portion of a worksheet window bounded by and separated from other portions by vertical and horizontal bars.
Query
A process of restricting records through the use of criteria conditions that will display records that will answer a question about the data.
List
A series of rows that contains related data that you can group by adding subtotals.
List
A series of rows that contains related data with column titles in the first row.
Field
A single piece of information for every record.
Custom list
A sort order that you can define.
Template
A special workbook that may include formatting, formulas, and other elements and is used as a pattern for creating other workbooks.
Major sort
A term sometimes used to refer to the first sort level in the Sort dialog box.
Standardization
All forms created within the organization will have a uniform appearance; the data will always be organized in the same manner.
Record
All of the categories of data pertaining to one person, place, event, thing, or idea.
Record
All the categories of data pertaining to one person, place, thing, event, or idea.
recommended charts
An Excel feature that helps you choose a chart type by previewing suggested charts based on patterns in your data.
Filters 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.
criteria range
An area on your worksheet where you define the criteria for the filter and that indicates how the displayed records are filtered.
Pivot Table
An interactive Excel report that summarizes and analyzes large amounts of data.
Password
An optional element of a template added to prevent someone from disabling a worksheet's protection.
Database
An organized collection of facts related to a specific topic.
unlocked cells
Cells in a protected worksheet that may be filled in.
Horizontal Category axis (x-axis)
Column and row headings that describe the values and help the reader understand the chart.
Lables
Column and row headings that describe the values and help the reader understand the chart.
Slicer
Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.
Tick Mark labels
Identifying information for a tick mark generated from the cells on the worksheet used to create the chart.
Locked Cells
In a protected worksheet, data cannot be inserted, modified, deleted, or formatted in these cells.
Grid lines
Lines in the plot area that aid the eye in determining the plotted values.
Comparison operators
Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.
Hyperlink
Text or graphics that, when clicked, take you to another location in the worksheet, to another file, or to a webpage on the internet or on your organization's intranet.
Associated PivotTable report
The PivotTable report in a workbook that is graphically represented in a PivotChart.
Plot Area
The area bounded by the axes of a chart, including all the data series.
Active Area
The area of the worksheet that contains data or has contained data.
Walls and floor
The areas surrounding a 3-D chart that give dimension and boundaries to the chart.
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 Excel windows on the screen.
Subtotal command
The command that totals several rows of related data together by automatically inserting subtotals and totals for the selected cells.
refresh
The command to update a PivotTable to reflect the new data.
.xlsx file name extension
The default file format used by Excel to save an Excel workbook.
Primary key
The field used to uniquely identify a record in an Access table.
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.
Compound criteria
The use of two or more criteria on the same row—all conditions must be met for the records to be included in the results.
Filter
To limit the display of data to only specific information.
embedded
chart A chart that is inserted into the same worksheet that contains the data used to create the chart.
realationship
An association between tables that share a common field.
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.
pyramid
A category of SmartArt graphics that uses a series of pyramid shapes to show relationships.
SmartArt hierarchy
A category of SmartArt graphics used to create an organization chart or show a decision tree.
Matrix
A category of SmartArt graphics used to show how parts relate to a whole.
Smart art list
A category of SmartArt graphics used to show nonsequential information.
*WILDCARD*
A character, for example the asterisk or question mark, used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records.
Legend
A chart element that identifies the patterns or colors that are assigned to the categories in the chart.
Line Chart
A chart type that is useful to display trends over time; time displays along the bottom axis and the data point values are connected with a line.
Freeze Panes
A command that enables you to select one or more rows or columns and freeze (lock) them into place so that they remain on the screen while you scroll; the locked rows and columns become separate panes.
Find
A command that locates and selects specific text or formatting.
Go To
A command that moves to a specific cell or range of cells that you specify.
Go to Special
A command that moves to cells that have special characteristics, for example, to cells that are blank or to cells that contain constants, as opposed to formulas.
Cell Style
A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
Sort dialog box
A dialog box in which you can sort data based on several criteria at once, and that enables a sort by more than one column or row.
AutoFilter Menu
A drop-down menu from which you can filter a column by a list of values, by a format, or by criteria.
Protection
A feature that prevents anyone from altering the formulas or changing other template components.
orientation
A feature with which you can rotate text diagonally or vertically in a cell and is useful when you need to label a narrow column.
PDF (Portable Document Format)
A file format developed by Adobe Systems that creates a representation of electronic paper that displays your data on the screen as it would look when printed, but that cannot be easily changed.
tab-delimited text files
A file type in which cells are separated by tabs; this type of file can be readily exchanged with various database programs.
CSV (comma-separated values)
A file type in which the cells in each row are separated by commas and an end-of-paragraph mark at the end of each row; also referred to as a comma delimited file.
Comma delimited file
A file type that saves the contents of the cells by placing commas between them and an end-of-paragraph mark at the end of each row; also referred to as a CSV (comma-separated values) file.
Advanced Filter
A filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria.
Compound filter
A filter that uses more than one condition—and one that uses comparison operators.
Vertical Value axis (y-axis)
A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.
organization chart
A type of graphic that is useful to depict reporting relationships within an organization.
Smart Art graphics
A visual representation of information and ideas.
text pane
A window that displays to the left of a SmartArt graphic, is populated with placeholder text, and is used to build a graphic by entering and editing text.
Source Data
The data for a PivotTable, formatted in columns and rows, that can be located in an Excel worksheet or an external source.
Split
The command that enables you to view separate parts of the same worksheet on your screen; it splits the window into multiple resizable panes to allow you to view distant parts of the worksheet at one time.
And comparison opertator
The comparison operator that requires each and every one of the comparison criteria to be true.
Or comparison operator
The comparison operator that requires only one of the two comparison criteria that you specify to be true.
