Worksheets5.7 Excel
Total questions: 25
Worksheet time: 13mins
If I wanted to get the first initial of the name "Stacy" in cell B4, which would be the correct function?
=LEFT(B4,1)
=LEFT("Stacy",1)
=RIGHT(B4, 1)
=RIGHT("Stacy",1)
If I wanted to get the last two digits of the grad year "2028" in cell F2, which would be the correct function?
=LEFT(F2,2)
=LEFT("2028",2)
=RIGHT(F2, 2)
=RIGHT("2028",2)
Which function would you use to get "Stacy" to be displayed as "STACY"?
UPPER
LOWER
PROPER
Which function would you use to get "Stacy" to be displayed as "stacy"?
UPPER
LOWER
PROPER
Which function would you use to get "stacy" to be displayed as "Stacy"?
UPPER
LOWER
PROPER
What function was used in Column D?
CONCATENATE
UPPER
LOWER
PROPER
What function was used in Column E?
CONCAT
UPPER
LOWER
PROPER
What function was used in Column F?
CONCATENATE
UPPER
LOWER
PROPER
What function was used in Column G?
CONCATENATE
UPPER
LOWER
PROPER
What function was used in Column H?
CONCATENATE
LEFT
RIGHT
PROPER
What function was used in Column L?
CONCATENATE
LEFT
RIGHT
PROPER
What function was used in Column M?
CONCATENATE
LEFT
RIGHT
PROPER
What function was used in Column J?
RIGHT
UPPER
LOWER
PROPER
What function was used in Column K?
LEFT
UPPER
LOWER
PROPER
What function should be used in J11?
IF
COUNTIF
SUMIF
AVERAGEIF
What function should be used in J13?
IF
COUNTIF
SUMIF
AVERAGEIF
What function should be used in J15?
IF
COUNTIF
SUMIF
AVERAGEIF
What function should be used in J17?
IF
COUNTIF
SUMIF
AVERAGEIF
What function should be used in J19?
IF
COUNTIF
SUMIF
AVERAGEIF
What function should be used in J21?
IF
COUNTIF
SUMIF
AVERAGEIF
What formula should be used in Column F?
=D2-14
=D2-E2
=SUBTRACT(D2:E2)
=27-14
What function should be used in Column G to display "Yes" if our score was greater than or equal to 35 and display "No" if not?
IF
COUNTIF
YES/NO
SUMIF
What function should be used in Column H to display "Yes" if their score was zero and display "No" if not?
IF(E2=0,"Yes","No")
IF(E2 equals 0,"Yes","No")
IF(E2 is equal to 0, display Yes, if not, display No)
IF(E2=0) ["Yes"] ["No"]
What is the shortcut key to make a cell absolute?
F4
F2
$$
F5
Which of the following formulas contains an absolute cell reference to G2?
=D2*G2
=D2*$G$2
=D2*ABSOLUTE(G2)
=D2*#G#2
