|
Excel: A Question of Balance
What Do You
See? You can use the Function Arguments form to "fill in
the blanks" and write your equation. Just as the
SUM, AVERAGE and COUNT Functions use a range of cells, you need to
select the data for this equation, too. Try it:
Edit the Function Arguments Your cursor
should be in Value1. .
Select
Value1: Reach over to the spreadsheet that is behind the Function
Arguments form and highlight (select) Cells A2:A4. What Do You
See Now?
The correct
equation is:
=COUNTA(A2:A4)
|
||||
|
| ||||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.2. Summarize data using a formula 3.2.1. Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX