Spreadsheet Terms
Excel Window
Excel Features
Formulas
Charts
100
Similar to a notebook containing a collection of worksheets
What is a Workbook
100
Displays the sheet name at the bottom of a workbook
What is a Sheet Tab
100
Symbolic representation of the relationship between numbers
What is a Formula
100
Precedes a formula to alert Excel a formula or function is being entered
What is an Equal Sign (=)
100
Shows the relationship or proportion of parts to a whole
What is a Pie Chart
200
Individual sheet in a workbook organized into a grid of rows & columns
What is a Worksheet
200
Displays the active cell reference
What is the Name Box
200
Prewritten formulas
What are Functions
200
Overrides the order of operations
What are Parentheses ( )
200
Directly compares values
What is a Column Chart
300
Basic unit of a worksheet identified by the intersection of a row and column
What is Cell
300
Displays an entry as you type
What is the Formula Bar
300
Pictorially represent data
What are Charts
300
Allows you to enter formulas by selecting cells using the mouse
What is Point Mode
300
Compares two sets of numbers at once
What is an XY Scatter Chart
400
Series of two or more adjacent cells
What is a Range
400
Horizontal and vertical lines on a worksheet
What are Gridlines
400
Used to create a series of numbers, dates, months, or formulas
What is the Fill Handle
400
Process of finding and correcting errors
What is Debugging
400
Displays trends over time
What is a Line Chart
500
Cell in which you enter data surrounded by a heavy border
What is the Active Cell
500
Area used in place of a calculator to view range totals
What is the AutoCalculate Area
500
Dialog box used to assign customized formats
What is Format Cells
500
Used to check which cells are referenced in a formula or function
What is Range Finder
500
Drawn on the same worksheet as the data
What is an Embedded Chart
M
e
n
u