WorksheetsSpreadsheet Terminology Review
Total questions: 18
Worksheet time: 6mins
The space formed by the intersection of a row and a column; the basic unit of a worksheet. (tiny rectangles on a spreadsheet)
Spreadsheet
Cell
Worksheet
Word Processor
A vertical group of cells in a worksheet identified by letters
Row
Column
Table
Chart
A horizontal group of cells in a worksheet identified by numbers
Table
Chart
Row
Column
The position of data within a cell
Index
Tab
Indent
Alignment
A selected worksheet cell that is ready for data entry.
Cell name
Active Cell
Cell box
Selector cell
An equation that calculates a new value using values currently on a spreadsheet.
Formula
Function
Equatiot
A function that automatically adds the values in the cells directly above or to the left of the active cell.
Average
Max
Autosum
Min
To copy a cell’s contents and/or formatting into an adjacent cell or range. (Allows Excel to recognize patterns in formulas and functions)
Paste & Review
Fill
Find & Replace
Autocopy
A unique identifier for a cell which is formed by combining the cell's column letter and row number
Cell reference
Cell box
Name box
Name location
A prewritten formula that makes it easy to perform common calculations
Function
Formula
Phase
Autocalculate
Value, cell reference, range, or text that acts as an operand in a function formula
formula
function
argument
sum
Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon
Active cell
Group
Range
Series
A cell reference that adjusts to a new location when it is copied or moved.
Absolute cell reference
Relative cell reference
Argument
Operand
A cell reference that does not adjust or change to the new cell location when it is copied or moved by using the fill handle.
Relative cell reference
Absolute cell reference
Function reference
Formula reference
Tool that allows you to apply formats to a cell or range depending on the value of the cell
Copy & Paste
Format painter
Conditional formatting
Cell formatter
A small chart in a cell that shows a visual representation of data for a row
Pie chart
Sparkline chart
Bar chart
Column chart
A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)
Symbol
Operator
Sign
Post
Displays the address of the active cell or range on the worksheet.
Cell Locator
Insert function
Formula Bar
Name box
