Mon to sat Open: 10am - 6pm

Lesson 2 - Autosum & Mathematics Operator

  • Home
  • / Fun With Excel
excel-autosum

AUTOSUM -


Autosum is a predefined command of adding your data. In order to used it just select the cell where you want the total of your data and then select the cell range. Group of cell are highlighted and on pressing Enter key it will show you a result.


Mathematical Operator –


In math’s you will learn about Mathematical Operator like –

  • 1. Addition (+)
  • 2. Subtraction (-)
  • 3. Multiplication (*)
  • 4. Division (/)
  • 5. Exponent (^) etc.

In excel we use the same but sign of operation will change.


Ordering of Operation –


In excel there is an order of operation. There is a sequence of operation excel will follow while calculating a data.


  1. 1. First it calculate the data enclosed in Parentheses or Brackets.
  2. 2. After Parentheses, it will calculate a data presents with exponent.
  3. 3. Then it will do Multiplication or Division (from left to right which comes first).
  4. 4. After this, it will do Addition or Subtraction again from left to right.
  5. 5. Finally result will show.


About the author

vinay-bhatt-image

Vinay Bhatt

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.


Course Lesson -

Introduction, Autosum Mathematics Operator, Formula, Creating Formula, Function, Inserting Function, Function or Formula, Why to Learn Function or Formula, Mixed Cell Reference, Relative Cell Reference, Types of Charts, Formatting Charts

Join Learnincreation Study Center

Join LearnInCreation Study Center to learn practical computer and technology skills through simple lessons and hands-on training. Choose from Computer Basics, MS Office, Programming, Web Designing, Digital Marketing, and more. Get guidance, practice your skills, and prepare for your future. Visit our study center and enroll today!