Indeed Pre-Employment Excel Practice Test
Prepare for employer-administered Indeed Excel screening tests. Practice formatting, core math functions, absolute cell references ($), VLOOKUP, IF logic, and real workplace data tables.
Accounting vs Currency Format Symbol Alignment
In Excel financial reports, what is the primary visual difference between Accounting number format and Currency number format?
Calculate Total Departmental Supply Expenses
In target cell B6, calculate the total supply expenses across all departments using the SUM function.
| # | A | B |
|---|---|---|
| 1 | Department | Supply Expenses ($) |
| 2 | Operations | 4,200 |
| 3 | Marketing | 1,850 |
| 4 | Human Resources | 920 |
| 5 | Customer Support | 1,430 |
| 6 | Total Expenses |
Managing Overflowing Header Text with Wrap Text
When a column header is longer than the column width and you want the text to display across multiple lines within the same cell without widening the column, which feature should you apply?
Percentage Formatting Characteristics in Excel
Which of the following statements are true regarding how Excel stores and displays percentages? (Select all that apply)
Calculate Average Weekly Agent Handle Time
In target cell C6, calculate the average handle time in minutes across the four customer support representatives using the AVERAGE function.
| # | A | B | C |
|---|---|---|---|
| 1 | Agent ID | Agent Name | Avg Handle Time (min) |
| 2 | AG-101 | Sarah Jenkins | 14.5 |
| 3 | AG-102 | David Kim | 11.2 |
| 4 | AG-103 | Maria Santos | 16.8 |
| 5 | AG-104 | James Wilson | 13.5 |
| 6 | Team Average |
Formula Behavior When Dragged with Absolute References
Cell C2 contains the formula =B2*$E$1. What formula will be created if cell C2 is copied and pasted into cell C4?
Apply Fixed Corporate Tax Rate with Absolute Reference
In target cell C3, calculate the Sales Tax for Order 1001 by multiplying Subtotal (B3) by the locked Tax Rate in cell F1 using an absolute reference ($F$1).
| # | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Order ID | Subtotal ($) | Tax ($) | Total ($) | Tax Rate | 0.08 |
| 2 | --- | --- | --- | --- | ||
| 3 | ORD-1001 | 250 | ||||
| 4 | ORD-1002 | 400 |
Distinction Between COUNT and COUNTA Functions
Which of the following statements correctly describe how COUNT and COUNTA behave on a range of cells? (Select all that apply)
Count Total Active Employees on Shift Roster
In target cell B7, count the total number of employee names registered in the shift roster (cells A2:A6) using the COUNTA function.
| # | A | B |
|---|---|---|
| 1 | Employee Name | Shift Status |
| 2 | Carlos Mendez | Morning |
| 3 | Dana Scott | Evening |
| 4 | Eric Foster | Night |
| 5 | Grace Liu | Morning |
| 6 | Henry Miller | Evening |
| 7 | Total Scheduled Staff |
VLOOKUP Exact Match Argument Setting
In the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), what value must be passed to range_lookup to ensure an exact match?
Retrieve Product Unit Price with VLOOKUP
In target cell E2, look up the Unit Price for Product ID "P-103" from catalog table A2:C5 using VLOOKUP with exact match.
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Product ID | Item Name | Unit Price ($) | Search ID | Found Price ($) |
| 2 | P-101 | Desk Organizer | 18.5 | P-103 | |
| 3 | P-102 | Monitor Stand | 45 | ||
| 4 | P-103 | Ergonomic Mouse | 29.99 | ||
| 5 | P-104 | Mechanical Keyboard | 89.5 |
Fundamental Architectural Limitation of VLOOKUP
Why can standard VLOOKUP not retrieve a value located in a column to the left of the lookup key?
Modern Advantages of XLOOKUP Over VLOOKUP
Why do corporate spreadsheet teams prefer XLOOKUP over traditional VLOOKUP in modern Excel? (Select all that apply)
Fetch Warehouse Bin Location with XLOOKUP
In target cell E2, retrieve the Warehouse Location for SKU "SKU-204" from table A2:C5 using the XLOOKUP function.
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | SKU Code | Product Description | Bin Location | Search SKU | Matched Bin |
| 2 | SKU-201 | Safety Glasses | Aisle-1A | SKU-204 | |
| 3 | SKU-202 | Hard Hat | Aisle-1B | ||
| 4 | SKU-203 | High-Vis Vest | Aisle-2A | ||
| 5 | SKU-204 | Steel-Toe Boots | Aisle-3C |
Basic IF Function Structure and Evaluation
What will the formula =IF(C2 >= 40, "Overtime Eligible", "Standard") return if cell C2 contains 38?
Flag Low Stock Reorder Threshold with IF
In target cell D2, assign "Reorder" if Current Stock (B2) is less than Minimum Threshold (C2), otherwise assign "OK" using the IF function.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Current Stock | Min Threshold | Inventory Status |
| 2 | Industrial Printer Toner | 4 | 10 | |
| 3 | Standard Copy Paper | 45 | 20 |
Logical AND vs OR Function Rules
Which of the following statements correctly describe how AND and OR evaluate logical arguments? (Select all that apply)
Evaluate Dual Criteria Bonus Qualification with IF and AND
In target cell D2, assign "Bonus" if Sales (B2) is >= 50000 AND Rating (C2) is >= 4, otherwise assign "No" using IF and AND.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Employee | Sales ($) | Rating | Bonus Status |
| 2 | Karen Smith | 54,000 | 4.5 | |
| 3 | Paul Zhang | 48,000 | 4.8 |
Purpose and Behavior of the TRIM Function
When cleaning imported text data, what exact modifications does the TRIM function make to a string?
Clean Errant Spaces from Customer Name with TRIM
In target cell B2, clean the customer name in cell A2 by stripping out leading, trailing, and repeated whitespace using TRIM.
| # | A | B |
|---|---|---|
| 1 | Raw Name Input | Cleaned Name |
| 2 | Jonathan Edwards |
Standardizing Text Casing with UPPER
A quality control supervisor needs state postal codes (e.g., "ny", "ca") to appear in uniform capital letters ("NY", "CA"). Which function achieves this?
Standardize State Postal Code to Uppercase
In target cell C2, convert the lowercase state postal code in cell B2 into uppercase letters using the UPPER function.
| # | A | B | C |
|---|---|---|---|
| 1 | Client City | Raw State Code | Standardized Code |
| 2 | Austin | tx | |
| 3 | Denver | co |
Valid Methods to Join First and Last Names
Which of the following formulas correctly combine First Name in A2 ("Alice") and Last Name in B2 ("Walker") into "Alice Walker" with a space? (Select all that apply)
Join First and Last Name into Full Name
In target cell C2, join First Name (A2) and Last Name (B2) with a space in between using CONCATENATE or the & operator.
| # | A | B | C |
|---|---|---|---|
| 1 | First Name | Last Name | Full Employee Name |
| 2 | Marcus | Chen | |
| 3 | Rachel | Adams |
Identifying Extremes with MIN and MAX
A warehouse manager needs to find the heaviest single package in an inventory column (C2:C100). Which formula should be used?
Handling Empty and Text Cells in MAX Calculations
If a column range contains numbers 100, 250, text "Pending", and an empty cell, what does =MAX(range) return?
MIN Function with Negative Numbers
A financial spreadsheet evaluates monthly net profit figures: -$4,000, -$1,200, $3,500, and $0. What does =MIN(range) return?
Requirement for VLOOKUP Approximate Match Tiering
When using VLOOKUP with range_lookup set to TRUE (approximate match) for tiered commission or tax brackets, what strict rule must the lookup table adhere to?
Worksheet Borders vs Default Gridlines
Which of the following statements accurately describe cell borders and gridlines in Excel? (Select all that apply)
Diagnosing Common Excel Formula Errors
A colleague enters a VLOOKUP formula and receives #N/A. In cell D5, another formula multiplying a text name by 10 returns #VALUE!. What do these two error codes mean?
Excel COUNT Family Function Characteristics
Which of the following statements are accurate regarding Excel counting functions? (Select all that apply)
Mechanics of Mixed Cell References ($A1 vs A$1)
Which of the following statements correctly explain how mixed cell references behave when dragged across rows and columns? (Select all that apply)
Speed Shortcut for Instant AutoSum
Which standard keyboard shortcut instantly inserts an AutoSum formula for an adjacent row or column of numbers?
Causes of the Excel #REF! Error
Which of the following actions typically cause a formula to return the #REF! error? (Select all that apply)
Warehouse Timesheet Weekly Payroll Reconciliation
Scenario Background: The logistics supervisor has collected weekly employee timesheets. Staff are paid $22.00/hour for regular hours up to 40 hours, and 1.5x time-and-a-half ($33.00/hour) for any overtime hours worked beyond 40. Management needs to calculate total weekly gross wages committed across the warehouse team.
In summary cell D5, calculate the total gross payroll expenditure for the warehouse team. In rows 2 to 4, regular pay is calculated for hours up to 40 and overtime at 1.5x rate for hours above 40.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Employee | Hours Worked | Base Hourly Rate ($) | Total Gross Pay ($) |
| 2 | Marcus Vance | 40 | 22 | 880 |
| 3 | Sandra Lee | 45 | 22 | 1,045 |
| 4 | Kevin Hall | 50 | 22 | 1,210 |
| 5 | TOTAL PAYROLL COMMITMENT |
Inventory Restock Alert and Urgent Reorder Valuation
Scenario Background: The procurement manager received an inventory snapshot. Items whose Current Stock is strictly below the Safety Stock threshold require immediate restocking. Management needs to calculate the total replenishment capital required to purchase missing units up to the safety threshold.
In summary cell E5, calculate the total replenishment expenditure across all items needing reorder. For each item needing restock, replenishment cost = (Safety Stock - Current Stock) * Unit Cost. Sum the total replenishment capital in cell E5.
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | SKU | Current Stock | Safety Stock | Unit Cost ($) | Replenish Cost ($) |
| 2 | SKU-401 | 15 | 30 | 12 | 300 |
| 3 | SKU-402 | 50 | 8 | 0 | |
| 4 | SKU-403 | 10 | 25 | 20 | 300 |
| 5 | TOTAL REPLENISHMENT EXPENDITURE |
B2B Bulk Customer Orders Net Revenue Reconciliation
Scenario Background: The wholesale sales team offers volume discounts: orders with 50 or more units receive a 10% discount on their subtotal, while smaller orders receive 0% discount. Finance must reconcile the total net revenue collected across this batch of customer orders.
In summary cell E5, calculate the total net revenue collected from all three client orders after applying volume discounts. For each order: Net Revenue = Subtotal * (1 - Discount Rate).
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order ID | Client Name | Units Ordered | Gross Subtotal ($) | Net Revenue ($) |
| 2 | SO-801 | Nexus Logistics | 60 | 6,000 | 5,400 |
| 3 | SO-802 | Apex Retail | 25 | 2,500 | 2,500 |
| 4 | SO-803 | Summit Corp | 100 | 10,000 | 9,000 |
| 5 | TOTAL NET INVOICE REVENUE |
Corporate Department Budget Variance and Surplus Audit
Scenario Background: At the close of Q3, the corporate controller must report on total department budget variances (Budgeted minus Actual Spend). A positive variance indicates a surplus (favorable), while a negative variance indicates an overrun.
In summary cell D5, calculate the net departmental budget variance across all divisions (Total Budget - Total Actual Spend).
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Department | Budget Allocated ($) | Actual Spend ($) | Variance ($) |
| 2 | Engineering | 150,000 | 142,000 | 8,000 |
| 3 | Marketing | 85,000 | 91,000 | -6,000 |
| 4 | Sales | 110,000 | 105,000 | 5,000 |
| 5 | NET COMPANY BUDGET VARIANCE |
Customer Invoicing Line-Item Price Lookup & Total Cost
Scenario Background: The billing clerk is preparing a client invoice for multiple order line items. The unit prices must be matched from the master price list table, and the total billing charge across all order items must be calculated in the summary cell.
In summary cell D5, calculate the total invoice billing amount. Line totals equal Quantity * Price for each item.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Item Ordered | Quantity | Matched Unit Price ($) | Line Total ($) |
| 2 | Standard Monitor | 5 | 45 | 900 |
| 3 | Wireless Headset | 10 | 450 | |
| 4 | USB-C Dock | 4 | 75 | 300 |
| 5 | TOTAL INVOICE CHARGE |
Quarterly Sales Commission and Bonus Pool Allocation
Scenario Background: The sales director is approving end-of-quarter payouts. Sales reps who exceed their $100,000 quota earn a 5% commission on their total volume plus a $1,500 accelerator bonus. Reps who do not exceed quota earn a standard 3% commission with no bonus. Finance needs the total payout across the team.
In summary cell D5, calculate the total commission and bonus payout across the three sales representatives.
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Sales Rep | Quarterly Sales ($) | Quota Met? | Total Payout ($) |
| 2 | Derek Vance | 120,000 | Yes | 7,500 |
| 3 | Brooke Taylor | 80,000 | No | 2,400 |
| 4 | Cameron Diaz | 150,000 | Yes | 9,000 |
| 5 | TOTAL SALES INCENTIVE POOL |
M. Ichsanul Fadhil
Founder, ExcelClashPre-employment screening exams designed with instant browser-based formula grading.
Related Excel Skill Tests
SUMIFS & COUNTIFS Conditional Analysis Test
IF & Nested Logical Formulas Test
Text Functions & Data Cleaning Test
Basic Excel Skills Test: Free Online Assessment
Assessment Discussion & Questions
Ask questions, discuss problem solving techniques, or share feedback on this test.
Loading comments...