Excel Formulas and Functions Quiz

What is the purpose of a formula in Microsoft Excel?

• To import data from external sources

• To create charts and graphs

• To perform calculations on values in a range of cells

• To format cells

What does the SUM() function do in Excel?

• Multiplies the values in a range of cells

• Returns the total of the selected range of cell values

• Finds the average of the selected range of cell values

• Subtracts the values in a range of cells

What does the AVERAGE() function do in Excel?

• Finds the average of the selected range of cell values

• Counts the total number of cells in a range

• Rounds a number up to its nearest multiple of significance

• Returns the total of the selected range of cell values

What does the COUNT() function do in Excel?

• Finds the average of the selected range of cell values

• Counts the total number of cells in a range

• Returns the remainder when a number is divided by a divisor

• Converts any text string to uppercase

What does the MOD() function do in Excel?

• Converts any text string to uppercase

• Calculates the average of the selected range of cell values

• Returns the remainder when a number is divided by a divisor

• Rounds a number up to its nearest multiple of significance

What does the SUBSTITUTE() function do in Excel?

• Converts any text string to lowercase

• Gives the current system date and time

• Returns the total number of characters in a string

• Replaces the existing text with a new text in a text string

What does the VLOOKUP() function do in Excel?

• Counts the total number of cells in a range

• Looks for a particular value in the leftmost column of a table and returns a value in the same row from a column you specify

• Calculates the average of the selected range of cell values

• Rounds a number up to its nearest multiple of significance

What does the NOW() function do in Excel?

• Returns the current system date

• Gives the day of the month

• Converts hours, minutes, seconds given as numbers to an Excel serial number

• Gives the current system date and time

What does the HOUR() function do in Excel?

• Generates the hour from a time value as a number from 0 to 23

• Converts any text string to uppercase

• Returns the second from a time value as a number from 0 to 59

• Returns the month, a number from 1 to 12

What does the DATEDIF() function do in Excel?

• Counts the total number of cells in a range

• Rounds a number up to its nearest multiple of significance

• Provides the difference between two dates in terms of years, months, or days

• Returns the total of the selected range of cell values