ASET11. Advanced Office Tools

What is the primary purpose of the SUMIF function?

• To count the total number of cells in a range.

• To add all numbers in a specified range of cells.

• To conditionally add numbers based on a specific criterion.

• To find the average of a range of numbers.

Which function is used to calculate the arithmetic mean of a range of numbers?

• COUNT

• SUM

• AVERAGE

• IF

The AND function returns a TRUE value only if:

• At least one of its conditions is true.

• All of its conditions are true.

• None of its conditions are true.

• The logical test is false.

What does the COUNT function do?

• It counts the number of cells in a range that contain numerical data.

• It counts cells that satisfy a given criterion.

• It counts the number of empty cells in a range.

• It counts the total number of cells in a range, including text and numbers.

Which function is ideal for searching for a value in the first column of a data table and returning a corresponding value from a specified column?

• HLOOKUP

• VLOOKUP

• SUMIF

• AVERAGEIF

The COUNTIF function is used to:

• Count all non-empty cells in a range.

• Count cells in a specified range that satisfy a given criterion.

• Count cells with formulas.

• Count cells that contain text.

Which advanced spreadsheet tool is used to condense thousands of rows into meaningful summaries with drag-and-drop simplicity?

• Conditional Formatting

• Data Validation

• Pivot Table

• Text to Columns

To prevent incorrect data input by creating dropdowns or setting value ranges, you would use which technique?

• Conditional Formatting

• Cell Protection

• Data Validation

• Named Ranges

What is the purpose of the IFERROR function?

• To highlight cells with errors.

• To display a custom message instead of a calculation error.

• To automatically correct formula errors.

• To prevent users from entering text in a numerical cell.

What is a key benefit of using named ranges in a spreadsheet?

• They allow for faster data entry.

• They simplify formula management and improve readability.

• They automatically update data from external sources.

• They protect cells from accidental changes.