Free Excel practice

Excel Formula Practice Quiz

Test beginner, intermediate, and advanced spreadsheet formulas for Microsoft Excel and Google Sheets, including SUM, IF, COUNTIF, SUMIF, XLOOKUP, IFERROR, UNIQUE, ROUND, and RANK.

Quick tour

How this tool works

1. Answer each question. Choose the formula or spreadsheet concept that fits the example, then submit when you are ready.
2. Move through levels. Start with beginner formulas, then switch to intermediate and advanced practice when you are ready for workplace reporting skills.

Beginner level

Beginner Excel formula quiz

Start with basic spreadsheet formulas used in school, admin work, budgeting, and simple reports.

Choose the best answer. Submit when you are ready to see explanations.

1. Which formula adds numbers in cells A1 to A5?
2. Which formula finds the average of B2 to B6?
3. Which formula finds the largest value in C1 to C10?
4. Which formula finds the smallest value in D1 to D10?
5. What does the range A1:A10 mean?

Excel skills this quiz supports

Spreadsheet skills are useful for office work, data entry, admin jobs, school tasks, budgeting, reports, and resume skills. This quiz supports Microsoft Office learning, digital literacy, Excel basics, Google Sheets practice, conditional formulas, lookup formulas, data cleanup, error handling, and workplace computer confidence.

Beginner formulas

Practice SUM, AVERAGE, MAX, MIN, and ranges for basic spreadsheet tasks.

Intermediate formulas

Learn IF, COUNTIF, SUMIF, CONCAT, and TRIM for cleaner workplace sheets.

Advanced formulas

Try XLOOKUP, IFERROR, UNIQUE, ROUND, and RANK for reports and analysis.

The goal is not only to memorize formulas. The tool helps beginners understand when to use each formula, why the formula works, and how it can appear in real spreadsheet work.

Trust note

Created for practical learning

Created by School of Daily Tips to help beginners build practical digital skills, resume confidence, Microsoft Office ability, and safer everyday computer habits.

Last updated: May 15, 2026

Privacy: This tool runs in your browser and does not save your input.

Related tools

Keep practicing

Computer Skills Checklist

Check your full beginner computer skills level before learning more Excel.

Resume Skills Builder

Turn Excel, spreadsheet, and office skills into resume wording.

Typing Speed Practice

Build typing confidence for data entry, reports, and spreadsheet work.

FAQ

Common questions

What Excel formulas should beginners learn first?

Beginners should start with SUM, AVERAGE, MAX, MIN, simple ranges, and basic cell references. After that, IF, COUNTIF, SUMIF, and XLOOKUP are useful for workplace spreadsheets.

Are Excel formulas good resume skills?

Yes. Excel formulas, spreadsheet reporting, data entry, tables, and Google Sheets skills can be useful resume keywords when they match the job and you can explain how you use them.

Should I learn Excel or Google Sheets first?

Either is fine for beginners because many spreadsheet ideas are similar. Excel is common in offices, while Google Sheets is common for online collaboration and shared files.

Help improve this tool

What did we forget?

If this tool missed an Excel formula, Google Sheets formula, quiz question, or workplace spreadsheet example, tell us. School of Daily Tips is built for real beginners, job seekers, students, and workers, so useful suggestions can help us improve the tool for the next visitor.

Send a suggestion

You can also email us directly at techpreneur3@gmail.com.

Back to all tools