Explain the difference between the COUNT and COUNTA functions.

What will be an ideal response?


The COUNT function counts the number of cells in a range that contain a numeric value. The COUNTA function counts the number of cells in a range that are not blank.

Computer Science & Information Technology

You might also like to view...

Before a high-level language program can be executed, it must first be translated into the target computer's machine language. The program that does this translation is called the

a. compiler b. operating system c. linker d. loader

Computer Science & Information Technology

A programmer indicates a job’s class by coding a __________ parameter on an OS/JCL JOB statement.

a. positional b. CLASS c. PRIORITY d. none of the above

Computer Science & Information Technology

A _________ block executes regardless of whether an exception occurs.

(a) final (b) finally (c) catch (d) none of the above

Computer Science & Information Technology

On Google+, photos larger than ________ pixels will be automatically resized when uploaded

A) 256 x 256 B) 512 x 512 C) 1024 x 1024 D) 2048 × 2048

Computer Science & Information Technology