Excel Chapter 5

Excel Chapter 5

9th Grade

21 Qs

quiz-placeholder

Similar activities

Excel Functions and Features Quiz

Excel Functions and Features Quiz

9th Grade

23 Qs

Pemrograman Blokly

Pemrograman Blokly

9th Grade - University

20 Qs

Quiz Administrasi Perkantoran

Quiz Administrasi Perkantoran

9th Grade - University

20 Qs

Mastering Spreadsheet Functions Quiz

Mastering Spreadsheet Functions Quiz

9th Grade

17 Qs

Mastering Spreadsheet Functions

Mastering Spreadsheet Functions

9th Grade

17 Qs

Class 9 Viva Questions 9B mideterm

Class 9 Viva Questions 9B mideterm

9th Grade

20 Qs

LATIHAN SOAL.! PART 1

LATIHAN SOAL.! PART 1

7th Grade - University

20 Qs

Pemanasan sebelum PAS

Pemanasan sebelum PAS

7th Grade - University

20 Qs

Excel Chapter 5

Excel Chapter 5

Assessment

Quiz

Information Technology (IT)

9th Grade

Medium

Created by

Morgan Hach

Used 2+ times

FREE Resource

21 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUM function do?

finds the total of the closest four cells

totals all of the cells in the selected range

the sum function adds and subtracts cell values

counts the number of cells selected

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the COUNT function do?

counts the number of cells in a range

counts the numbers in the cell

totals all of the cells in the selected range

counts the number of cells in a range that contain a number

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the AVERAGE function do?

Finds the average of the selected numbers

Finds the average of dollar values only

Finds the average of percentages only

Finds the average of the entire worksheet

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you wanted to find the smallest number in a range of cells what function would you use?

MIN

MAX

AVERAGE

COUNTA

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you wanted to find the largest number in a range of cells what function would you use?

MIN

MAX

AVERAGE

COUNTA

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to add a range of cells and then divide by the number of cell entries, determine the mean value of all values in the range which function should you use?

MIN

MAX

AVERAGE

COUNTA

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you want to determine the number of non-blank cells in your worksheet which function should you use?

MIN

MAX

AVERAGE

COUNTA

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?