Search Header Logo

Excel 2016 Basics Quiz

Authored by Emad Mohammad Alhindawi

Other

8th Grade

Used 4+ times

Excel 2016 Basics Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the default file extension for an Excel 2016 workbook?

.docx

.xlsx

.xls

.pdf

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used to start a formula in Excel?

=

+

@

#

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function =SUM(A1:A5) do?

Finds the average of the cells

Multiplies all the values

Adds the values in cells A1 through A5

Counts the cells

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which feature allows you to apply the same formatting to multiple cells?

Format Painter

Conditional Formatting

Filter

Freeze Panes

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which shortcut key is used to save a workbook?

Ctrl + C

Ctrl + S

Ctrl + V

Ctrl + P

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function =AVERAGE(B1:B10) return?

The sum of all numbers

The maximum value

The mean of the numbers

The number of cells

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of chart is best for showing percentages?

Bar Chart

Line Chart

Pie Chart

Column Chart

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?