ITDAB C4 17/5

What is the syntax for the IF function in Excel?

• =IF(logical_test, value_if_true, value_if_true)

• =IF(logical_test: value_if_false, value_if_true)

• =IF(logical_test; value_if_true; value_if_nil)

• =IF(logical_test, value_if_true, value_if_false)

Which function is used to find the difference in number of days/months/years between 2 dates in Excel?

• IF Function

• OR Function

• AND Function

• DATEDIF Function

What does the ISERROR function in Excel check for?

• Whether the value is an error

• Whether the value is a number

• Whether the value is a text

• Whether the value is blank

What does the NOT function in Excel do?

• Checks whether the value is blank

• Used to invert the results from TRUE to FALSE or vice versa

• Checks whether the value is a number

• Checks whether the value is an error

Which logical operator in Excel is used when there are more than 1 condition and the result will be TRUE if all stated conditions are fulfilled?

• AND

• OR

• NOT

• IS

What is the purpose of the VLOOKUP function in Excel?

• To find the maximum value in a range of cells

• To search for a value in the first column of a table array and return a value in the same row from another column

• To calculate the average of a range of cells

• To count the number of cells that contain numbers

Which Excel function is used to round a number up to the nearest integer?

• ROUNDUP

• ROUNDDOWN

• ROUND

• CEILING

When would you use the CONCATENATE function in Excel?

• To split text into separate cells

• To combine text from two or more cells into one cell

• To find the average of a range of cells

• To count the number of cells that contain text

Which logical operator in Excel is used when the result will be TRUE if any of the stated conditions are fulfilled?

• AND

• OR

• NOT

• IS

When would you use the TRIM function in Excel?

• To split text into separate cells

• To remove extra spaces from text, except for single spaces between words

• To find the average of a range of cells

• To count the number of cells that contain text