1:00
en
CR
Spread Sheet Vocabulary
23
Columns: Vertical sections. They are idntified by a letter
Rows: Horizontal sections. They are indetified by a number
Cell: The point at which a column and row intersect or meet
Active Cell: The cell in which you are currently working
Cell Reference: The location or name of a cell. Examples B5, C1, D3
Adress Box: Indicates the reference name or location for the active cell.
Formula Bar: Displays the data entered into the cell. It will show if there is a formula there.
Lables :Words or Alphabet Text
Values: Number
Formulas: Math Equation/Statement that performs a calculation
Alignment: Arrangement in a straight line, or in correct or appropriate relative positions
Wrap Text: Used to align multi-line text within a cell
Merge:Used to combine two or more cells;default alignment is center
Gridlines: The light grey lines around the cells
Sum : Total range of a cell
Avg: Average of the cells in a range (Avergage)
Count: The number of cells in a range(Counts)
Max: Value if range in a cell (Maximum)
Min: Minium value of range of a cell (Minimum)
Relative: Cell Value Change as the function is copied to other colums
Absolute: Cell value remains the same when copied to other columns and rows
Mixed: Combination of an ansolute and relative cell
Function: Built-In, shortcut formula
Range: A series or group of cells
PEMDAS: Calculations are performed according to the order of operations
Spread Sheet Vocabulary
Across:5. | Cell Value Change as the function is copied to other colums | 7. | Calculations are performed according to the order of operations | 10. | Horizontal sections. They are indetified by a number | 12. | Cell value remains the same when copied to other columns and rows | 14. | Arrangement in a straight line, or in correct or appropriate relative positions | 16. | Used to combine two or more cells;default alignment is center | 17. | The number of cells in a range(Counts) | 19. | Displays the data entered into the cell. It will show if there is a formula there. |
| | Down:1. | Vertical sections. They are idntified by a letter | 2. | Built-In, shortcut formula | 3. | Value if range in a cell (Maximum) | 4. | Combination of an ansolute and relative cell | 6. | Used to align multi-line text within a cell | 8. | Indicates the reference name or location for the active cell. | 9. | The point at which a column and row intersect or meet | 11. | The location or name of a cell. Examples B5, C1, D3 | 12. | The cell in which you are currently working | 13. | Words or Alphabet Text | 14. | Average of the cells in a range (Avergage) | 15. | The light grey lines around the cells | 16. | Minium value of range of a cell (Minimum) | 18. | A series or group of cells | 19. | Math Equation/Statement that performs a calculation |
| |
© 2015
PuzzleFast.com, Noncommercial Use Only
Spread Sheet Vocabulary
Across:5. | Cell Value Change as the function is copied to other colums | 7. | Calculations are performed according to the order of operations | 10. | Horizontal sections. They are indetified by a number | 12. | Cell value remains the same when copied to other columns and rows | 14. | Arrangement in a straight line, or in correct or appropriate relative positions | 16. | Used to combine two or more cells;default alignment is center | 17. | The number of cells in a range(Counts) | 19. | Displays the data entered into the cell. It will show if there is a formula there. |
| | Down:1. | Vertical sections. They are idntified by a letter | 2. | Built-In, shortcut formula | 3. | Value if range in a cell (Maximum) | 4. | Combination of an ansolute and relative cell | 6. | Used to align multi-line text within a cell | 8. | Indicates the reference name or location for the active cell. | 9. | The point at which a column and row intersect or meet | 11. | The location or name of a cell. Examples B5, C1, D3 | 12. | The cell in which you are currently working | 13. | Words or Alphabet Text | 14. | Average of the cells in a range (Avergage) | 15. | The light grey lines around the cells | 16. | Minium value of range of a cell (Minimum) | 18. | A series or group of cells | 19. | Math Equation/Statement that performs a calculation |
| |
© 2015
PuzzleFast.com, Noncommercial Use Only