Excel Chapter One

Function

1. A relationship from one set (called the domain) to another set (called the range) that assigns to each element of the domain exactly one element of the range. 2. The action or actions that an item is designed to perform.

Column Chart

A chart in which the data is arranged in columns and that is useful for showing how data changes over a period of time or for illustrating comparisons among items

Cell Style

A combination of a font, text color, cell color, and other font attributes applied to a single cell.

Chart

A graphical representation of data

Spreadsheet

A grid of rows and columns in which you enter text, numbers, and the results of calculations.

Row

A horizontal group of cells in a worksheet identified by numbers

Legend

A list that identifies patterns, symbols, or colors used in a chart

Row Heading

A number at the far-left side of a row that can be clicked to select the entire row of cells

Column

A vertical group of cells in a worksheet identified by letters

Autofit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

Auto fill

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

Series

An electric circuit with only one path through which charge can flow

Range

Distance between highest and lowest scores in a set of data.

Chart Styles

Formatting applied to a chart based on the colors, fonts, and effects associated with the workbook's theme.

Operators

In problem solving, permissible moves that can be made toward a problem's solution.

Normal View

PowerPoint's default view that displays the Slide pane and the Thumbnail pane. the default view in a presentation, which contains the slide pane, the outline pane, the task pane, and the notes pane

Accounting Number Format

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

Comma Style

The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; Comma Style also leaves space at the right to accommodate a parenthesis when negative numbers are present.

Active cell

The active cell contains the cell pointer. There is a dark outline around the active cell.

Column Heading

The letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each 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

Worksheet

The work area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet.

Merge and Center

To combine cells and center the contents.

AutoSum

a function that automatically adds the values in the cells directly above or to the left of the active cell

Page Layout View

a screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation; this view is useful for preparing your worksheet for printing

Sparklines

miniature charts that show data trends in a worksheet range such as sales increases or decreases

Workbook

A collection of related worksheets