Search Header Logo

Excel Formulas and Functions Quiz

Authored by SHIVANI PRIYA

Computers

University

Used 1+ times

Excel Formulas and Functions Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?