BUS 311 Excel Chapter 5 2026 Complete Exam Set with Questions and Verified Answers

1



BUS 311 EXCEL CHAPTER 5 2026| COMPLETE EXAM
SET (QUESTIONS AND VERIFIED ANSWERS |
FREQUENTLY MOST TESTED QUESTIONS |
ALREADY PASSED!!

DOMAIN 1: Lookup & Reference Functions (8 Questions)

Sub-Topic: VLOOKUP Syntax, Arguments & First Column Requirement (3 Questions)

Question 1 (Multiple-Choice)

A business analyst needs to retrieve the unit price for Product ID "P-1042" from a pricing table.
The table has columns: Product ID (Column A), Product Name (Column B), Unit Price (Column
C), and Stock Level (Column D). Which VLOOKUP formula will correctly return the unit price?

A. =VLOOKUP("P-1042", C2:D50, 1, FALSE)
B. =VLOOKUP("P-1042", A2:D50, 3, FALSE)
C. =VLOOKUP(P-1042, A2:D50, 2, TRUE)
D. =VLOOKUP("P-1042", B2:D50, 2, FALSE)

Correct Answer: B [CORRECT]

Rationale: VLOOKUP requires four arguments: lookup_value, table_array, col_index_num, and
range_lookup. The lookup_value ("P-1042") must be in the first column of the table_array
(Column A, Product ID). The table_array must include the lookup column and the return
column, so A2:D50 is correct. col_index_num = 3 returns the value from the third column (Unit
Price in Column C). FALSE specifies an exact match, which is required when looking up specific
product IDs. Option A fails because the table_array starts in Column C (Product ID is not the first
column). Option C fails because the lookup value is not in quotes (Excel treats it as a cell
reference or subtraction) and uses TRUE (approximate match) for a specific ID. Option D fails
because the table_array starts in Column B, making Product Name the first column instead of
Product ID.



Question 2 (Multiple-Choice)

, 2



A sales manager wants to find the commission rate for a salesperson with ID "SP-778" from a
commission table. The table range is named "CommissionTable" and has columns: Salesperson
ID, Name, Region, Commission Rate, and YTD Sales. Which formula is correct?

A. =VLOOKUP(SP-778, CommissionTable, 4, FALSE)
B. =VLOOKUP("SP-778", CommissionTable, 4, TRUE)
C. =VLOOKUP("SP-778", CommissionTable, 3, FALSE)
D. =VLOOKUP("SP-778", CommissionTable, 4, FALSE)

Correct Answer: D [CORRECT]

Rationale: The correct formula requires: (1) the lookup value in quotes because it is text ("SP-
778"), (2) the named range "CommissionTable" as the table_array, (3) col_index_num = 4
because Commission Rate is the fourth column (Salesperson ID = 1, Name = 2, Region = 3,
Commission Rate = 4), and (4) FALSE for exact match since "SP-778" is a specific identifier.
Option A omits quotes around the text value. Option B uses TRUE (approximate match), which
would return an incorrect rate if the table is not sorted or if "SP-778" does not exist. Option C
uses col_index_num = 3, which returns the Region instead of the Commission Rate.



Question 3 (True/False)

In a VLOOKUP formula, the table_array can begin in any column of the worksheet, but the
lookup_value must always be located in the first column of the specified table_array range.

A. True
B. False

Correct Answer: A [CORRECT]

Rationale: True. VLOOKUP searches vertically (by column) and always looks for the
lookup_value in the first column of the specified table_array. The table_array can start at any
column (e.g., D2:G50), but whatever column is first in that range (Column D in this example)
must contain the lookup values. This is a fundamental structural requirement of the VLOOKUP
function. If the lookup value exists in Column E but the table_array starts at Column D,
VLOOKUP will search Column D and return #N/A because it cannot "see" Column E as the
lookup column.

, 3



Sub-Topic: VLOOKUP TRUE vs. FALSE—Approximate vs. Exact Match (2 Questions)

Question 4 (Multiple-Choice)

A professor needs to assign letter grades based on percentage scores using the following
grading scale:

Table

Score Grade


0 F


60 D


70 C


80 B


90 A

A student has a score of 85 in cell B2. Which VLOOKUP formula will correctly return the letter
grade?

A. =VLOOKUP(B2, $A$2:$B$6, 2, FALSE)
B. =VLOOKUP(B2, $A$2:$B$6, 2, TRUE)
C. =VLOOKUP(85, $A$2:$B$6, 2, FALSE)
D. =VLOOKUP(B2, $A$2:$B$6, 1, TRUE)

Correct Answer: B [CORRECT]

Rationale: For grade lookup from a scale, TRUE (approximate match) is required. VLOOKUP with
TRUE finds the largest value in the first column that is less than or equal to the lookup value.
With a score of 85, VLOOKUP finds 80 (the largest value ≤ 85) and returns the corresponding
grade "B". The first column of the table_array (the Score column) must be sorted in ascending
order for approximate match to work correctly. FALSE (exact match) would return #N/A because