Key Terms

cell reference

address of a cell relative to the other cells in a worksheet

conditional formatting

feature in Excel that analyzes the cell contents and applies certain preset designs or layouts based on the content

Ctrl+Select

command that allows you to select two or more areas that are not contiguous

data analysis

scientific discipline that uses mathematical and statistical tools to measure trends

formatting

applying colors, font types, and borders to cells for styling purposes

formula

mathematical operation that may use constants or cell references, or a combination of constants and cell references

freeze panes

fixing the headers on the screen while allowing users to scroll through the rest of the data

function

mathematical or analytical operation that uses words instead of mathematical operators

header

label added to tables at the top of the columns or to the left of the rows to make the data understandable

hide

temporarily remove designated rows or columns from view

merge

combine content from two or more cells

numeric data

information made of numerals that Excel reads like a calculator to perform mathematical equations

spreadsheet

software application type that has rows and columns in a grid pattern where you can enter data to design tables and graphs and perform data analysis

text data

information made up of words, letters, numerals, or a combination

workbook

file that contains one or more worksheets

worksheet

tab within a workbook where you can input data and design tables and graphs that use the data

Wrap Text

feature that arranges the text in a cell so that it extends onto another line and increases the height of the row