InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How does the average function works |
|
Answer» Maja aa gya The AVERAGE function will average cells that contain numbers. Its syntax is:=AVERAGE(value1, value2,...value30).The arguments (e.g. value1) can be cell references, or values typed into the AVERAGE formula.The following AVERAGE function example uses one argument -- a reference to cells A1:A5.\tEnter the sample data on your worksheet\tIn cell A7, enter an AVERAGE formula, to average the numbers in column A: =AVERAGE(A1:A5)\t\tPress the Enter key, to complete the formula.\tThe result will be 21.83, the average of the cells that contain numbers.\tCell A1 isn\'t included in the average, because it contains text, and the empty cell C3, is ignored. |
|