IntegrationsAX AuditNewPricingBlogSupport
Dashform
DashformDashform

© 2026 Dashform

Forms your customers recognize and AI agents can book.

InstagramYouTubeX
Product
  • AI Tools
  • Templates
  • Pricing
  • Dashform CLI for Agents
  • What is Dashform
  • AI Info
  • AX Audit New
  • Affiliate
Solutions
  • Coaches & Consultants
  • Agencies
  • Wellness & Local Services
  • Trades & Home Services
  • Real Estate
  • Legal, Finance & Accounting
Use Cases
  • Assessment/Quiz
  • Waitlists
  • Survey
  • Webinars
  • Feedback/NPS
  • Appointment Booking
  • Client Onboarding
  • Lead Qualification
  • Product Recommendation
Compare
  • Typeform alternative
  • Tally alternative
  • Google Forms alternative
  • Jotform alternative
  • GoHighLevel alternative
  • involve.me alternative
  • LeadQuizzes alternative
Company
  • Blog
  • Docs
  • Privacy Policy
  • Terms of Service
Get Started Free
Categories/Education & Learning

How Good Am I at Excel? 2026

How Good Am I at Excel?

Nine workflow scenarios cover duplicate records, lookups, formula errors, summaries, protection, dates, charts, VBA events, and conditional counts. "How would you protect selected cells while leaving others editable?" distinguishes sheet protection from workbook structure, and the final counting scenario focuses on simultaneous conditions. Examples include "Excel Newcomer" and "Excel Power User". The displayed profile is random, not an assessment of your answers; no workbook is executed or Excel proficiency measured.

Dashform team markPublished by Dashform Team, Product education·Last reviewed February 22, 2026
9 Questions
Take quiz

Ready? Let's Find Out.

One of the listed results is selected at random. Your answers are not scored or used to choose the result.

Guided QuestionsPossible Results~2 min

Make your own quiz with AI

Create engaging quizzes tailored to your brand. Our AI-powered quiz generator helps you build personalized assessments that capture attention and drive engagement.

Try Free AI Quiz Generator

Quiz transcript

A list contains 500 customer names with possible duplicates. What approach would you consider?
1

A list contains 500 customer names with possible duplicates. What approach would you consider?

Review the names manually before deciding which entries are duplicates
Use Remove Duplicates after checking the identifying columns and keeping a copy
Use COUNTIF to flag repeated values for review
Build a Power Query deduplication step using agreed matching columns
You need a price from a table using product ID. Which approach would you use?
2

You need a price from a table using product ID. Which approach would you use?

Look up and copy each price manually
VLOOKUP with an exact match when the ID column is first
INDEX/MATCH with an exact match when columns need flexibility
XLOOKUP with an explicit not-found value where the Excel version supports it
A shared workbook shows #VALUE!. What would you do?
3

A shared workbook shows #VALUE!. What would you do?

Replace the formula with a guessed number
Ask the author about the intended calculation
Check input types and the formula for text-number mismatches
Trace precedents and evaluate the formula before deciding whether IFERROR is appropriate
How would you summarize sales by region and month from 2,000 rows?
4

How would you summarize sales by region and month from 2,000 rows?

Filter groups separately and record each total
Build a PivotTable with region, month, and summed sales
Use SUMIFS with region and suitable month date boundaries
Use a data-model PivotTable if relationships or reusable measures are needed
How would you protect selected cells while leaving others editable?
5

How would you protect selected cells while leaving others editable?

Ask how worksheet protection works
Unlock editable cells, keep protected cells locked, then protect the sheet
Set editable ranges as needed, then protect the sheet and test access
Distinguish workbook structure protection from cell protection before choosing settings
How would you label valid dates as Overdue, Due Today, or Upcoming?
6

How would you label valid dates as Overdue, Due Today, or Upcoming?

Color the dates manually instead of using a formula
Use a single IF comparing the date with TODAY(), leaving only two labels
Use nested IF tests for before today, equal to today, and later
Use IFS with the same three conditions and handle blank or invalid inputs separately
What would you consider when creating a chart?
7

What would you consider when creating a chart?

Use the default chart without reviewing it
Choose a suitable chart type and clear titles
Adjust labels, colors, and gridlines while keeping the data readable
Use a suitable table or dynamic source and verify expansion or refresh when data changes
Where would code for opening a macro-enabled workbook go?
8

Where would code for opening a macro-enabled workbook go?

I have not used the VBA editor
In a standard module that I run manually
In Workbook_Open within ThisWorkbook, where macros are permitted
In Workbook_Open with error handling and explicit worksheet references
How would you count North-region orders over £500?
9

How would you count North-region orders over £500?

Count visually after checking the filtered rows
Count each condition separately, which does not identify their intersection
Use COUNTIFS with both conditions over equal-length ranges
Use SUMPRODUCT with both Boolean conditions over equal-length ranges when array logic is useful

Possible Results

Discover what your quiz results might reveal

Excel Newcomer

Excel Newcomer

Workflow example: someone starting with spreadsheets may benefit from practicing cell references, simple formulas, and small tables with known answers. Keep an original copy before changing data and check a calculation manually. This random learning profile does not show that you lack Excel skill; the quiz has not opened or graded a workbook.

Everyday User

Everyday User

Workflow example: routine work may involve sorting, filters, basic formulas, and charts. A useful next exercise is to make a summary repeatable and check totals against the source. Choose a tool that fits the task rather than assuming more complexity is better. The profile is randomly displayed and does not certify your current level.

Formula-Fluent Analyst

Formula-Fluent Analyst

Workflow example: lookups, conditional summaries, and error investigation can support analysis when inputs and assumptions are checked. Practice exact matches, date boundaries, and tracing a wrong result to its source. This random example does not prove formula fluency or that your answers were correct; use an actual workbook exercise to verify skill.

Excel Power User

Excel Power User

Workflow example: Power Query, data models, and VBA can help repeat suitable tasks, but also add maintenance and version requirements. Useful advanced work includes documentation, explicit references, error handling, and verification after refresh. This random profile does not establish expertise, certify automation, or guarantee that a complex tool will be faster.

Related tool

More education and learning quizzes →

Browse quizzes about learning, study habits, and knowledge.

FAQ

Similar quizzes

Explore more quizzes in this category

Coaching & Consulting Webinar

Coaching & Consulting Webinar 2026

Compare the kind of coaching or consulting support you would seek through ten questions about goals, working style, implementation help, team training, and signs of progress. "What would make this session most valuable for you?" contrasts action steps, new perspectives, independent tools, and accountability. The displayed Ending is chosen randomly and is not determined by your answers. This is a preference exercise with no contact fields; it neither registers you for a webinar nor supplies a consulting engagement. "The Action-Oriented Achiever" emphasizes practical next steps, while "The Reflective Strategist" offers a contrasting focus on examining choices.

Common Sense Quiz

Common Sense Quiz 2026

Ten short riddles focus on wording and assumptions. "How many months have 28 days?" invites you to separate what is stated from what you imagine. The Ending "Good Logical Thinker" is a practice message selected randomly after the questions, without counting correct answers. Simple calculations sit alongside a letter puzzle that keeps its English words in translations so the wordplay still works.

Community or Workshop Webinar

Community or Workshop Webinar 2026

Explore what you would want from a community workshop: practical instruction, shared experimentation, new connections, or a chance to contribute. "How do you prefer to participate in group activities?" sits alongside questions about group size, materials, and follow-up interests. The displayed Ending is chosen randomly and is not determined by your answers. This public quiz is a workshop-fit reflection: it has no contact fields, does not reserve a place, and does not send workshop links. "The Dedicated Learner" focuses on building skills, while "The Thoughtful Contributor" considers contributing experience to the group.

Webinar Learning Preferences

Webinar Learning Preferences 2026

Ten questions explore what you want to learn, how you participate, and what you could use after a session. "What device will you primarily use to attend the webinar?" adds device context, while "Are you interested in earning a certificate of completion?" asks about certificate interest. Examples include "Curious Explorer" and "Engaged Practitioner". The final learning profile is randomly selected and independent of answers. This preview does not register you, reserve a place, send materials, or issue a certificate.

Email Marketing Strategy Quiz

Email Marketing Strategy Quiz 2026

Review ten parts of an email program, starting with "Select the approach that best describes your list building strategy" and continuing through cadence, personalization, automation, segmentation, testing, subject lines, nurturing, analytics, and deliverability. The questions can organize a discussion about current practices. An Ending such as "Email Novice" is drawn randomly, without inspecting campaign data or using your selections. The four examples offer planning ideas rather than a maturity rating, personalized audit, or promise of higher revenue.

Expert Talk / Guest Session

Expert Talk / Guest Session 2026

Prepare for an expert talk by considering speaker interests, topic familiarity, useful formats and recording preferences. "Which material would help you prepare for the talk?" asks which preparation material would help, distinct from the desired takeaway. "The Engaged Participant" is one of four sample Endings. The sample is random and independent of answers. This quiz neither registers attendance nor collects a question for the speaker.

See more quizzes→

Related articles

Tips, guides, and insights on quizzes and lead generation

AI product recommendation quiz guiding ecommerce shopper to personalized product match
ArticleTipsTutorial

AI Product Recommendation Engines for Ecommerce

How to design an AI-assisted product quiz, map answers to recommendations, configure external tools, and measure the result for your store.

March 9, 2026
Comparison of database-first form builder versus AI-powered lead generation forms
AlternativeArticle

Dashform and Fillout for Lead Intake

Compare Dashform and Fillout for lead intake, AI drafting, qualification, database connections, and the handoffs to test before switching.

March 8, 2026
FormHug vs. Dashform comparison, showing FormHug as a simple web form and Dashform as an AI-enhanced interface, titled 'FormHug Alternative'.
Alternative

FormHug Alternative: Dashform Compared

FormHug vs Dashform side by side: AI quiz funnels, lead scoring, and pricing. Where FormHug excels and where switching makes sense for agencies and coaches.

February 26, 2026
Read more articles →
Ready to create your own quiz?
Generate engaging, AI-powered quizzes tailored to your brand and audience.
Generate quiz with AIBrowse all quizzes