Want to create interactive content? It’s easy in Genially!

Get started free

Excel Pre-training Survey

Shannon Osborn-Jones

Created on October 25, 2024

Start designing with a free template

Discover more than 1500 professional designs like these:

Practical Survey

Akihabara Pre-training Survey

Akihabara Post-Training Survey

AI Diagnostic Survey for the Corporate Environment

Onboarding Quiz for New Employees

Work Style Quiz

Customer and Product Feedback Mobile

Transcript

Which Excel course should I sign up for?

By answering a few simple questions, we can help you figure out which level Excel course would be right for you!

Start

How do all Excel formulas start?

() (parentheses)

SUM

I'm not sure

= (equal sign)

How do you customize your status bar in Excel?

Go into Settings and choose customize.

Right click the Status bar and click the options you want.

Double click Status and then click "turn off".

I'm not sure

What formula should be used to calculate the total of Column B?

=SUM(B2:B8)

=Total(ColumnB)

I'm not sure

You should sign up for Excel Level 1!

Based on the answers you have given, Excel Level 1 would be the best class for you. Click the arrow below to sign up!

Restart

What is the purpose of the Function Wizard?

It will help predict the future.

It is used to rewrite all the formulas on your sheet.

It will help you enter functions correctly.

I'm not sure

What is the purpose of the "IF" function?

To calculate an average of 10 or more values.

To check whether a condition is met, and return one value if TRUE and another value of FALSE.

I'm not sure

To determine if the color of the cell is correct.

What does the MAX formula calculate?

The highest value that appears in the range.

The average of all the numbers in a column.

The total of all the numbers in each of the columns.

I'm not sure

7/8

You should sign up for Excel Level 2!

Based on the answers you have given, Excel Level 2 would be the best class for you. Click the arrow below to sign up!

Restart

How would you find specified values based on multiple conditions?

Use nested IF formula and VLOOKUP

The SUM function

A pivot table

I'm not sure

How can you protect cells from being edited by end-users?

On the Review tab, click Lock Cells

Click Ctrl + Shift + F

On the Review tab, click Protect Sheet

I'm not sure

What is the purpose of a pivot table?

to embed an image

to change one value into another

I'm not sure

to summarize and visualize data

7/8

You should sign up for Excel Level 3!

Based on the answers you have given, Excel Level 3 would be the best class for you. Click the arrow below to sign up!

Restart

7/8

You should sign up for Excel Level 4!

Based on the answers you have given, Excel Level 4 would be the best class for you. Click the arrow below to sign up!

Restart