Search Header Logo

Excel Basics Quiz

Authored by Anna Jobson

Computers

11th Grade

16 Questions

Used 1+ 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

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct formula to add the values in cells A1 and B1 in Microsoft Excel?

=SUM(A1 : B1)

`=A1 + B1`

`=ADD(A1, B1)`

`=A1 & B1`

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the average of a range of cells in Excel?

`=SUM()`

`=AVERAGE()`

`=MEAN()`

`=MEDIAN()`

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you format a cell to display numbers as currency in Excel?

Right-click the cell, select "Format Cells," and choose "Currency"

Type the currency symbol before the number

Use the `=CURRENCY()` function

Use the `=FORMAT()` function

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a valid Excel file type?

`.docx`

`.xlsx`

`.pptx`

`.txt`

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the maximum number of rows available in an Excel worksheet?

65,536

1,048,576

104,857

10,485,760

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to count the number of cells that contain numbers in a range?

`=COUNT()`

`=COUNTA()`

`=COUNTIF()`

`=COUNTBLANK()`

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you create a bar chart in Excel?

Insert > Chart > Bar Chart

Data > Bar Chart

Insert > Bar Chart

Format > Bar 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?