Count Function in excel

Count Function in excel

8th - 11th Grade

9 Qs

quiz-placeholder

Similar activities

Quiz 1

Quiz 1

11th - 12th Grade

10 Qs

Data Analysis Quiz - IGCSE

Data Analysis Quiz - IGCSE

10th - 11th Grade

13 Qs

Cell Phone Vocabulary

Cell Phone Vocabulary

9th - 12th Grade

12 Qs

Programming Lesson 3

Programming Lesson 3

6th - 8th Grade

12 Qs

Kiểu dữ liệu xâu kí tự - xử lí xâu kí tự

Kiểu dữ liệu xâu kí tự - xử lí xâu kí tự

9th - 12th Grade

14 Qs

Kiểm tra giữa kì 2 lớp 7

Kiểm tra giữa kì 2 lớp 7

9th Grade

12 Qs

Grade 9 Pre-Test AY 2023-2024

Grade 9 Pre-Test AY 2023-2024

9th Grade

10 Qs

Year 8 ICT Starters On Track Stage 2 - Topic 2: Website

Year 8 ICT Starters On Track Stage 2 - Topic 2: Website

8th Grade

10 Qs

Count Function in excel

Count Function in excel

Assessment

Quiz

Computers

8th - 11th Grade

Practice Problem

Medium

Created by

Tasmiya Shaikh

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

20 sec • 1 pt

Formula always begins with this symbol

=

*

%

@

2.

MULTIPLE SELECT QUESTION

20 sec • 1 pt

There are three types of count function

False

True

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function is used to count the cell that contains only numbers.

Count

CountA

CountIF

Cell reference

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This function counts everything(Alphanumeric data) in the cell range except empty cells.

Count

CountA

Countif

Cell Range

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This is used to count the number of cells that meet a specific criteria/condition

Count

CountA

CountIF

Cell range

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Criteria in COUNTIF() function is always written in

Double Quotes

Single quotes

semi-colom

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What will be the result if the formula =Count(A1:A6) is applied

2

3

4

5

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?