DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Average = B3-B8
|
|
|
B3:B8(AVERAGE)
|
|
|
=AVERAGE(B3:B8)
|
|
|
=B3:B8
|
Detailed explanation-1: -Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers. For example, the average of 2, 3, 3, 5, 7, and 10 is 30 divided by 6, which is 5.
Detailed explanation-2: -=AVERAGE(number1, [number2], …) The function uses the following arguments: Number1 (required argument) – This is the first number of a cell reference or a range for which we want the average. Number2 (optional argument) – They are the additional numbers, cell references or a range for which we want the average.
Detailed explanation-3: -Click a cell below the column or to the right of the row of the numbers for which you want to find the average. On the HOME tab, click the arrow next to AutoSum > Average, and then press Enter.