BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Spreadsheet
an electronic file used to organize related data and perform calculations
Worksheet
a spreadsheet that contains formulas, values, text, and visual aids
Workbook
a file containing related worksheets
- identified by a sheet tab
Active Cell
Represented by black/dark border, cell you are currently working on
What are two of the basic components of a spreadsheet?
Workbooks and worksheets
Formula Bar
The contents of the active cell are displayed here
What do all formulas look like?
All valid formulas start with an equal sign
ex: =(A1+A2)^2
Cell Clearing
Removes data but keeps formulas
Cell Range
Group of cells
Contiguous
touching/adjacent
Deleting
removes both data and formulas
Non-Adjacent Range
consists of two or more distinct adjacent ranges
Hiding vs Unhiding
hiding a column prevents it from displaying and printing and unhiding returns it to view
Absolute Reference
remains constant throughout a copy operation
- specified with a dollar sign before the column and the row
ex: $B$4
Relative Reference
adjusts during a copy operation
- specified without dollar signs
ex: B4
Mixed Reference
either the row or the column is absolute; the other is relative
- specified with a dollar sign before the absolute part of the reference
ex: B$4
Semi -Selection
uses the mouse pointer to build a formula containing cell references or ranges
GRADED
Spreadsheet
an electronic file used to organize related data and perform calculations
Worksheet
a spreadsheet that contains formulas, values, text, and visual aids
Workbook
a file containing related worksheets
- identified by a sheet tab
Active Cell
Represented by black/dark border, cell you are currently working on
What are two of the basic components of a spreadsheet?
Workbooks and worksheets
Formula Bar
The contents of the active cell are displayed here
What do all formulas look like?
All valid formulas start with an equal sign
ex: =(A1+A2)^2
Cell Clearing
Removes data but keeps formulas
Cell Range
Group of cells
Contiguous
touching/adjacent
Deleting
removes both data and formulas
Non-Adjacent Range
consists of two or more distinct adjacent ranges
Hiding vs Unhiding
hiding a column prevents it from displaying and printing and unhiding returns it to view
Absolute Reference
remains constant throughout a copy operation
- specified with a dollar sign before the column and the row
ex: $B$4
Relative Reference
adjusts during a copy operation
- specified without dollar signs
ex: B4
Mixed Reference
either the row or the column is absolute; the other is relative
- specified with a dollar sign before the absolute part of the reference
ex: B$4
Semi -Selection
uses the mouse pointer to build a formula containing cell references or ranges
