Basic Excel Skills Test: Free Online Assessment
This free basic Excel skills test assesses your ability to perform cell math, sum columns, calculate averages, count values, and format numbers. Ideal for students, job applicants, and new spreadsheet users.
Formula Starting Syntax
Which character must always be typed first in an Excel cell to initiate an active formula calculation?
Calculate Total Regional Revenue with SUM
In target cell C6, calculate the total revenue across all sales regions using the SUM function.
| # | A | B | C |
|---|---|---|---|
| 1 | Region | Units Sold | Revenue ($) |
| 2 | North | 140 | 4,200 |
| 3 | South | 95 | 2,850 |
| 4 | East | 210 | 6,300 |
| 5 | West | 180 | 5,400 |
| 6 | Total Revenue |
Standard Aggregation Functions
Which of the following are valid built-in aggregation functions in Microsoft Excel? (Select all that apply)
Calculate Average Units Sold
In target cell B6, calculate the average units sold per region using the AVERAGE function.
| # | A | B | C |
|---|---|---|---|
| 1 | Region | Units Sold | Revenue ($) |
| 2 | North | 140 | 4,200 |
| 3 | South | 95 | 2,850 |
| 4 | East | 210 | 6,300 |
| 5 | West | 180 | 5,400 |
| 6 | Average Units |
Cell Referencing & Locking Shortcut
What keyboard shortcut cycles through relative (A1) and absolute ($A$1) cell references while editing a formula in Excel?
Find Lowest Price with MIN Function
In target cell B6, find the minimum item unit price from the product list using the MIN function.
| # | A | B |
|---|---|---|
| 1 | Item | Unit Price ($) |
| 2 | Wireless Mouse | 24.5 |
| 3 | Mechanical Keyboard | 89.99 |
| 4 | USB-C Hub | 19.99 |
| 5 | Monitor Arm | 45 |
| 6 | Lowest Price |
Mathematical Operator Precedence
What will be the calculated result of the Excel formula =5 + 2 * 10?
Calculate Net Profit Margin Amount
In target cell D2, calculate the Net Profit by subtracting Cost (C2) from Revenue (B2).
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Product | Revenue ($) | Cost ($) | Net Profit ($) |
| 2 | Consulting Package A | 1,200 | 750 |
COUNT vs. COUNTA Distinction
If a column contains a mixture of customer names (text) and invoice amounts (numbers), which function counts only the cells with numeric values?
Count Registered Attendees with COUNTA
In target cell B7, count the total number of registered attendee names in column A using the COUNTA function.
| # | A | B |
|---|---|---|
| 1 | Attendee Name | Status |
| 2 | Alice Smith | Confirmed |
| 3 | Bob Johnson | Confirmed |
| 4 | Charlie Lee | Confirmed |
| 5 | Diana Prince | Confirmed |
| 6 | Evan Wright | Confirmed |
| 7 | Total Attendees |
Identify Highest Value with MAX
Which formula correctly determines the highest score from the range B2 to B20?
Find Peak Daily Sales with MAX
In target cell B7, find the maximum daily sales volume recorded in column B using the MAX function.
| # | A | B |
|---|---|---|
| 1 | Day | Sales ($) |
| 2 | Monday | 1,450 |
| 3 | Tuesday | 2,100 |
| 4 | Wednesday | 1,890 |
| 5 | Thursday | 2,840 |
| 6 | Friday | 3,250 |
| 7 | Peak Sales |
Relative vs. Absolute Reference Behavior
When formula =$A$1*B1 in cell C1 is copied down to cell C2, which statements are true? (Select all that apply)
Calculate Percentage of Total Revenue
In target cell C2, calculate Department A's share of total sales by dividing Sales (B2) by Total Sales (B6).
| # | A | B | C |
|---|---|---|---|
| 1 | Department | Sales ($) | Share |
| 2 | Hardware | 4,000 | |
| 3 | Software | 6,000 | |
| 4 | Services | 10,000 | |
| 5 | Total | 20,000 |
Excel Division Error Meaning
Which error code appears in a cell when a formula attempts to divide a number by zero or by an empty cell?
Calculate Total Bill with Cell Multiplication
In target cell D2, calculate Total Cost by multiplying Quantity (B2) by Unit Price (C2).
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Product | Quantity | Unit Price ($) | Total Cost ($) |
| 2 | Office Desk | 15 | 120 |
AutoSum Shortcut Key
Which keyboard shortcut automatically inserts the =SUM() formula for an adjacent column or row in Excel?
Calculate Employee Hourly Wage Total
In target cell D2, calculate Gross Pay by multiplying Hours Worked (B2) by Hourly Rate (C2).
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Employee | Hours | Rate ($) | Gross Pay ($) |
| 2 | Sarah Jenkins | 40 | 25.5 |
Standard Basic Arithmetic Operators
Which of the following symbols are standard arithmetic operators recognized in Excel formulas? (Select all that apply)
Count Numeric Product Codes with COUNT
In target cell B7, count how many numeric codes are logged in column B using the COUNT function.
| # | A | B |
|---|---|---|
| 1 | Product | SKU Code |
| 2 | Paper Clips | 1,001 |
| 3 | Stapler | 1,002 |
| 4 | Marker Pen | 1,003 |
| 5 | Folder | 1,004 |
| 6 | Binder | 1,005 |
| 7 | Numeric SKUs |
Freeze Panes Purpose
What is the primary function of the 'Freeze Panes' feature in Excel?
Calculate Order Balance After Deposit
In target cell D2, calculate the Remaining Balance by subtracting Deposit Paid (C2) from Invoice Total (B2).
| # | A | B | C | D |
|---|---|---|---|---|
| 1 | Client | Invoice ($) | Deposit ($) | Balance Due ($) |
| 2 | Acme Corp | 5,400 | 1,800 |
What Does the #VALUE! Error Mean?
Why does Excel display a #VALUE! error when evaluating a formula like =A1+B1?
Calculate Combined Team Headcount with SUM
In target cell B6, calculate total team headcount across all departments using the SUM function.
| # | A | B |
|---|---|---|
| 1 | Department | Headcount |
| 2 | Engineering | 45 |
| 3 | Marketing | 18 |
| 4 | Operations | 27 |
| 5 | Human Resources | 9 |
| 6 | Total Headcount |
Selecting Non-Adjacent Cells & Ranges
Which actions allow you to select non-adjacent (separate) cells or ranges in an Excel worksheet? (Select all that apply)
Find Lowest Exam Score with MIN
In target cell B6, find the lowest student test score in column B using the MIN function.
| # | A | B |
|---|---|---|
| 1 | Student | Score |
| 2 | Marcus | 88 |
| 3 | Chloe | 94 |
| 4 | Daniel | 62 |
| 5 | Sophia | 79 |
| 6 | Lowest Score |
Column Width Error Indicator
What appears across a cell when a formatted number or date is too wide to fit in the current column width?
Calculate Average Monthly Utility Bill
In target cell B6, calculate the average monthly electricity bill using the AVERAGE function.
| # | A | B |
|---|---|---|
| 1 | Month | Electric Bill ($) |
| 2 | January | 160 |
| 3 | February | 140 |
| 4 | March | 180 |
| 5 | April | 120 |
| 6 | Average Bill |
Undo Action Keyboard Shortcut
Which universal keyboard shortcut reverses your last action in Excel?
Calculate Total Inventory Valuation
In target cell C6, calculate total inventory valuation across all warehouse items using the SUM function.
| # | A | B | C |
|---|---|---|---|
| 1 | Item | Stock | Total Value ($) |
| 2 | Widget Pro | 100 | 2,500 |
| 3 | Widget Mini | 250 | 3,750 |
| 4 | Widget Max | 80 | 3,200 |
| 5 | Widget Ultra | 50 | 3,550 |
| 6 | Total Valuation |
M. Ichsanul Fadhil
Founder, ExcelClashPre-employment screening exams designed with instant browser-based formula grading.
Related Excel Skill Tests
VLOOKUP & XLOOKUP Skills Test: Workplace Assessment
Excel Test for Administrative Assistants
Excel Test for Accounting & Bookkeeping
Excel Test for Entry-Level Data Analysts
Assessment Discussion & Questions
Ask questions, discuss problem solving techniques, or share feedback on this test.
Loading comments...