EXCEL CRASH COURSE EXAM 2026 – 100% VERIFIED QUESTIONS & CORRECT ANSWERS | WALL STREET PREP LATEST EDITION

EXCEL CRASH COURSE EXAM 2026 – 100%
VERIFIED QUESTIONS & CORRECT ANSWERS |
WALL STREET PREP LATEST EDITION
EXCEL CRASH COURSE EXAM 2026

Wall Street Prep | Latest Edition | 300 Verified Questions



QUESTION 1 What does the Excel function SUM do?

A) Counts the number of cells in a range

B) Finds the average of a range

C) Multiplies all numbers in a range

D) Adds all numbers in a specified range

E) Finds the maximum value in a range

✔ CORRECT ANSWER: D RATIONALE: The SUM function adds all numeric
values within a specified range or list of arguments, making it the most basic and widely
used function in Excel.


QUESTION 2 Which keyboard shortcut is used to copy a selected cell or range in
Excel?
A) Ctrl + X

B) Ctrl + V
C) Ctrl + Z

D) Ctrl + S

E) Ctrl + C

✔ CORRECT ANSWER: E RATIONALE: Ctrl + C is the universal copy shortcut in
Excel. Ctrl + X cuts, Ctrl + V pastes, Ctrl + Z undoes, and Ctrl + S saves.



QUESTION 3 What is the correct syntax for an IF function in Excel?

A) =IF(value, then, logical_test)
B) =IF(logical_test, value_if_true, value_if_false)

, C) =IF(true, false, condition)

D) =IF(logical_test, value_if_true, value_if_false)

E) =IF(condition; result1; result2)

✔ CORRECT ANSWER: D RATIONALE: The IF function syntax is
=IF(logical_test, value_if_true, value_if_false). It evaluates a condition and returns one
of two values depending on whether the condition is TRUE or FALSE.



QUESTION 4 Which function returns the largest value in a set of values?

A) LARGE()
B) TOP()

C) MAX()

D) HIGH()

E) PEAK()

✔ CORRECT ANSWER: C RATIONALE: The MAX function returns the largest
numeric value in a specified range or list of arguments. LARGE() can also return the nth
largest value but MAX() is the direct function for the absolute largest.



QUESTION 5 What does VLOOKUP stand for?

A) Variable Lookup
B) Value Lookup

C) Vertical Lookup

D) Virtual Lookup

E) Vector Lookup

✔ CORRECT ANSWER: C RATIONALE: VLOOKUP stands for Vertical Lookup. It
searches for a value in the first column of a table and returns a value in the same row
from a specified column.


QUESTION 6 How many arguments does the VLOOKUP function require at minimum?

, A) 1

B) 2

C) 3

D) 4

E) 5

✔ CORRECT ANSWER: C RATIONALE: VLOOKUP requires at minimum 3
arguments: lookup_value, table_array, and col_index_num. The fourth argument
(range_lookup) is optional and defaults to TRUE (approximate match).


QUESTION 7 What symbol is used to create an absolute cell reference in Excel?

A) @

B) #

C) &

D) $

E) %

✔ CORRECT ANSWER: D RATIONALE: The dollar sign ($) is used to lock a cell
reference, making it absolute. For example, $A$1 locks both the column and row, so the
reference does not change when the formula is copied.


QUESTION 8 What is the keyboard shortcut to toggle absolute and relative references
in Excel?

A) F1

B) F2

C) F3

D) F4

E) F5

✔ CORRECT ANSWER: D RATIONALE: Pressing F4 while a cell reference is
selected in the formula bar cycles through all four reference types: absolute ($A$1), row
absolute (A$1), column absolute ($A1), and relative (A1).

, QUESTION 9 Which function counts only the cells that contain numbers?

A) COUNTA()

B) COUNT()

C) COUNTIF()

D) COUNTBLANK()

E) SUMCOUNT()

✔ CORRECT ANSWER: B RATIONALE: COUNT() counts only cells containing
numeric values. COUNTA() counts all non-empty cells, COUNTIF() counts based on a
condition, and COUNTBLANK() counts empty cells.



QUESTION 10 What does the CONCATENATE function do?

A) Splits text into multiple cells

B) Counts characters in a string

C) Joins two or more text strings into one

D) Converts numbers to text
E) Finds a character within a string

✔ CORRECT ANSWER: C RATIONALE: CONCATENATE (or the & operator /
CONCAT function in newer versions) joins two or more text strings into one single
string.



QUESTION 11 What is the shortcut to insert a new worksheet in Excel?
A) Ctrl + N

B) Ctrl + W

C) Shift + F11

D) Alt + N

E) Ctrl + T