Lesson 7 - Function or Formula
- Home
- / Fun With Excel
Sometimes, or in someplace it’s good to used function instead of formula. Function are already predefined for us and also makes your task easy.
Read this given situation –
Let’s assume you need to calculate a total sum, from cell A1 to cell A15. You will create formula for it
= A1 + A2 + A3 + A4 + ………. + A14 + A15 , so it is a time taken and long process, on other hand you can complete this task with the help of function.
Let see how –
= SUM(A1:A15)
Look, function will makes our work easy and also it is a short method. Well here we are considering only 15 cells, think about adding more than 100 cells, so it is good to uses function instead of formula, in order to save time and work more efficiently and smartly.
As you know, each cell in worksheet have a unique cell address, which is a combination of name of column and row which create that cell by intersecting.
This cell address or cell reference is used to create a formula. Benefits of using cell reference in a formula is that on manipulating a data in a referenced cell the result is update itself, you don’t need to write a formula again and again.
Let’s discuss about the types of cell reference. There are three types of cell reference named as
Vinay Bhatt is the Founder of LearnInCreation, an education and technology platform focused on making computer science and digital learning simple, practical, and accessible. He holds a B.Sc. degree from Kumaun University and has professional certifications in Full Stack Web Development, Digital Marketing, and Ethical Hacking. Passionate about education and technology, he creates beginner-friendly courses, practical learning resources, and projects that help students develop real-world skills and prepare for their careers.
LearnInCreation helps students learn computer science and technology through easy-to-understand courses, practical projects, books, e-books like learning resources, enabling them to build skills for academic success and future careers.
Watch old videos of computer lessons, Subscribe us on Youtube
