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