Let’s learn Formulas in Excel

6e55v_enhanced.png

1. SUM

First, we have to start with “=” and then we have to type SUM, let's follow the slides below-

download (31).png

download (32).png

2. Average

First start with ‘=’ then type AVERAGE or select from the dropdown

Then put first cell number : last cell number

download (18).png

Close the bracket and hit enter

You will get your average value.

download (19).png

You can select the cells manually like this