Quiz Excel

Feel free to use or edit a copy

includes Teacher and Student dashboards

### Measure skillsfrom any curriculum

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

• 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!

20 questions
• 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.

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

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