Search Header Logo

Excel Functions and Features Quiz

Authored by David Remon

Computers

University

Used 1+ times

Excel Functions and Features Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following functions returns the largest number in a range of cells?

MIN

MAX

SUM

AVERAGE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the AutoFill feature do in Excel?

Automatically corrects spelling errors

Creates formulas based on sample data

Fills a series of values based on a pattern

Automatically adjusts cell formats

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to count only the cells that meet a specific criterion?

SUM

AVERAGEIF

COUNTIF

MAXIF

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Flash Fill is used to:

Apply conditional formatting

Automatically fill cells based on detected patterns

Sort and filter data

Add data validation rules

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a logical function that checks if multiple conditions are true?

OR

AND

NOT

IF

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In Excel, the VLOOKUP function:

Searches for a value in a row

Searches for a value in a column

Searches for a value in a table and returns a match from the same column

Creates an array

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What happens if you apply data validation to a cell in Excel?

It formats the cell with a specific style

It restricts the data that can be entered

It highlights data based on conditions

It creates an error message in the cell

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?