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.