FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you wanted to find the average of a range of numbers, what formula would you use?
A
=AVERAGE( )
B
=SUM( )
C
AVERAGE( )
D
None of the above
Explanation: 

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: -The AVERAGE Function[1] is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. The function is used to calculate the arithmetic mean of a given set of arguments in Excel.

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.

Detailed explanation-4: -The general average formula is mathematically expressed as Average = Sum of Observations รท Total number of Observations.

There is 1 question to complete.
Previous
Next