Excel Functions and Features

What is a range in Excel?

• A range in Excel refers to a chart type.

• A range in Excel is a selection of two or more cells.

• A range in Excel is a type of formula.

• A range in Excel is a single cell.

How do you write the syntax for the IF function?

• IF(value_if_true, condition, value_if_false)

• IF(condition, value_if_true, value_if_false)

• IF(condition: value_if_true, value_if_false)

• IF(condition; value_if_true; value_if_false)

What does the AND function do in Excel?

• The AND function returns TRUE if any argument is TRUE.

• The AND function calculates the sum of all arguments.

• The AND function checks if at least one argument is FALSE.

• The AND function returns TRUE if all arguments are TRUE, otherwise FALSE.

What is the purpose of the OR function?

• To evaluate multiple conditions and return TRUE if at least one condition is TRUE.

• To evaluate a single condition and return TRUE or FALSE.

• To return FALSE if all conditions are FALSE.

• To combine multiple conditions into a single TRUE or FALSE value.

What is the syntax for the SUBTOTAL function?

• SUBTOTAL(function_num, ref1)

• SUBTOTAL(ref1, ref2, function_num)

• SUBTOTAL(ref1, function_num, [ref2], ...)

• SUBTOTAL(function_num, ref1, [ref2], ...)

How do you create a table in Excel?

• Select data range, go to 'Insert' tab, click 'Table', confirm range, click 'OK'.

• Select data range, go to 'File' tab, click 'New', confirm range, click 'Save'.

• Highlight cells, right-click, choose 'Format Cells', select 'Table', click 'Apply'.

• Select data range, go to 'Home' tab, click 'Copy', paste into a new sheet.

What is the purpose of conditional formatting?

• The purpose of conditional formatting is to enhance data visualization by applying formatting styles based on cell values or conditions.

• To sort data in ascending order.

• To create a new spreadsheet from existing data.

• To calculate the average of a data set.

How does the NOT function operate in Excel?

• The NOT function adds a value to its argument.

• The NOT function multiplies its argument by -1.

• The NOT function in Excel reverses the boolean value of its argument.

• The NOT function checks if a cell is empty.

What does the COUNTIF function do in Excel?

• Counts the number of cells that meet a specified condition.

• Counts all non-empty cells in a range.

• Counts the total number of cells in a range.

• Counts the number of unique values in a range.