Excel Unit B demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.
What will be an ideal response?
After the Excel user selects a range of cells, the COUNT function returns the number of cells in the range that contains any numeric data such as numbers, dates, and formulas. The COUNTA function returns the number of cells in the range that contains any kind of data, including labels and blank spaces.
You might also like to view...
____________ are spaces that appear at the beginning of a string.
a. Leading spaces b. Empty spaces c. Indentations d. Tabbed spaces
The default left and right margins in a Word 2016 document are 1 inch; default top and bottom margins are also 1 inch
Indicate whether the statement is true or false
Word processing software is used to:
A) format documents B) edit documents C) create documents D) all of the above
What is the purpose of adding an input mask to a field?
What will be an ideal response?