How can we help?

You can also find more resources in our Help Center.

36 terms

EXCEL - Chapter 5

vocabulary
STUDY
PLAY
Active cell
The cell displayed with a bold border. Also called the selected cell.
Adjacent cells
Cells that are next to each other.
Borders
Used to format cell borders. Found on the Home tab.
Boundary
The bar separating the column letters at the top of the worksheet.
Cell
The intersection of a row and column.
Cell reference
The column letter and row number that identify a cell, such as B3.
Cell styles
Used to apply several formats in one step.
Circular reference
An error that occurs when a formula references the cell it is stored in.
Columns
Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD.
Conditional formatting
Formatting that is applied to a cell when a specified condition is met.
Destination
The upper-left cell of the range where data is to be pasted.
Display formulas
To display formulas in the worksheet, press Ctrl + ` or Formulas - Show Formulas
Duplicate data
To make a copy of data and then place that copy at a different location in the worksheet or into a completely different document.
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.
Format Painter
Copies cell formatting from one cell to another. Found on the Home tab.
Formula
Mathematical statement used to calculate a value. A formula must always begin with an equal sign.
Formula bar
Displays the active cell's contents. Located above the cells.
Gridlines
Solid lines that mark off the rows and columns in a worksheet.
Headings
Row numbers and column letters.
Label
Text stored in a cell that cannot be used in calculations.
Move data
Delete data from a worksheet and then place that data at a different location in the workbook or into another file.
Name box
Displays the cell reference of the active cell. Located at the top of the worksheet.
Orientation
Used to change text orientation. Found on the Home tab.
Pointing
Clicking a cell to place its reference in a formula.
Range
Selection of two or more cells.
Relative cell reference
A cell reference that reflects the row or column it has been copied to.
Row
Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576.
Selected cell
Indicated by a heavy black border around the cell; also called the active cell.
Sheet tab
Used to display a worksheet.
Source
Selected cells to be copied or moved.
Spreadsheet
An application used to store and analyze data.
Template
A master workbook that includes the basic elements for a particular type of workbook.
Value
Numeric data that can be used in calculations.
Workbook
An Excel file. It contains 3 worksheets by default but can have more added.
Worksheet
Sheets in an Excel workbook.
Wrap Text
Allows for more than one line of text within a cell. Found on the Home tab.