5 Essential Methods to Calculate Average Numbers in Microsoft Excel.
1. Firstly, I plus 4 subjects one by one and divide by 4.
Formula: =(E3+D3+C3+B3)/4
2. Secondly, I use the Quick Analysis tool.
Press the shortcut key Ctrl+Q
3. Thirdly, I use the shortcut key of the average.
Press the shortcut key Alt+H+U+A
4. Fourthly, I use the AutoSum tool.
Click AutoSum then Click Average.
5. Lastly, I use the AVERAGE function.
What is the AVERAGE Function in Microsoft Excel?
The AVERAGE function in Excel calculates the arithmetic mean of the supplied values. Such values can be numbers, percentages, or times. In the mean (or average), the sum of all the items is divided by the number of items on the list.
Syntax:
AVERAGE(number1, [number2], ...)
number1 (Required): The first number, cell reference, or range for which you want the average.
number2, ... (Optional): Additional numbers, cell references, or ranges for which you want the average, up to a maximum of 255.
Formula: =AVERAGE(B3:E3)
The AVERAGE function is a good method to calculate the average numbers. When you calculate the average, you should use the AVERAGE function.
Thank you for watching my video. I hope to see you again in my next video.
If you have any questions please write in the comment below.
♥️♥️📖📖♥️♥️
------------------------------------------------
#msexcel #pivottable #office #advanceexcel #excelbasic #excelfilter #excelhindi #excelinterview #exceltips #excelhindi #exceltrick #exceltipsinhindi #exceltutorial #statistics #share #convert #long #longvideo #learning #learnonline #youtube #youtubevideo #students #shareknowledge #learnexcel #learnexcelfree #learnexcelonline #courseonline #studyonyoutube #average #microsoftoffice #excelknowledge
@RachanaChiv
------------------------------------------------
Prepared by: Dr. Rachana Chiv
Негізгі бет 5 Essential Methods to Calculate Average Numbers in Excel | Excel Basic
Пікірлер