Intro to Spreadsheets D100 Review 2025/ 2026 Free Questions with Solution

Intro to Spreadsheets D100


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

, Intro to Spreadsheets D100

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