New Functions in Excel 2019

How many new functions were introduced in Excel 2019?

• Six

• Five

• Seven

• Ten

What does the CONCAT function do in Excel 2019?

• Finds the maximum value based on criteria

• Joins a range of values into a single value

• Finds the minimum value based on criteria

• Evaluates an expression and returns a result

What is the purpose of the TEXTJOIN function?

• To return a letter grade based on a score

• To join a range of values into a single value

• To calculate a maximum based on one or more criteria

• To join data in a range and separate it by a delimiter

What does the MAXIFS function allow you to do?

• Find the maximum value in a range based on given criteria

• Join data with a delimiter

• Evaluate an expression and return a result

• Join a range of values into a single value

What is the difference between MAXIFS and MINIFS functions?

• There is no difference

• MAXIFS joins data, MINIFS separates data

• MAXIFS finds the maximum value, MINIFS finds the minimum

• MAXIFS evaluates expressions, MINIFS does not

How does the IFS function improve upon nested IF functions?

• By separating data with a delimiter

• By allowing multiple criteria to be tested without nesting

• By finding maximum values

• By joining data ranges

What does the SWITCH function do?

• Calculates a maximum based on criteria

• Finds the minimum value based on criteria

• Evaluates an expression and returns a result based on that expression

• Joins a range of values with a delimiter

In the example given, what was used as a delimiter in the TEXTJOIN function?

• A comma followed by a space

• A space

• A semicolon

• A dash

What criteria were used in the MAXIFS function example?

• ID and category

• Date and day

• Color and size

• Score and grade

What default value does the SWITCH function use if no cases match?

• Blank

• Error

• 0

• The last input value