Vocabulary 1
Vocabulary 2
Vocabulary 3
Formulas 1
Formulas 2
100
A file used to store worksheets
What is a workbook
100
An equation
What is a formula
100
A grid of rows and columns in which you enter text, numbers and results of calculations
What is a spreadsheet
100
This is the formula to add B5 and B6
What is =B5+B6
100
This is the formula to divide A6 by B6
What is =A6/B6
200
Where a column and row intersect
What is a cell
200
These are vertical and are identified by a letter
What is a column
200
When this is used, cells adjusts to its new location when copied or moved to another cell
What is relative cell reference
200
This is the formula to subtract B4 from A4
What is =A4-B4
200
This is the function to add all values in B3, B4, B5 and B6
What is =sum(B3:B6)
300
A group of selected cells
What is a range
300
This is the name of the worksheet
What is a sheet tab
300
These are cell references that contain both relative and absolute references
What is a mixed cell reference
300
This is the formula to multiply A5 and B6
What is =A5*B6
300
This is the function to average A3, A4, A5, A6
What is =average (A3:A6)
400
A computerized spreadsheet
What is a worksheet
400
This identifies an active cell
What is a name box
400
These are used to identify a cell using the column letter and row number
What is a cell reference
400
This is the function to find the largest number for A3, A4, A5, A6
What is =max(A3:A6)
400
This is the function to find the smallest number from B3, B4, B5, B6
What is =min(B3:B6)
500
These are horizontal and identified by numbers
What is a row
500
This displays a formula
What is formula bar
500
When this is used, cells do not change when copied or moved to a new cell
What is absolute cell reference
500
This formula will add the values in cells A3 and B3 and then multiply by 3
What is =(A3 + B3)*3
500
This formula will divide A6 by 2 and then subtract B6
What is =(A6/2)-B6
M
e
n
u