Excel Mastery Quiz

Question 1

Which symbol is used to reference another sheet in a formula?

Accepted Answer

!

Question 2

True or False: You can undo your actions in Excel using Ctrl + Z.

Accepted Answer

True

Question 3

What does the VLOOKUP function do?

Accepted Answer

Looks up values vertically

Question 4

If Excel were a superhero, what would be its power?

Accepted Answer

Data crunching

Question 5

True or False: Line charts are best for showing trends over time.

Accepted Answer

True

Question 6

What does Excel say when it's tired?

Accepted Answer

"Give me a break()"

Question 7

How do you convert a data range into a table in Excel?

Accepted Answer

Click Insert > Table

Question 8

What will the formula =5+3*2 return?

Accepted Answer

11

Question 9

True or False: Table headers are optional in Excel Tables.

Accepted Answer

False

Question 10

True or False: =10/0 returns 0 in Excel.

Accepted Answer

False

Question 11

formulas always begin with the '=' symbol followed by cell references and operators

Accepted Answer

True

Question 12

How can you switch between sheets quickly?

Accepted Answer

Ctrl + Tab

Question 13

True or False: You cannot link data between sheets in Excel.

Accepted Answer

False

Question 14

What does Excel say when it cannot divide your number by 0?

Accepted Answer

#DIV/0!

Question 15

If Excel were a movie genre, what would it be?

Accepted Answer

Documentary

Question 16

Which function returns the largest value in a range?

Accepted Answer

MAX

Question 17

These two are the creators of VisiCalc, the first spreadsheet program (say Excel's inspiration) - Multiple Answers

Accepted Answer

Bob Frankston, Daniel Singer Bricklin

Question 18

Which of the following is NOT a common dashboard element?

Accepted Answer

Macros

Question 19

What is the default file extension for an Excel workbook?

Accepted Answer

.xlsx

Question 20

What is a benefit of using Excel Tables?

Accepted Answer

Automatic filtering and formatting

Question 21

What snack best represents Excel functions?

Accepted Answer

Pizza – because of the slices

Question 22

Which chart type is best for comparing values across categories?

Accepted Answer

Bar chart

Question 23

What does Excel say when it needs some space?

Accepted Answer

###

Question 24

Excel is part of which Microsoft Office Suite?

Accepted Answer

Microsoft Office

Question 25

Which symbol is used for multiplication in Excel formulas?

Accepted Answer

*

Question 26

What is a dashboard in Excel?

Accepted Answer

A visual summary of data

Question 27

What does the formula =IF(A1>10,"High","Low") return if A1 is 15?

Accepted Answer

High

Question 28

Which chart type is best for showing parts of a whole?

Accepted Answer

Pie

Question 29

True or False: Dashboards in Excel are interactive.

Accepted Answer

True

Question 30

Which tab in Excel contains the 'Save As' option?

Accepted Answer

File

Excel Mastery Quiz

Questions 30

Excel Mastery Quiz

Questions 30