Excel is an important tool when working with data - whether it is for business, marketing, research, or data analysis purposes. It performs calculations, summarizes data, performs visualization.
Data analysis is the science of analyzing raw data, insights to support decision making that's why excel is an important tool.
A cell is named using column and row for example cell named E2, its column is E and 2 is the row
Basic Excel functions to be used include SUM, AVERAGE, COUNT, MAX and MIN .
SUM
Is used to get the totals
in the particular image, we are finding the total of A2 and B2 in cell and the total in cell C2. Since SUM is a function you use equal sign =. You write the function =SUM(excel displays automatically) in a cell C2(can be in any cell to get your results) then the name of the first cell which is A2 full colon name of the second cell which is B2, close the brackets then enter.
AVERAGE
Finds the totals then divides it with the count of numbers
here we were finding the average from cell A2 to cell A6 whereby you write the function =Average write the range (A2:A6) close the brackets. you will find the total as 37.6
the function average added all values from a2 to a6 then divided with the total count that is 5
COUNT
Displays the count entries
write the function count, cell range which is from cell A2 to A6 close the bracket then ENTER. it displays 5 as the total count of values.
MAX
Displays the highest or lowest value
From the image above the max value(highest value) from cell A2 to A6 is 53 that is displayed on cell A7.
It also applies to minimum only that you use the function =MIN
CONCLUSION
_MS Excel is a good tool that aids in decision making. Understanding the basics is the foundation for advanced EXCEL. _
Top comments (0)