WGU D100 Introduction to Spreadsheets —
200 Practice MCQs
Objective Assessment & Final Exam Prep | Microsoft Excel Focus
1. Which of the following BEST describes a spreadsheet application?
A) A word processing program used to create documents B) A software application that
organizes data into rows and columns, enabling calculations, analysis, and visualization C) A
database management system for storing large amounts of data D) A presentation software used
to create slide shows
(Correct Answer: B) A software application that organizes data into rows and columns,
enabling calculations, analysis, and visualization Rationale: A spreadsheet application (such
as Microsoft Excel or Google Sheets) organizes data into a grid of rows and columns called a
worksheet. Users can enter data, perform calculations using formulas and functions, create
charts, and analyze data — making it a versatile tool for personal, academic, and business use.
2. In Microsoft Excel, what is the intersection of a row and a column called?
A) A range B) A worksheet C) A cell D) A formula bar
(Correct Answer: C) A cell Rationale: A cell is the basic unit of a spreadsheet — the
individual box formed at the intersection of a specific row and column. Each cell has a unique
address (cell reference) such as A1, B3, or D10, used to identify its location and reference it in
formulas.
3. What is the correct cell reference for the cell located in Column C, Row 5?
A) 5C B) C5 C) Row5Col3 D) C:5
(Correct Answer: B) C5 Rationale: Cell references in Excel follow the convention of column
letter first, then row number. The cell at Column C, Row 5 is referenced as C5. This naming
convention applies universally in Excel for identifying individual cells and ranges.
4. What does the Name Box in Excel display?
,A) The name of the current workbook file B) The cell reference or name of the currently selected
cell or range C) The result of the currently active formula D) The current worksheet tab name
(Correct Answer: B) The cell reference or name of the currently selected cell or range
Rationale: The Name Box is located to the left of the Formula Bar and displays the address of
the active cell (e.g., A1) or the name assigned to a named range. It can also be used to navigate to
a specific cell by typing a cell reference directly.
5. In Excel, what is a "workbook"?
A) A single sheet of cells in a spreadsheet file B) An entire Excel file that can contain one or
more worksheets C) A collection of formulas used in a spreadsheet D) A saved template for
creating new spreadsheets
(Correct Answer: B) An entire Excel file that can contain one or more worksheets
Rationale: A workbook is the complete Excel file (saved with a .xlsx extension). Each
workbook can contain multiple worksheets (tabs), allowing related data to be organized across
separate sheets within a single file.
6. What is a "worksheet" in Excel?
A) A single page within a workbook containing a grid of rows and columns B) The entire Excel
file with all its data C) A chart embedded in an Excel file D) A printed version of spreadsheet
data
(Correct Answer: A) A single page within a workbook containing a grid of rows and
columns Rationale: A worksheet (commonly called a "sheet") is one tab within a workbook. It
contains the grid of rows and columns where data is entered. Multiple worksheets can exist in
one workbook, accessible via the sheet tabs at the bottom of the screen.
7. In Excel, rows are identified by:
A) Letters (A, B, C...) B) Numbers (1, 2, 3...) C) Roman numerals (I, II, III...) D) Symbols (#, $,
%)
(Correct Answer: B) Numbers (1, 2, 3...) Rationale: In Excel, rows run horizontally and are
numbered 1 through 1,048,576. Columns run vertically and are labeled with letters (A through
XFD). This combination allows each cell to have a unique reference such as A1 (Column A,
Row 1).
,8. In Excel, columns are identified by:
A) Numbers (1, 2, 3...) B) Roman numerals (I, II, III...) C) Letters (A, B, C...) D) Colors
assigned automatically by Excel
(Correct Answer: C) Letters (A, B, C...) Rationale: Columns are labeled alphabetically,
starting with A and continuing through Z, then AA, AB...AZ, BA...and so on up to XFD (16,384
columns total in modern Excel). Column letters appear at the top of each column in the column
header row.
9. What is a "range" in Excel?
A) A single cell containing a formula B) A group of two or more cells selected together,
referenced as a block C) The number of worksheets in a workbook D) The maximum value in a
column of data
(Correct Answer: B) A group of two or more cells selected together, referenced as a block
Rationale: A range is a selection of two or more cells. It can be a continuous block (A1:C5) or
non-contiguous selections. Ranges are referenced using the starting cell, a colon (:), and the
ending cell — for example, B2:D8 includes all cells from B2 to D8.
10. Which of the following is the correct way to reference the range from cell A1 to cell D10
in Excel?
A) A1-D10 B) A1 to D10 C) A1:D10 D) A1;D10
(Correct Answer: C) A1:D10 Rationale: In Excel, a range is expressed using a colon (:)
between the first and last cell references. A1:D10 refers to all cells from A1 to D10, forming a
rectangular block of 40 cells (4 columns × 10 rows).
11. Which symbol MUST begin every formula in Excel?
A) @ B) # C) = D) +
(Correct Answer: C) = Rationale: All Excel formulas must begin with an equal sign (=). This
tells Excel to interpret the entry as a formula rather than text or a number. For example, =A1+B1
adds the values in cells A1 and B1. Without the = sign, Excel treats the entry as plain text.
, 12. What is the result of the formula =5+3*2 in Excel?
A) 16 B) 11 C) 13 D) 10
(Correct Answer: B) 11 Rationale: Excel follows the standard order of operations
(PEMDAS/BODMAS): multiplication and division are performed before addition and
subtraction. Therefore: 3×2=6 first, then 5+6=11. If the intended result were 16, the formula
would need parentheses: =(5+3)*2.
13. Which of the following correctly describes the order of operations Excel uses to
evaluate formulas?
A) Left to right regardless of operator type B) Addition, Subtraction, Multiplication, Division C)
Parentheses, Exponents, Multiplication/Division, Addition/Subtraction (PEMDAS) D) Division,
Multiplication, Addition, Subtraction
(Correct Answer: C) Parentheses, Exponents, Multiplication/Division,
Addition/Subtraction (PEMDAS) Rationale: Excel evaluates formulas using standard
mathematical order of operations: (1) Parentheses (operations inside are evaluated first), (2)
Exponents (^), (3) Multiplication (*) and Division (/), evaluated left to right, (4) Addition (+) and
Subtraction (-), evaluated left to right. Use parentheses to override this order.
14. What function in Excel adds all the values in a range of cells?
A) =ADD() B) =TOTAL() C) =SUM() D) =PLUS()
(Correct Answer: C) =SUM() Rationale: The SUM function adds all numeric values in a
specified range. Syntax: =SUM(number1, [number2], ...) or =SUM(A1:A10). It is one of Excel's
most commonly used functions and can handle up to 255 arguments including individual cells,
ranges, and numbers.
15. What is the correct syntax for the AVERAGE function in Excel?
A) =AVERAGE(A1-A10) B) =AVERAGE(A1:A10) C) =AVG(A1:A10) D) =MEAN(A1:A10)
(Correct Answer: B) =AVERAGE(A1:A10) Rationale: The AVERAGE function calculates
the arithmetic mean of the values in a range. Syntax: =AVERAGE(range). For cells A1 through
200 Practice MCQs
Objective Assessment & Final Exam Prep | Microsoft Excel Focus
1. Which of the following BEST describes a spreadsheet application?
A) A word processing program used to create documents B) A software application that
organizes data into rows and columns, enabling calculations, analysis, and visualization C) A
database management system for storing large amounts of data D) A presentation software used
to create slide shows
(Correct Answer: B) A software application that organizes data into rows and columns,
enabling calculations, analysis, and visualization Rationale: A spreadsheet application (such
as Microsoft Excel or Google Sheets) organizes data into a grid of rows and columns called a
worksheet. Users can enter data, perform calculations using formulas and functions, create
charts, and analyze data — making it a versatile tool for personal, academic, and business use.
2. In Microsoft Excel, what is the intersection of a row and a column called?
A) A range B) A worksheet C) A cell D) A formula bar
(Correct Answer: C) A cell Rationale: A cell is the basic unit of a spreadsheet — the
individual box formed at the intersection of a specific row and column. Each cell has a unique
address (cell reference) such as A1, B3, or D10, used to identify its location and reference it in
formulas.
3. What is the correct cell reference for the cell located in Column C, Row 5?
A) 5C B) C5 C) Row5Col3 D) C:5
(Correct Answer: B) C5 Rationale: Cell references in Excel follow the convention of column
letter first, then row number. The cell at Column C, Row 5 is referenced as C5. This naming
convention applies universally in Excel for identifying individual cells and ranges.
4. What does the Name Box in Excel display?
,A) The name of the current workbook file B) The cell reference or name of the currently selected
cell or range C) The result of the currently active formula D) The current worksheet tab name
(Correct Answer: B) The cell reference or name of the currently selected cell or range
Rationale: The Name Box is located to the left of the Formula Bar and displays the address of
the active cell (e.g., A1) or the name assigned to a named range. It can also be used to navigate to
a specific cell by typing a cell reference directly.
5. In Excel, what is a "workbook"?
A) A single sheet of cells in a spreadsheet file B) An entire Excel file that can contain one or
more worksheets C) A collection of formulas used in a spreadsheet D) A saved template for
creating new spreadsheets
(Correct Answer: B) An entire Excel file that can contain one or more worksheets
Rationale: A workbook is the complete Excel file (saved with a .xlsx extension). Each
workbook can contain multiple worksheets (tabs), allowing related data to be organized across
separate sheets within a single file.
6. What is a "worksheet" in Excel?
A) A single page within a workbook containing a grid of rows and columns B) The entire Excel
file with all its data C) A chart embedded in an Excel file D) A printed version of spreadsheet
data
(Correct Answer: A) A single page within a workbook containing a grid of rows and
columns Rationale: A worksheet (commonly called a "sheet") is one tab within a workbook. It
contains the grid of rows and columns where data is entered. Multiple worksheets can exist in
one workbook, accessible via the sheet tabs at the bottom of the screen.
7. In Excel, rows are identified by:
A) Letters (A, B, C...) B) Numbers (1, 2, 3...) C) Roman numerals (I, II, III...) D) Symbols (#, $,
%)
(Correct Answer: B) Numbers (1, 2, 3...) Rationale: In Excel, rows run horizontally and are
numbered 1 through 1,048,576. Columns run vertically and are labeled with letters (A through
XFD). This combination allows each cell to have a unique reference such as A1 (Column A,
Row 1).
,8. In Excel, columns are identified by:
A) Numbers (1, 2, 3...) B) Roman numerals (I, II, III...) C) Letters (A, B, C...) D) Colors
assigned automatically by Excel
(Correct Answer: C) Letters (A, B, C...) Rationale: Columns are labeled alphabetically,
starting with A and continuing through Z, then AA, AB...AZ, BA...and so on up to XFD (16,384
columns total in modern Excel). Column letters appear at the top of each column in the column
header row.
9. What is a "range" in Excel?
A) A single cell containing a formula B) A group of two or more cells selected together,
referenced as a block C) The number of worksheets in a workbook D) The maximum value in a
column of data
(Correct Answer: B) A group of two or more cells selected together, referenced as a block
Rationale: A range is a selection of two or more cells. It can be a continuous block (A1:C5) or
non-contiguous selections. Ranges are referenced using the starting cell, a colon (:), and the
ending cell — for example, B2:D8 includes all cells from B2 to D8.
10. Which of the following is the correct way to reference the range from cell A1 to cell D10
in Excel?
A) A1-D10 B) A1 to D10 C) A1:D10 D) A1;D10
(Correct Answer: C) A1:D10 Rationale: In Excel, a range is expressed using a colon (:)
between the first and last cell references. A1:D10 refers to all cells from A1 to D10, forming a
rectangular block of 40 cells (4 columns × 10 rows).
11. Which symbol MUST begin every formula in Excel?
A) @ B) # C) = D) +
(Correct Answer: C) = Rationale: All Excel formulas must begin with an equal sign (=). This
tells Excel to interpret the entry as a formula rather than text or a number. For example, =A1+B1
adds the values in cells A1 and B1. Without the = sign, Excel treats the entry as plain text.
, 12. What is the result of the formula =5+3*2 in Excel?
A) 16 B) 11 C) 13 D) 10
(Correct Answer: B) 11 Rationale: Excel follows the standard order of operations
(PEMDAS/BODMAS): multiplication and division are performed before addition and
subtraction. Therefore: 3×2=6 first, then 5+6=11. If the intended result were 16, the formula
would need parentheses: =(5+3)*2.
13. Which of the following correctly describes the order of operations Excel uses to
evaluate formulas?
A) Left to right regardless of operator type B) Addition, Subtraction, Multiplication, Division C)
Parentheses, Exponents, Multiplication/Division, Addition/Subtraction (PEMDAS) D) Division,
Multiplication, Addition, Subtraction
(Correct Answer: C) Parentheses, Exponents, Multiplication/Division,
Addition/Subtraction (PEMDAS) Rationale: Excel evaluates formulas using standard
mathematical order of operations: (1) Parentheses (operations inside are evaluated first), (2)
Exponents (^), (3) Multiplication (*) and Division (/), evaluated left to right, (4) Addition (+) and
Subtraction (-), evaluated left to right. Use parentheses to override this order.
14. What function in Excel adds all the values in a range of cells?
A) =ADD() B) =TOTAL() C) =SUM() D) =PLUS()
(Correct Answer: C) =SUM() Rationale: The SUM function adds all numeric values in a
specified range. Syntax: =SUM(number1, [number2], ...) or =SUM(A1:A10). It is one of Excel's
most commonly used functions and can handle up to 255 arguments including individual cells,
ranges, and numbers.
15. What is the correct syntax for the AVERAGE function in Excel?
A) =AVERAGE(A1-A10) B) =AVERAGE(A1:A10) C) =AVG(A1:A10) D) =MEAN(A1:A10)
(Correct Answer: B) =AVERAGE(A1:A10) Rationale: The AVERAGE function calculates
the arithmetic mean of the values in a range. Syntax: =AVERAGE(range). For cells A1 through
