Level 4

Player 1

100

What does Ctrl + Y do in Microsoft Office apps?
a) Undo
b) Cut
c) Redo
d) Find

c) Redo

200

On the keyboard what is after Letter D

Letter F

300

What is the HTML tag to make a text bold?
a) <bold>
b) <strong>
c) <b>
d) <font-bold>

c) <b>

400

Check if A1 is greater than 10, return "Yes" or "No":
a) =IF(A1>10, 'Yes', 'No')
b) =IF(A1>10, "Yes", "No")
c) =IF(A1>10, 'Yes';'No')
d) IF(A1>10, "Yes"; "No")

b) =IF(A1>10, "Yes", "No")

Player 2

100

You can use =VLOOKUP to search both vertically and horizontally.

True or False

False 

200

On the keyboard what is after Letter H

J

300

Which HTML tag creates a numbered list?
a) <ul>
b) <li>
c) <list>
d) <ol>

d) <ol>

400

Count cells greater than 50 in B1:B20:
a) =COUNTIF(B1:B20, '>50')
b) COUNTIF(B1:B20, ">50")
c) =COUNTIF(B1:B20 ">50")
d) =COUNTIF(B1:B20, ">50")

=COUNTIF(B1:B20, ">50")

Player 3

100

The function =COUNTA() counts the numeric cells only

True or False

false

200

On the keyboard what is before Letter R

E

300

Which HTML tag is used to insert a line break?
a) <br>
b) <br />
c) <lb>
d) <line>

a) <br>

400

Count how many times the word "Yes" appears in range E1:E25:
a) =COUNTIF(E1:E25, 'Yes')
b) COUNTIF(E1:E25, Yes)
c) =COUNTIF(E1;E25, "Yes")
d) =COUNTIF(E1:E25, "Yes")

d) =COUNTIF(E1:E25, "Yes")

Player 4

100

<h1> is the tag for the largest heading in HTML. True or False

True

200

On the keyboard what is before Letter N

B

300

The <p> tag is used to represent a page in HTML.

True or False

false 

paragraph

400

Count cells in O1:O30 with values less than 5:
a) =COUNTIF(O1:O30 "<5")
b) COUNTIF(O1:O30 "<5")
c) =COUNTIF(O1:O30 '<5')
d) =COUNTIF(O1:O30, "<5")

d) =COUNTIF(O1:O30, "<5")