Search Header Logo

Excel Basics Quiz

Authored by Khaled Boukesra

Computers

University

Used 6+ times

Excel Basics Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

50 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is the correct file extension for an Excel workbook?

.docx

.xlsx

.pptx

.pdf

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following shortcuts is used to create a new workbook in Excel?

Ctrl + N

Ctrl + S

Ctrl + P

Ctrl + O

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to find the maximum value in a range?

MIN()

MAX()

AVERAGE()

COUNT()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you merge cells in Excel?

Format > Merge

Home > Format > Merge

Home > Merge & Center

Insert > Merge Cells

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following functions adds the values in a specified range?

ADD()

SUM()

TOTAL()

COUNT()

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you freeze the top row in an Excel worksheet?

View > Freeze Panes > Freeze Top Row

Home > Freeze Top Row

Data > Freeze Top Row

Insert > Freeze Top Row

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which chart type is best suited for showing proportions in Excel?

Line Chart

Bar Chart

Pie Chart

Scatter Plot

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?