Search Header Logo

Excel Quiz

Authored by Makhwethe Letsoalo

Information Technology (IT)

University

Used 2+ times

Excel 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

1 min • 1 pt

What does a cell in Excel represent?

A file

A worksheet

The intersection of a row and a column

A chart

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following is a correct basic formula in Excel?

A1 + B1

SUM = A1:A5

=A1 + B1

Add(A1, B1)

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the purpose of formatting data in Excel?

To hide errors

To make data easier to read and understand

To delete cells

To calculate numbers

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which Excel function is used to find the average of a range of numbers?

=SUM()

=COUNT()

=AVERAGE()

=MAX()

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What does the IF() function do?

Finds text in a document

Filters rows

Makes a decision based on a condition

Sorts data alphabetically

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

You can have multiple sheets in one Excel workbook.

True

False — Filtering only hides rows temporarily.

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Filtering allows you to remove data permanently.

True

False — Filtering only hides rows temporarily.

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?