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