Absolute cell reference A cell reference that remains constant when a formula is pasted
To make a cell reference absolute, put a "$" character in front o
reference that you wish to remain constant when a formula is p
cell.
Compare and contrast the COUNT and COUNTA COUNT counts the number of cells in a range that contain num
formulas COUNTA counts the number of cells in a range of cells that are
Describe the order of operations in Excel 1. Parentheses
2. Exponents
3. Multiplication and Division
4. Addition and Subtraction
Excel would evaluate the expression =(18+15)/4*2+3 to A. 19.5
the value of?
A. 19.5
B. 28.5
C. 7.1
D. 22.8
, Excel would evaluate the expression =25-15/5*2+7 to the B. 26
value of?
A. 11
B. 26
C. 18
D. 8
Patterns in a dataset generally result from interactions B. Qualitative data and quantitative data
between what two things?
A. Column headings and total rows
B. Qualitative data and quantitative data
C. Calculated columns and quantitative data
D. Qualitative data and column headings
To make a cell reference absolute, put a "$" character in front o
reference that you wish to remain constant when a formula is p
cell.
Compare and contrast the COUNT and COUNTA COUNT counts the number of cells in a range that contain num
formulas COUNTA counts the number of cells in a range of cells that are
Describe the order of operations in Excel 1. Parentheses
2. Exponents
3. Multiplication and Division
4. Addition and Subtraction
Excel would evaluate the expression =(18+15)/4*2+3 to A. 19.5
the value of?
A. 19.5
B. 28.5
C. 7.1
D. 22.8
, Excel would evaluate the expression =25-15/5*2+7 to the B. 26
value of?
A. 11
B. 26
C. 18
D. 8
Patterns in a dataset generally result from interactions B. Qualitative data and quantitative data
between what two things?
A. Column headings and total rows
B. Qualitative data and quantitative data
C. Calculated columns and quantitative data
D. Qualitative data and column headings
