Player 1
What does Ctrl + Y do in Microsoft Office apps?
a) Undo
b) Cut
c) Redo
d) Find
c) Redo
You can use =VLOOKUP to search both vertically and horizontally.
True or False
False
The function =COUNTA() counts the numeric cells only
True or False
false
<h1> is the tag for the largest heading in HTML. True or False
True
On the keyboard what is after Letter D
Letter F
On the keyboard what is after Letter H
J
On the keyboard what is before Letter R
E
On the keyboard what is before Letter N
B
What is the HTML tag to make a text bold?
a) <bold>
b) <strong>
c) <b>
d) <font-bold>
c) <b>
Which HTML tag creates a numbered list?
a) <ul>
b) <li>
c) <list>
d) <ol>
d) <ol>
Which HTML tag is used to insert a line break?
a) <br>
b) <br />
c) <lb>
d) <line>
a) <br>
The <p> tag is used to represent a page in HTML.
True or False
false
paragraph
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")
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")
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")
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")