LIVE Course for free

Rated by 1 million+ students
Get app now
JEE MAIN 2023
JEE MAIN 2023 TEST SERIES
NEET 2023 TEST SERIES
NEET 2023
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.7k views
in General by (50.3k points)
closed by

Let's say the contents of cells A1, A2, B1 and B2 are 0, 0, a, and 0 respectively. What will be the output of the following Microsoft Excel formula?

= COUNT (A1 : B2)


1. 4
2. 1
3. 0
4. 3

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
Correct Answer - Option 4 : 3

 COUNT function in Excel:

The COUNT function counts the number of cells that contain numbers and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.

Syntax:

COUNT(value1, [value2], ...)

Explanation:

 The contents of cells A1, A2, B1, and B2 are 0, 0, a, and 0 respectively. 

COUNT (A1: B2)= 3 because there are three numeric values in the cell.

Hence the correct answer is 3.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...