Excel Functions and Features Quiz

What does an Absolute Reference in Excel refer to?

• A) A reference to the absolute value of a cell

• B) A function that provides the absolute difference between two cells

• C) Cell references that remain constant throughout spreadsheet shape or size changes

• D) A tool that provides the absolute position of a cell

What is the purpose of the AND Function in Excel?

• A) To add multiple numbers together

• B) To check for multiple conditions and return true if all conditions are met

• C) To combine text from different cells

• D) To calculate the average of a range of cells

What does Autofill in Excel do?

• A) It creates a new cell style

• B) It automatically fills in cells with patterned values

• C) It counts the number of cells in a range

• D) It formats data based on certain conditions

What does the AVERAGEIFS Function in Excel calculate?

• A) The sum of all numbers in a range of cells

• B) The average of all numbers in a range of cells, based on multiple user-specified criteria

• C) The count of all cells that meet a certain condition

• D) The average interest rate of a financial function

What is the purpose of Conditional Formatting in Excel?

• A) To fill cells with patterned values

• B) To format a cell to a user-defined format

• C) To format data a certain way if it meets certain user-defined conditions

• D) To define the format of data entered into cells

What are Cube Functions used for in Excel?

• A) To calculate the cube of a number

• B) To create three-dimensional charts

• C) To access data from an analysis services data source without using a PivotTable

• D) To format a worksheet to look like a cube

What is the purpose of Data Validation in Excel?

• A) To validate the correctness of formulas

• B) To check the spelling in cells

• C) To define the format of data entered into cells

• D) To create a validation rule for a range of cells

What does a Dual-Axis Chart in Excel illustrate?

• A) The relationship between two different variables

• B) The dual values of a single variable

• C) The axis values of a three-dimensional chart

• D) The comparison between two sets of data validation rules

What is the Evaluate Formula tool in Excel used for?

• A) To calculate the sum of a series of numbers

• B) To establish a pattern of data across a row or column

• C) To see the different parts of a nested formula evaluated in the order the formula is calculated

• D) To execute a variety of financial calculations

What is the Fill Series option in Excel designed to do?

• A) To fill cells with a color series

• B) To create a series of charts

• C) To establish a pattern of data and use it to autofill across a row or column

• D) To format a worksheet to look like a series of forms