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