placeholder image to represent content

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!

New Quizalize solo game modes
20 questions
Show answers
  • 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

    Question Image

    #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?

    Question Image

    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?

    Question Image

    Content

    Cell

    Block

    Chamber

    30s
  • Q15

    To use a function in Excel, use the symbol

    =

    <

    =>

    ?

    30s

Teachers give this quiz to your class