COUNTIF

Presentation

•

Computers, Instructional Technology

•

8th Grade

•

Practice Problem

•

Easy

Adrienne Patt

Used 43+ times

FREE Resource

8 Slides • 7 Questions

COUNTIF

by Adrienne Patt

Multiple Choice

The Microsoft Excel COUNTIF function: ____________

counts the number of cells in a range, that meets a given criteria.

Counts ONLY whole numbers in a given range.

Counts any cell that is blank in a given range.

Counts cells that contain text only.

Multiple Choice

The COUNTIF function is categorized as a ___________ function.

Statistical

Easy

Mathematical

Scientific

Multiple Choice

Which of the following is the correct SYNTAX of the COUNTIF FUNCTION.

=COUNTBLANK(range)

=COUNTA(range)

=COUNT(range)

=COUNTIF( range, criteria )

Multiple Choice

The COUNTIF function returns a numerical value.

True

False

Multiple Choice

Look at the picture to the left, which of the following is the correct formula that can be used in order for us to find out how many times the number 2000 is repeated in that set of data.

=COUNTIF(A2:A7, "YEAR 2000")

=COUNTIF(A2:A7)

=COUNTIF(A2:A7, D2)

=COUNTIF(2000)

Multiple Choice

If I wanted to find how many numbers are greater than 55, what would be the correct formula you would write?

=COUNTIF(B2:B5,"<>" "55")

=COUNTIF(B2:B5,">55")

=COUNTIF(B2:B5,"< 55")

=COUNTIF(B2:B5,"=55")

Multiple Choice

If in any case I wanted to count the number of words that consist of four characters, which of the following would be the correct formula?

=COUNTIF(A2:A5,"@@@@")

=COUNTIF(A2:A5,"&&&&")

=COUNTIF(A2:A5,"****")

=COUNTIF(A2:A5,"????")

COUNTIF

by Adrienne Patt

Show answer

Auto Play

Slide 1 / 15

SLIDE

Similar Resources on Wayground

10 questions

STAAR Success Day 11

Presentation

•

8th Grade

13 questions

Lesson 1: Graphing and Writing Inequalities

Presentation

•

8th - 9th Grade

11 questions

Rate of Change - Linear Functions

Presentation

•

8th Grade

12 questions

Обобщающее повторение

Presentation

•

7th Grade

13 questions

Latihan 2

Presentation

•

8th Grade

10 questions

100 year War

Presentation

•

8th Grade

13 questions

Latin America

Presentation

•

9th Grade

11 questions

Bar Graphs

Presentation

•

8th Grade

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Discover more resources for Computers

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade