Quizalize logo
placeholder image to represent content

Quiz Excel

Quiz by BENSALEM Adib

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

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

    The COUNT function will not count negative numbers when evaluating a range ofvalues. True or false?

    false
    true
    True or False
    30s
  • Q2

    You need to determine the largest value in a range of numbers. Which functionshould you use?

    MIN 

    SUM 

    COUNT

       MAX

    30s
  • Q3

    What delimiter does a CSV file use?

    Tab

    Spacebar

    HashTag

    Comma

    30s
  • Q4

    The data in J2 is the zip code 43892-3424. What would the result be for the function =MID(J2,7,4)? 

    -342 

    -34 

    3424

    424

    30s
  • Q5

    Which function would be best to apply to a cell containing a title of a book in which the first letter of every word should be capitalized? 

    UPPER 

    LOWER 

    TITLE 

    PROPER

    30s
  • Q6

    Which of the following can you use as a delimiter within a TEXTJOIN function?Select the correct option.

    A space 

     

    A comma (,) 

     A dash (-)   

    All the above.

    30s
  • Q7

    What is the correct order of entering the four parts of an HLOOKUP function? 

    Indicate the correct sequence by adding numbers 1-4 next to the following items. 

    Users link answers
    Linking
    30s
  • Q8

    Which of the following is the correct syntax for the WORKDAY function? Select the correct option.

    =WORKDAY(start_date, days) 

    =WORKDAY(start_date, days, [holidays])

    .=WORKDAY(serial_number, [return_type])   

     =WORKDAY(serial_number, days, [holidays]).

    30s
  • Q9

    If the content of A2 is 100 and the contents of B2 is 200, what result would you getusing the formula  =IF(AND(A2>50,B2>200),"Excellent","Needs improvement")  Select all that apply.

    Excellent 

    You would get an error 

    Needs improvement

    A2>50 

    30s
  • Q10

    Instead of creating a nested IF function, what single function can you use if you have multiple criteria to meet? 

    AND 

    IFS 

    OR 

    NOT 

    30s
  • Q11

    How many conditions can you have within an AND function? 

     255

    64

    1

    8

    30s
  • Q12

    Which of the following steps isn’t required to delete an existing scenario in a workbook? 

    Indicate the incorrect step by marking it as false. 

    Select What-If Analysis. 

    Select Scenario Manager. 

    Select the scenario to delete. 

    Select Delete. 

    Select OK.

    Select Close. 

    30s
  • Q13

    Which of the following commands are available in the Scenario Manager dialogbox? Select all that apply.

    a. Merge

    Summary

    Add

    All of the above

    30s
  • Q14

    Which of the following command categories is Goal Seek part of?

     What-If Analysis

    Formula Auditing 

    Calculation Options 

    Financial functions 

    30s
  • Q15

    The Remove Duplicates tool considers each row in a data set as a :

    Users enter free text
    Type an Answer
    30s

Teachers give this quiz to your class