Search Header Logo

Advance Excel Function Quiz

Authored by Rakesh undefined

Computers

Professional Development

35 Questions

Used 1+ times

Advance Excel Function Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to find the highest value in a range?

MIN()

MAX()

AVERAGE()

COUNT()

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the VLOOKUP function do?

Vertically searches for a value in the first column of a range

Horizontally searches for a value in a row

Counts the number of values in a column

Sorts data in ascending order

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is NOT a valid Excel data type?

Number

Text

Boolean

Image

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the shortcut key to open the ‘Format Cells’ dialog box?

Ctrl + F

Ctrl + 1

Ctrl + Shift + F

Alt + Enter

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the IFERROR function?

Returns 'Error' when a function fails

Displays a custom message when an error occurs

Shows the error code of a failed function

Fixes errors automatically

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to combine text from multiple cells?

CONCATENATE()

CONCAT()

JOIN()

MERGE()

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the $ symbol in a cell reference indicate?

It makes the reference an absolute reference

It converts the value to currency format

It multiplies the value by 100

It locks only the row reference

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?