Excel Functions and Features Quiz

Excel Functions and Features Quiz

University

15 Qs

quiz-placeholder

Similar activities

Fundamentos Web

Fundamentos Web

University

15 Qs

AB1401 Case Study: Facebook

AB1401 Case Study: Facebook

University

12 Qs

¿Cuánto sabes sobre la tecnología que cambia al mundo?

¿Cuánto sabes sobre la tecnología que cambia al mundo?

University

10 Qs

Práctica Informática Básica

Práctica Informática Básica

University

16 Qs

Examen Tema 1 - Simulación

Examen Tema 1 - Simulación

University

11 Qs

Constrain Satisfaction Problem (CSP)

Constrain Satisfaction Problem (CSP)

University

10 Qs

ICT Unit-2

ICT Unit-2

University

20 Qs

Kuis Pemrograman Dasar

Kuis Pemrograman Dasar

University

20 Qs

Excel Functions and Features Quiz

Excel Functions and Features Quiz

Assessment

Quiz

Computers

University

Practice Problem

Easy

Created by

David Remon

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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?