Excel Functions Quiz

Excel Functions Quiz

10th Grade

9 Qs

quiz-placeholder

Similar activities

Bài 8- CĐ F-TH10

Bài 8- CĐ F-TH10

9th - 12th Grade

10 Qs

Operasi Dasar Komputer, Software dan Hardware

Operasi Dasar Komputer, Software dan Hardware

10th Grade

10 Qs

Anatomy of a Robot

Anatomy of a Robot

9th - 12th Grade

6 Qs

Microcontroller 1

Microcontroller 1

1st - 12th Grade

10 Qs

Programming Constructs

Programming Constructs

5th - 11th Grade

10 Qs

Strings in Swift

Strings in Swift

9th - 12th Grade

12 Qs

Excel Overview

Excel Overview

9th - 12th Grade

10 Qs

OCR GCSE CS - 2.1 ERL sorts and searches

OCR GCSE CS - 2.1 ERL sorts and searches

10th - 11th Grade

9 Qs

Excel Functions Quiz

Excel Functions Quiz

Assessment

Quiz

Computers

10th Grade

Practice Problem

Hard

Created by

W. Gamal

Used 3+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the FILTER function do?

Filters data based on conditions

Counts numeric values

Calculates sums

Averages data

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which cells are counted by COUNTA?

Numeric cells

Blank cells

Non-empty cells

Cells matching criteria

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the syntax of the COUNTIF function?

=COUNTIF(range, criteria)

=COUNTIF(criteria, range)

=FILTER(range, criteria)

=COUNTA(range)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does nesting FILTER in COUNT accomplish?

Finds average values

Counts only filtered results

Counts blank cells

Sorts the dataset

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the benefit of absolute references?

They make formulas adaptable for multiple uses.

They avoid formula repetition errors.

They allow consistent range selection.

All of the above.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does =COUNT(range) do?

Counts numeric cells only

Counts all non-empty cells

Filters the range

Returns a "Yes" count

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Why use COUNTA instead of COUNT?

To count only blank cells

To count text and numeric values

To simplify filtering

To sort a dataset

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What's the result of the formula =FILTER(A1:A10, B1:B10="Pass")?

"Pass" counts in B1:B10

Numeric cell count in A1:A10

Only values in A1:A10 where B1:B10 is "Pass"

All non-empty cells in A1:A10

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What's the outcome of =COUNTA(FILTER(range, range>50))?

Counts blank cells

Counts numeric cells greater than 50

Filters all values

Counts non-empty cells in filtered results

Discover more resources for Computers