Excel 1

Excel's Conditional Formatting feature allows users to apply specific formatting based on cell values.

• True

• False

Data Validation in Excel can be used to restrict the type of data entered into a cell.

• True

• False

The BDSUMA function in Excel calculates the sum of a column based on specified conditions.

• True

• False

Nested functions are combinations of functions used to perform complex calculations within a single formula.

• True

• False

A cell reference in Excel is a value, not a pointer to another cell's location.

• True

• False

In Excel, the _____ feature can be used to hide rows based on certain criteria.

The function _____ is used to find the minimum value in a database based on a condition.

A _____ reference in Excel does not change when copied to another cell.

The _____ function calculates the average of values in a database that meet specified criteria.

In a macro, the programming language used in Excel is _____.