Hey friends here you can learn Excel and practice online free of cost. If you like this content then don’t forget to share it with your friends.
Basic – Maths (=,+,-,/,*)
How to perform basic maths functions in Excel like how to add two numbers, how to subtract two numbers, Multiplication, and division.
Sum
Hey friends in this article we will learn Excel SUM function. Using the Excel sum function you can add numbers easily without using plus sign.
You can add numbers using the sum function in two ways so let’s see:1. Type =SUM(1,2) this will give you answer “3”2. Type =SUM(A2:A3) this will give sum of numbers in cell A2 and A3
Sum – Syntax
The syntax of the sum function is very easy. The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.
SUM(number1,[number2],…)
For example :=SUM (B2:B10) Adds the values in cells A2:10.=SUM(A2:A10, B2:B10) Adds the values in cells A2:10, as well as cells B2:B10.
Sum Example 1- Excel Practice online
Now let’s practice with some interesting examples. The Examples are for only learning purposes. Please do not think it as a real
Sum Example 2- Excel Practice online
Let’s do another exercise
guys, I hope you liked this content if you find it useful share it with others also. Also, visit our youtube channel to learn more via youtube shorts.
Max
Returns the largest value in a set of values. It ignores logical values and text.
Syntax: =MAX(number1, [number2], …)
With the help of the same example, we can calculate the maximum number of mobiles sold in different years. To do that place the cursor where you want to calculate the maximum value press =Max press Tab key select the range and again press the Tab key, so let’s see…
Practice Max
Now let’s practice MAX in Excel with example:
Min
Min function returns the smallest number in a set of values. It ignores logical values and text.
Syntax: MIN(number1, [number2], …)
With the help of the same example, we can calculate the minimum number of mobiles sold in different years. To do that place the cursor where you want to calculate minimum value press =Min press the Tab key select the range and again press the Tab key, so let’s see…
Now Let’s Practice Max