Excel Functions End-of-Chapter Quiz

What do you call a predefined formula that performs calculations by using specific values in a particular order?

Which of the following is a type of Excel function useful for analyzing a group of measurements?

What function adds all the numbers in a selected range?

What is the function called that adds a group of values and then divides the result by the number of values?

What function finds the middle value in a set of numbers?

What function in Excel determines the smallest value in a range?

What is the function that determines the largest value in a range called?

What is the command that allows you to select and lock one or more rows or columns in Excel?

What do you call a group of functions that test for specific conditions in Excel?

What are conditions specified in a logical function referred to?

What statistical function counts the number of cells in a range that meet a specified condition?

What is any value or expression that can be evaluated as true or false called?

What function uses a logical test and returns one value if true and another if false?

Excel Functions and Features

Function: A predefined formula that performs calculations using specific values in a defined order or structure.
Statistical Functions: Functions like AVERAGE that help analyze groups of measurements.
SUM Function: A predefined formula that calculates the total of all numbers within a selected range.
AVERAGE Function: Adds a group of values and divides the total by the number of values to find the mean.
MEDIAN Function: Identifies the middle value in a data set, with equal values above and below it.
MIN Function: Determines the smallest value in a specified range.
MAX Function: Identifies the largest value in a specified range.

Excel Command and Logical Functions

Freeze Panes: A command to lock one or more rows or columns in place for easier navigation.
Logical Functions: A set of functions used to test specific conditions and return true or false based on those tests.
Criteria: The specific conditions that are specified within a logical function for evaluation.
COUNTIF Function: A statistical function that counts cells within a range that meet specific criteria, requiring a range of cells and a criterion as arguments.
Logical Test: Any value or expression that can be assessed as true or false.
IF Function: A function that performs a logical test to return one value if the condition is true and another if it’s false.

Comparison Symbols

Comparison Operators: Symbols used to evaluate values within logical tests, including:
- Equal to (=)
- Greater than (>)
- Less than (<)

Test your knowledge of essential Excel functions with this end-of-chapter quiz. Dive deeper into concepts such as statistical functions and specific calculations like the SUM function. Perfect for reinforcing what you've learned in your Excel studies.