Unlock hundreds more features
Save your Quiz to the Dashboard
View and Export Results
Use AI to Create Quizzes and Analyse Results

OR
Sign inSign in with Facebook
Sign inSign in with Google
Quizzes > Computers & IT

Free Online Excel Test: Questions and Answers Quiz

Quick, free Excel quiz with answers. Instant results.

Editorial: Review CompletedCreated By: Vetiola MiciUpdated Aug 25, 2025
Difficulty: Moderate
2-5mins
Learning OutcomesCheat Sheet
Paper art illustration showing excel spreadsheet quiz with test questions and answers on sky blue background

This Excel test helps you practice key skills like formulas, tables, and charts, so you can find gaps fast. Get instant results with answers and tips to guide your study. For more practice, try our excel quiz or build your Office basics with a Microsoft Word quiz.

Which keyboard shortcut inserts an AutoSum formula on Windows Excel?
Ctrl + A
Ctrl + Shift + S
Alt + S
Alt + =
undefined
The SUM function ignores text values in the referenced cells.
False
True
undefined
What is the default file extension for a modern Excel workbook?
.xls
.xlsm
.xlsx
.csv
undefined
The Fill Handle can be used to copy a formula down a column.
True
False
undefined
Which function returns the arithmetic mean of a set of numbers?
AVERAGEA
MEAN
AVERAGE
MEDIAN
undefined
When using VLOOKUP with approximate match (TRUE), what must be true about the first column of the table array?
It must contain unique IDs only
It must be formatted as text
It must be the leftmost column on the sheet
It must be sorted in ascending order
undefined
Pressing Ctrl + T converts a range to an Excel Table.
True
False
undefined
Which feature restricts user input to a predefined dropdown list of values?
Protect Sheet
Filter
Data Validation (List)
Remove Duplicates
undefined
PivotTables automatically refresh when the source data changes by default.
False
True
undefined
Which function removes extra spaces, leaving single spaces between words and trimming leading/trailing spaces?
TRIM
CLEAN
SUBSTITUTE
TEXT
undefined
In versions of Excel without XLOOKUP, which approach allows a lookup to the left of the key column?
HLOOKUP
TRANSPOSE with VLOOKUP
VLOOKUP with range_lookup FALSE
INDEX with MATCH
undefined
XLOOKUP is available in all Excel versions from 2010 onward.
True
False
undefined
Which dynamic array function generates a sequential list of numbers without dragging the fill handle?
SEQUENCE
UNIQUE
RANDARRAY
ROWS
undefined
Power Query can import and transform data from CSV and JSON files.
False
True
undefined
Which source reference is a structured reference to a Table column, suitable for a Data Validation list that expands as the table grows?
=Items
A:A
$A$2:$A$100
=Products[List]
undefined
Which function lets you assign names to calculations inside a formula to improve readability and performance?
SUMPRODUCT
DEFINE
LET
WITH
undefined
The INDIRECT function is volatile and recalculates whenever the workbook recalculates.
False
True
undefined
Which reference syntax correctly sums cell A1 across all worksheets from Jan to Mar?
=SUM(A1!Jan:Mar)
=SUM(Jan:Mar.A1)
=SUM('Jan:Mar'!A1)
=SUM(Jan-Mar!A1)
undefined
By default, Excel automatically resolves circular references without user intervention.
True
False
undefined
Which tool allows you to step through a formula calculation one operation at a time?
Trace Precedents
Goal Seek
Watch Window
Evaluate Formula
undefined
0

Study Outcomes

  1. Apply core Excel functions -

    Use formulas like SUM, IF, and VLOOKUP to solve practical spreadsheet challenges presented in the quiz.

  2. Format worksheets effectively -

    Demonstrate skills in cell formatting, conditional highlighting, and layout optimization to enhance readability and presentation.

  3. Analyze data with pivot tables and charts -

    Create pivot tables and charts to summarize and visualize data insights, reinforcing data analysis techniques.

  4. Identify and correct errors -

    Spot common formula mistakes and employ troubleshooting strategies to ensure accurate results.

  5. Practice with Excel quiz questions -

    Engage with Microsoft Excel quiz questions and excel practice questions to test your Excel knowledge in real-world scenarios.

  6. Assess proficiency through the scored quiz -

    Evaluate your skills instantly with quiz feedback and identify areas for improvement.

  7. Utilize the Excel test questions and answers PDF -

    Download the PDF to review questions and answers offline, reinforcing learning and tracking progress.

Cheat Sheet

  1. Absolute vs Relative References -

    Mastering cell references ensures formulas behave as expected when copied. For example, $A$1 locks both column and row, while A1 adjusts relatively; remember "Lock it, don't let it drop" as a quick mnemonic. (Source: Microsoft Support)

  2. Lookup Functions: VLOOKUP vs INDEX/MATCH -

    VLOOKUP is handy for simple vertical searches (e.g., =VLOOKUP(B2,Table,3,FALSE)), but INDEX/MATCH offers more flexibility and speed on large data sets. Combining INDEX and MATCH can prevent errors when adding columns - think "MATCH first, then INDEX" to recall the sequence. (Source: University of Washington Data Lab)

  3. SUMIFS and COUNTIFS for Conditional Aggregation -

    SUMIFS and COUNTIFS let you sum or count with multiple criteria, such as =SUMIFS(Sales,Region,"East",Month,"Jan"). These functions are essential for real-world reporting - just remember "SIC" (Sum If Conditions) to recall SUMIFS. (Source: Journal of Financial Analytics)

  4. PivotTables for Dynamic Reporting -

    PivotTables turn raw data into interactive summaries by dragging fields into Rows, Columns, and Values. Use them to quickly group dates, calculate subtotals, and filter large tables; think of PivotTables as your "data Swiss Army knife." (Source: Official Microsoft Documentation)

  5. Data Validation & Conditional Formatting -

    Data Validation restricts user input (e.g., dropdown lists via Data > Data Validation), while Conditional Formatting highlights trends (e.g., color scales for top 10% values). Together they ensure accuracy and visual insights - remember "Validate to control, Format to show." (Source: Harvard Business School Publishing)

Make a Quiz (FREE) Copy & Edit This Quiz Create a Quiz with AI

Computers & IT Quizzes

Powered by: Quiz Maker