Search Header Logo

Excel Essentials Training

Authored by JIN NG

Other

University

Excel Essentials Training
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following is a spreadsheet software?

Word

PowerPoint

Excel

Paint

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which symbol is used to begin a formula in Excel?

=

#

\$

@

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which Excel function is used to add numbers?

=MIN()

=AVG()

=ADD()

=SUM()

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What does “cell” refer to in Excel?

A type of font

A block in a spreadsheet where you enter data

A storage file

A button on the ribbon

5.

MULTIPLE SELECT QUESTION

20 sec • 1 pt

Which Excel formula correctly calculates the average of cells A1 to A5?

=AVERAGE(A1\:A5)

=SUM(A1\:A5)/5

=AVG(A1\:A5)

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which function is used to count only numeric values in a range?

=COUNTA()

=COUNTIF()

=COUNT()

=COUNTBLANK()

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What feature in Excel helps create interactive dashboards?

Conditional Formatting

Data Validation

Pivot Tables

SmartArt

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?