Which function would you use if you wanted to count the number of values, but ignore cells that have text or are empty?

A. COUNT
B. COUNTA
C. COUNTBLANK
D. COUNTVALUES


Answer: A

Computer Science & Information Technology

You might also like to view...

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results

Indicate whether the statement is true or false

Computer Science & Information Technology

The Motion Editor displays the values of a motion tween's properties ____.

A. numerically B. graphically C. both a. and b. D. neither a. nor b.

Computer Science & Information Technology

Consider the following class definitions:class bClass{public:void setX(int);void print() const;private:int x;};class dClass: public bClass{public:void setXY(int, int);void print() const;private:int y;};Which of the following statements correctly redefines the member function print of bClass?

A. void dClass::print() const { dClass:print(); cout << " " << y << endl; } B. void dClass::print() const { cout << x << " " << y << endl; } C. void bClass::print() const { cout << x << " " << y << endl; } D. void dClass::print() const { bClass::print(); cout << "y = " << y << endl; }

Computer Science & Information Technology

____________________ are the connectors located on the exterior of a system unit that are used to connect external hardware devices.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology