Formulas & Functions Part 2

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)

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

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