Excel Personality Quiz

1

To start with, please tell us your first name* This field is required.

2

Ok, thanks {FirstName}, Let's begin the quiz!

3

What are the blank boxes on a spreadsheet called?* This field is required.

Cells

Squares

Info

Spots

4

Sorry! the correct answer is Cells. Excel has lots of them! The name of a cell is made up of the cross point between the Column Letter and the Row Name, ie; A1 is the first cell on the spreadsheet.

5

Yay, you got it right...

6

Nice work - straighten your glasses!

7

Yay, you got it right...

8

Close! The correct answer is actually: C =SUM(B3:B9). SUM is the function that calculates numbers excel. The range of numbers inside the brackets are called the 'arguments'.

9

You can only type numbers in Excel cells* This field is required.

True

False

10

Almost! The answer is False. You can type numbers and words into a cell. Excel knows which is which and will format accordingly.

11

An Excel sheet only contains 1 Workbook?* This field is required.

True

False

12

Not quite! A Workbook is the whole Excel 'document'. It can consist of multiple Worksheets, but gives you one to start off with. It's easy to create more sheets by clicking on the plus button to create them.

13

Thats right! A Workbook is the whole Excel 'document'. It can consist of multiple Worksheets, but gives you one to start off with. It's easy to create more sheets by clicking on the plus button to create them.

14

Which of the following is the correct way to add cells?* This field is required.

SUM(B3:C7)

=SUM(B3=C7)

SUM(B3=C7

=SUM(B3:C7)

15

Not quite! The answer is =SUM(B3:C7). The colon acts like a "from here to there" symbol. So you're saying plese add up the range from B3 to C7.

16

That's right! The colon acts like a "from here to there" symbol. So you're saying please add up the range from B3 to C

17

What’s the shortcut to find text in Excel?* This field is required.

Alt+C+F

Ctrl+F

Alt+F

18

Almost! The Shortcut steps in Excel are the same as in all of the Office products. S = Save, F is Find. If you're on a Mac it's Cmd + F

19

Correct! The Shortcut steps in Excel are the same as in all of the Office products. S = Save, F is Find. If you're on a Mac it's Cmd + F

20

Yay, you got it right...

21

Almost! The answer is B3:C7

22

Which of the following is NOT an Excel Function* This field is required.

=COUNT(A1:A3)

=AVERAGE(A1:A3)

=MAX(A1:A3)

=NUM(A1:A3)

23

Not quite! AVERAGE, COUNT and MAX are all functions in Excel. NUM is an error that you'll get if the formula doesn't make sense!

24

The feature to centre text across multiple cells is called:-* This field is required.

Merge & Centre

Shrink to fit

Number Formatting

Wrap Text

25

Yay, you got it right...It's Merge and Centre. Using this option, you can select a range of cells and then have Excel centre your text within this range.

26

Not quite! It's Merge and Centre. Using this option, you can select a range of cells and then have Excel centre your text within this range.

27

AutoSum is:* This field is required.

A combination of numbers and symbols used to express a calculation

A function that adds the values in a function or set of cells

A function that returns the middle number in a range

A method used to copy a cell's formatting and contents to other cells

28

Nearly! Autosum is a function that allows you to add up a range of cells - it looks like this =SUM(A1:A10). Functions have 3 parts: the = sign, the name of the function, and the arguments inside the brackets. There are more than 400 pre defined Excel functions to help you get your work done efficiently.

29

What is the keyboard shortcut to lock cell references in a formula? (Absolute Reference?)* This field is required.

CTRL

ALT

F2

F4

30

Not quite! F4 creates an absolute reference by adding $ in front of each of the row and column references. It works in a circular action so if you keep pressing it it will add to the row, the column, then both and around again.

31

What is a Pivot Table?:-* This field is required.

A table with relation to another table

A type of graph

A feature that allows you to extract significant data from a large set

A feature that shows how far a value deviates from a set

32

Sorry! A pivot table allows you to take large sets of data and extract short and meaningful sets of data from it.

33

Which VLOOKUP function would return "Pears" from the table above it:* This field is required.

=VLOOKUP(10251, A1:B6, 2, FALSE)

=VLOOKUP(10247, A1:B6, 2, TRUE)

=VLOOKUP(10251, A1:B1, 2, FALSE)

=VLOOKUP(10251, A1:B6, B, FALSE)

34

Ahh! that one was quite tricky wasn't it? The arguments in a V Lookup are: What to look for, where to look for it, which column you want to bring back the answer from and whether you want an exact answer or not. So, B was the answer.

35

That one was quite tricky wasn't it? The arguments in a V Lookup are: What to look for, where to look for it, which column you want to bring back the answer from and whether you want an exact answer or not. So, B was the answer. You are right !!

36

Which Excel feature allows for all cells that are formulas to be selected/highlighted?* This field is required.

Find

Go To Special

Go To

Replace

37

Nearly, the Go To Special command has an option that allows you just to highlight the cells that you can see. It's a little different to Find and go to and is really useful if you're using a table where you've filtered information that you don't need to copy.

also, in case you're wondering, the shortcut for Find is Ctrl + F on a PC, and Cmd+F on a Mac. It works in all of the Microsoft applications

38

The Go To Special command has an option that allows you just to highlight the cells that you can see. It's a little different to Find and go to and is really useful if you're using a table where you've filtered information that you don't need to copy.

also, in case you're wondering, the shortcut for Find is Ctrl + F on a PC, and Cmd+F on a Mac. It works in all of the Microsoft applications

39

Which of the following features cannot be found in the "Data" ribbon* This field is required.

What-if Analysis

Pivot Table

Data Validation

Text to Columns

40

Not quite.

Pivot Tables are found in the Insert Menu. What-if Analysis, Data Validation and Text to Columns are all great time saving functions in Excel. If you've never used them, you should give them a go!

41

Nice work - straighten your glasses!

42

Which is not a valid report format* This field is required.

Compact

Discreet

Report

Tabular

43

Congratulations, you have completed the questions. Your score is:

44

Congratulations, you have finished the test with a score of {yourScore} out of 20.

You’re an excel explorer. You’re keen to get a handle on the best and most productive ways to count numbers without using a calculator. You’ve been a bit worried in the past about how everyone else can use excel but you are better at other things but we know that if you put your mind to it you’ll be good at this too.

45

You got {yourScore} out of 20, you're an Excel Creator!

You love how excel can make putting your figures together so easy but you’re a bit miffed by how many menu options there are and all the opportunities available - if you only knew what they all did! One day you’ll get them all under your hat, and you can’t wait for that day! You particularly can’t wait to learn how you make those sheets look beautiful as well as functional. We've got some great Excel Explorer classes you can attend, click below to view our training calendar.

46

You got {yourScore} out of 20, you're an Excel Magician?

You’ve been working with Excel for years and consider it to be one of your strengths. Everyone in the office comes to you when they have a question about a v lookup or a pivot table, but you really want to know why index and match is better than a lookup and why a data table and array formulas work better than a pivot table in some cases. You can’t wait to produce real magic from your excel masterpieces and impress the big bosses. We've got some great Excel Magician classes you can attend to hone those skills even further, click below to view our training calendar.

47

You got {yourScore} out of 20, you're an Excel Outlaw!

You don’t think inside the box, you think around the edges and bounce off every corner. You are not satisfied with the standard set of numbers provided by the accountant. You want to create valuable, connected and automated spreadsheets that both save time and produce results. You want value out of your time, and you’re prepared to put in the effort up front to get the best results later on. We've got some great Excel Outlaw classes you can attend to take you to the next level - a Ruler!! click below to view our training calendar.

48

You got {yourScore} out of 20!!

You're an Excel Ruler

You are a whiz with a spreadsheet. You can fly around that thing like a pro. You know sums and counts and can format the thing like a beautiful bouquet, but you now want to rule that thing like a King. You want to know array formulas, nested if statements and text formulas to search strings. King or queen of excel. That’s who you want to be. Check out our schedule for our Advanced Excel classes - in case you think there's something else you might want to add to your ammunition!

49

Thank you for taking our Quiz... When you hit submit, you will be taken to our training calendar page. If you would like to make an enquiry or have any questions about Excel training classes, please leave your email address here:

example@example.com