EXCEL CRASH COURSE EXAM 2026 LATEST VERSION 300
QUESTIONS AND 100% CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A+
This exam delivers 300 uniquely crafted multiple-choice questions that
systematically cover every essential Excel topic, from basic navigation and cell
formatting to advanced financial functions, statistical analysis, and dynamic
array formulas. Each question presents four clear options directly below it,
followed by the correct answer and a detailed rationale that explains the
underlying concept, ensuring you learn while you test. The questions are
deliberately non-repetitive, targeting distinct shortcuts, features, and
functions across the entire Excel ecosystem. Ideal for self-assessment,
interview preparation, or certification practice, this comprehensive drill
builds both speed and accuracy, transforming you from a casual user into a
confident, proficient Excel analyst ready for real-world challenges.
1. Which shortcut key opens the Go To dialog box in Excel?
A) Ctrl+G
B) Ctrl+H
C) Ctrl+F
D) Ctrl+A
Answer: A
Rationale: Ctrl+G opens the Go To dialog, which lets you jump to a specific cell or
range. Ctrl+H is Find and Replace, Ctrl+F is Find, and Ctrl+A selects all.
2. What does the formula =SUM(A1:A10) do?
A) Counts numbers in A1:A10
B) Adds all values in A1:A10
C) Averages values in A1:A10
D) Finds the maximum in A1:A10
Answer: B
Rationale: SUM is explicitly designed to add numeric values within a given range.
COUNT counts, AVERAGE averages, and MAX finds the highest value.
,3. Which function returns the current date and time?
A) TODAY()
B) NOW()
C) DATE()
D) TIME()
Answer: B
Rationale: NOW() returns both the current date and time, updating each time the
sheet recalculates. TODAY() returns only the date.
4. What is the result of =LEN("Excel")?
A) 4
B) 5
C) 6
D) 3
Answer: B
Rationale: LEN counts all characters including letters; "Excel" has five characters
(E-x-c-e-l).
5. Which function extracts a substring from the middle of a text string?
A) LEFT
B) RIGHT
C) MID
D) TEXT
Answer: C
Rationale: MID(text, start_num, num_chars) extracts from the middle. LEFT takes
from the start, RIGHT from the end.
6. What does the fill handle (small square at cell bottom-right) do?
A) Deletes the cell
B) Copies or extends data series
C) Changes font size
D) Inserts a chart
Answer: B
Rationale: Dragging the fill handle copies cell content or extends patterns (e.g.,
months, numbers) to adjacent cells.
7. Which symbol is used to absolute reference a cell?
A) $
B) #
C) @
,D) %
Answer: A
Rationale: The dollar sign locks the row, column, or both in a formula so they don't
change when copied.
8. What does =COUNTIF(B2:B20, ">100") count?
A) Cells equal to 100
B) Cells greater than 100
C) Cells less than 100
D) Cells not equal to 100
Answer: B
Rationale: The criteria ">100" explicitly counts only cells with numeric values
exceeding 100.
9. Which chart type is best for showing trends over time?
A) Pie chart
B) Bar chart
C) Line chart
D) Doughnut chart
Answer: C
Rationale: Line charts connect data points with lines, making them ideal for
visualizing continuous data like time series.
10. What is the default file extension for an Excel macro-enabled workbook?
A) .xlsx
B) .xlsm
C) .xlsb
D) .xltx
Answer: B
Rationale: .xlsm indicates a workbook that can contain VBA macros. .xlsx is for
non-macro workbooks, .xlsb is binary, and .xltx is a template.
11. Which function finds the smallest number in a range?
A) MIN
B) MAX
C) SMALL
D) LARGE
Answer: A
Rationale: MIN returns the minimum value directly. SMALL requires a k
argument to return the k-th smallest.
, 12. What does Ctrl+Z do in Excel?
A) Redo
B) Undo
C) Save
D) Copy
Answer: B
Rationale: Ctrl+Z is the universal undo shortcut, reversing the last action. Ctrl+Y is
redo.
13. How do you insert a new worksheet in a workbook?
A) Right-click a sheet tab and select Insert
B) Press Ctrl+N
C) Press Ctrl+W
D) Click File > New
Answer: A
Rationale: Right-clicking a sheet tab gives the Insert option for a new sheet.
Ctrl+N creates a new workbook, not a sheet.
14. What is the purpose of the IF function?
A) To perform a logical test and return different values based on the outcome
B) To sum values conditionally
C) To count non-empty cells
D) To look up values in a table
Answer: A
Rationale: IF evaluates a condition and returns one result if true and another if
false. SUMIF handles conditional summing.
15. Which formula correctly calculates the average of cells C1 through C10,
excluding zeros?
A) =AVERAGEIF(C1:C10, ">0")
B) =AVERAGE(C1:C10)
C) =AVERAGEIF(C1:C10, "<>0")
D) =AVERAGEIFS(C1:C10, C1:C10, ">0")
Answer: C
Rationale: AVERAGEIF with "<>0" excludes zeros while averaging. ">0" would
also exclude negatives, which may not be desired.
16. What does the ampersand (&) do in an Excel formula?
A) Multiplies numbers
QUESTIONS AND 100% CORRECT ANSWERS WITH
RATIONALE ALREADY GRADED A+
This exam delivers 300 uniquely crafted multiple-choice questions that
systematically cover every essential Excel topic, from basic navigation and cell
formatting to advanced financial functions, statistical analysis, and dynamic
array formulas. Each question presents four clear options directly below it,
followed by the correct answer and a detailed rationale that explains the
underlying concept, ensuring you learn while you test. The questions are
deliberately non-repetitive, targeting distinct shortcuts, features, and
functions across the entire Excel ecosystem. Ideal for self-assessment,
interview preparation, or certification practice, this comprehensive drill
builds both speed and accuracy, transforming you from a casual user into a
confident, proficient Excel analyst ready for real-world challenges.
1. Which shortcut key opens the Go To dialog box in Excel?
A) Ctrl+G
B) Ctrl+H
C) Ctrl+F
D) Ctrl+A
Answer: A
Rationale: Ctrl+G opens the Go To dialog, which lets you jump to a specific cell or
range. Ctrl+H is Find and Replace, Ctrl+F is Find, and Ctrl+A selects all.
2. What does the formula =SUM(A1:A10) do?
A) Counts numbers in A1:A10
B) Adds all values in A1:A10
C) Averages values in A1:A10
D) Finds the maximum in A1:A10
Answer: B
Rationale: SUM is explicitly designed to add numeric values within a given range.
COUNT counts, AVERAGE averages, and MAX finds the highest value.
,3. Which function returns the current date and time?
A) TODAY()
B) NOW()
C) DATE()
D) TIME()
Answer: B
Rationale: NOW() returns both the current date and time, updating each time the
sheet recalculates. TODAY() returns only the date.
4. What is the result of =LEN("Excel")?
A) 4
B) 5
C) 6
D) 3
Answer: B
Rationale: LEN counts all characters including letters; "Excel" has five characters
(E-x-c-e-l).
5. Which function extracts a substring from the middle of a text string?
A) LEFT
B) RIGHT
C) MID
D) TEXT
Answer: C
Rationale: MID(text, start_num, num_chars) extracts from the middle. LEFT takes
from the start, RIGHT from the end.
6. What does the fill handle (small square at cell bottom-right) do?
A) Deletes the cell
B) Copies or extends data series
C) Changes font size
D) Inserts a chart
Answer: B
Rationale: Dragging the fill handle copies cell content or extends patterns (e.g.,
months, numbers) to adjacent cells.
7. Which symbol is used to absolute reference a cell?
A) $
B) #
C) @
,D) %
Answer: A
Rationale: The dollar sign locks the row, column, or both in a formula so they don't
change when copied.
8. What does =COUNTIF(B2:B20, ">100") count?
A) Cells equal to 100
B) Cells greater than 100
C) Cells less than 100
D) Cells not equal to 100
Answer: B
Rationale: The criteria ">100" explicitly counts only cells with numeric values
exceeding 100.
9. Which chart type is best for showing trends over time?
A) Pie chart
B) Bar chart
C) Line chart
D) Doughnut chart
Answer: C
Rationale: Line charts connect data points with lines, making them ideal for
visualizing continuous data like time series.
10. What is the default file extension for an Excel macro-enabled workbook?
A) .xlsx
B) .xlsm
C) .xlsb
D) .xltx
Answer: B
Rationale: .xlsm indicates a workbook that can contain VBA macros. .xlsx is for
non-macro workbooks, .xlsb is binary, and .xltx is a template.
11. Which function finds the smallest number in a range?
A) MIN
B) MAX
C) SMALL
D) LARGE
Answer: A
Rationale: MIN returns the minimum value directly. SMALL requires a k
argument to return the k-th smallest.
, 12. What does Ctrl+Z do in Excel?
A) Redo
B) Undo
C) Save
D) Copy
Answer: B
Rationale: Ctrl+Z is the universal undo shortcut, reversing the last action. Ctrl+Y is
redo.
13. How do you insert a new worksheet in a workbook?
A) Right-click a sheet tab and select Insert
B) Press Ctrl+N
C) Press Ctrl+W
D) Click File > New
Answer: A
Rationale: Right-clicking a sheet tab gives the Insert option for a new sheet.
Ctrl+N creates a new workbook, not a sheet.
14. What is the purpose of the IF function?
A) To perform a logical test and return different values based on the outcome
B) To sum values conditionally
C) To count non-empty cells
D) To look up values in a table
Answer: A
Rationale: IF evaluates a condition and returns one result if true and another if
false. SUMIF handles conditional summing.
15. Which formula correctly calculates the average of cells C1 through C10,
excluding zeros?
A) =AVERAGEIF(C1:C10, ">0")
B) =AVERAGE(C1:C10)
C) =AVERAGEIF(C1:C10, "<>0")
D) =AVERAGEIFS(C1:C10, C1:C10, ">0")
Answer: C
Rationale: AVERAGEIF with "<>0" excludes zeros while averaging. ">0" would
also exclude negatives, which may not be desired.
16. What does the ampersand (&) do in an Excel formula?
A) Multiplies numbers
