# ASSOC 2022 20Q Excel Quiz

## Quiz by Esan Hasan

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

20 questions
• Q1

What error will appear when we try to take the 4th root of a negative number?

####

#VALUE!

#DIV/0!

#NUM!

30s
• Q2

Which ribbon should be used to assign colour scale to a set of data?

Theme

Conditional Formatting

Home

View

30s
• Q3

Which of the following is not an excel function?

=MID

=MODE

=MEAN

=MEDIAN

30s
• Q4

If the contents of ‘C2’ were transferred to cell ‘C9’ what will be the result

#NUM!

#DIV/0!

15.983684

29.768186

30s
• Q5

Who created Microsoft Excel?

Bill Gates

Marshall Bruce Mathers III

Charles Simonyi

Dan Bricklin

30s
• Q6

What is the result of the formula “=RIGHT(“Actuarial Studies”,6)” ?

“t”

“udies”

“Actuar”

“tudies”

30s
• Q7

What is the name of the next column after column “Z”?

“AA”

“Z2”

“A1”

“2A”

30s
• Q8

RAND is a function in excel that generates an evenly distributed random real number. What is the range of this function?

0 to π

0 to 1

0 to 100

-100 to 100

30s
• Q9

How many rows are in a spreadsheet?

3327908

1048576

2376861720

255

30s
• Q10

What does the function VLOOKUP mean?

Venue Lookup

Value Lookup

Velocity Lookup

Vertical Lookup

30s
• Q11

Which option changes the styles of the cells?

A

C

D

B

30s
• Q12

How many columns are there in a spreadsheet?

26

52

16384

1048576

30s
• Q13

What type of file is a MS excel spreadsheet?

Article

Presentation

Document

Workbook

30s
• Q14

What is the intersection of a column and row?

Content

Cell

Block

Chamber

30s
• Q15

To use a function in Excel, use the symbol

=

<

=>

?

30s

Teachers give this quiz to your class