EXCEL Chapter 7, Excel Chapter 7

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

PivotChart report

A graphical representation of the data in a PivotTable report.

Data Model

A method of incorporating data from multiple, related tables into an Excel worksheet.

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.

Slicer

Easy-to-use filtering control with buttons that enable you to drill down through large amounts of data.

Filter

To limit the display of data to only specific information.

Business Intelligence Tools

Used to perform data analysis and create sophisticated charts and reports

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.

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

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.

query

A database object which enables you to locate multiple records matching specified criteria.

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.

Relationship

An association between tables that share a common field.

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.

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

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.

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.

PivotTable

An interactive Excel report that summarizes and analyzes 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

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

Add-ins

Optional commands and features that are not immediately available; you must first install and/or active this before you can use it.

Associated PivotTable report

The PivotTable report in a workbook that is graphically represented in a PivotChart.

Field names

The column titles from source data that form the categories of data for a PivotTable.

Refresh

The command to update a worksheet to reflect the new data.

Source data

The data for a PivotTable, formatted in columns and rows, which can be located in an Excel worksheet or an external source.

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.

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.