Excel Module 2 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...
Configure NAT inside on the Customer router using the previously defined overload source pool of addresses (Step 1). You will need to reference your source pool of addresses defined by the access list 100. List the router prompt and the command used to complete this task.
What will be an ideal response?
A network is also known as a ____.
A. weighted graph B. restricted graph C. mesh D. grid
The ________ color is what is visible behind the value in a cell.
Fill in the blank(s) with the appropriate word(s).
Which of the following is Photoshop's unique filename extension?
A. .pss B. .psh C. .psd D. .psp