Question

write the formula to calculate sum of cells L1 to L90​

Answer 1

Answer:

The formula to calculate the sum of cells L1 to L90 is -

$\dag \underline{ \boxed{ \sf=SUM(L1 : L90) }}$

Explanation:

The SUM() function in MS-Excel is used to calculate sum of cells in a given range.

Syntax:

$\dag \underline{ \boxed{ \sf=SUM(range) \: or \:=SUM(n1,n2,...) } }$

So, to calculate sum of cells from L1 to L90, we wrote the formula - =SUM(L1 : L90)

There are many more functions in Excel such as AVERAGE() function to calculate average of numbers, MAX() function to calculate maximum of numbers in a given range and so on..

•••♪