Search Header Logo

DREW M Excel Basics Quiz for Grade 10

Authored by JK CoolKid

Computers

10th Grade

Used 1+ times

DREW M Excel Basics Quiz for Grade 10
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel formula would you use to add the values in cells A1 through A5?

=AVERAGE(A1:A5)

=SUM(A1:A5)

=MIN(A1:A5)

=MAX(A1:A5)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the result of the formula =AVERAGE(4, 8, 12)?

6

8

12

24

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which symbol is used in Excel to make a cell reference absolute?

$

#

&

%

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to sort a list of numbers in column B from smallest to largest, which sorting order should you choose?

Descending

Ascending

Random

Custom

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function would you use to find the smallest value in a range of cells?

=MAX()

=MIN()

=SUM()

=AVERAGE()

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Excel function would you use to calculate the average of the values in cells D1 to D10?

=SUM(D1:D10)

=AVERAGE(D1:D10)

=MIN(D1:D10)

=MAX(D1:D10)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Relative reference

Absolute reference

Mixed reference

No reference

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?