WorksheetsFormulas & Functions Part 2
Total questions: 11
Worksheet time: 7mins
Which of these describes what the SUM Function in Excel does?
Count numbers
Add numbers together
Get the largest value
Count the cells that are blank
Which of the following functions can you use to count numbers?
COUNTA
COUNTIF
COUNT
COUNTBLANK
If you need to return a specific number of characters from the start of a text string, which function will you use?
CONCATENATE
MIDDLE
LEFT
RIGHT
Looking at the data in the picture, which function can be used to find the youngest and oldest athlete?
MIN & AVERAGE
MAX & AVERAGE
MIN & MAX
COUNTA & MAX
Which function concatenates a list or range of text using a delimiter?
CONCATENATE
JOINTEXT
IF
SUMIF
The following formula is missing something, can you type what's missing
=TEXTJOIN( ; ,TRUE , B1:B7)
(a)
The function TEXTJOIN has a delimiter in its syntax, select the appropiate delimiter from the options below.
Semicolon
;
Question Mark
?
Exclamation Mark
!
All 3 of them
; ? !
Looking at the picture, please type the correct name of the table
(a)
When naming Ranges or Tables, you can leave spaces inbetween the name?
TRUE
FALSE
Which function can you use to fill data from one table to another?
SUMIF
COUNTIF
VLOOKUP
IF
Looking at the data in the table, if you were asked to only add the average cost of all the cars with a V12 engine, which function would you use?
COUNTIF
SUMIF
IF
VLOOKUP
