Spreadsheet Course Placement Quiz template

Use this short spreadsheet placement quiz to start a course conversation with evidence of current knowledge. Three example questions cover a sum formula, an absolute reference and a chart choice. Correct answers earn one point each, and the ending shows the score and an answer recap alongside a clear practice-only explanation.

Use this template Start free — no card

8 questions · Free plan: 500 responses/month · fully customizable

Editable split-screen artwork
Replaceable example logo and coordinated theme
Animated question transitions
1 built-in logic rule
Scored answers for quiz-style results

Interactive — fill it in like a respondent would.Open full width

What’s inside

The questions this template ships with — rename, reorder, or delete any of them in the builder.

01Learner nameShort text

02Email for course informationEmail

03Have you used a spreadsheet before?Multiple choice

04Which spreadsheet app do you use?Short text

05Which formula adds cells A1 through A5?Multiple choice

06Which reference stays fixed when copied?Multiple choice

07Which chart is usually suitable for a time series?Multiple choice

08What do you want to use spreadsheets for?Long text

When to use this template

Choosing a starting class for a spreadsheet workshop
Running a low-stakes knowledge check before training
Discussing learning goals alongside a short practice result

Tips to get more from it

Review every correct answer and replace the examples with your actual course prerequisites.
Keep the result advisory. Three questions do not establish professional competence or award a certification.
The ending has score and answer-reveal options enabled; turn either off in the Ending Page editor if you prefer tutor-led feedback.

Example response and next steps

Illustrative example, not a real customer submission.

A learner completes the three-question placement check before discussing a course. The sample below answers two questions correctly; it is a teaching example, not a validated assessment of job readiness.

Which formula adds cells A1 through A5?: =SUM(A1:A5)
Which reference stays fixed when copied?: A1
Which chart is usually suitable for a time series?: Line chart

How to use the response

This response earns two of three points. The missed fixed-reference question suggests a useful topic for the first lesson, but three multiple-choice answers cannot establish overall proficiency. Combine the result with the learner’s stated goal before recommending a course.

Before publishing your version

Check every correct answer and point value after editing options. Submit an all-correct response and one with a wrong answer, and confirm the ending score and answer recap. Test the beginner path so the experience follow-up is skipped as intended.

Questions people ask

How does the conditional logic work?

When “Have you used a spreadsheet before?” is answered “No”, the form skips the intervening follow-up and continues at “Which formula adds cells A1 through A5?”. Other answers keep the follow-up visible. Test both paths after changing choices or moving questions.

How is the quiz scored?

Each of the three marked answers is worth one point, for a maximum of three. The ending uses the form’s quiz scoring to show the result and correct-answer recap.

Can I change the logo, imagery and ending?

Yes. CELL SCHOOL is an editable example brand. Replace its logo in Design → Branding, change or disable the field’s split layout, and edit the Ending Page message and visual. The original artwork is included as a local template asset.

Which plan does this template need?

The included core fields, conditional logic and three layouts work on Free, which includes 500 responses per month. Adding payment, signature or NPS fields requires a paid plan; removing Zunoform branding also requires a paid plan.