Formulas, Functions and Charts — Revision Notes
NIOS · Class 12 · Data Entry Operations
Formulas, Functions and Charts revision notes for NIOS Class 12 Data Entry Operations: 4 topics in quick points.
Interactive on Super Tutor
Studying Formulas, Functions and Charts? Get the full interactive chapter.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for revision notes and more.
Free trial, no card needed.
Key Topics to Revise
Formulas in Excel
- A formula must begin with the equal-to sign =.
- A formula can include mathematical operators such as + and /, and logical operators such as < and >.
- A formula can include cell references, named ranges, text, values, and worksheet functions.
SUM and AutoSum
- SUM adds all numbers in a range of cells.
- The syntax of SUM is SUM(number1,number2,...).
- The SUM function can take a maximum of 255 arguments.
SUMIF
- SUMIF adds cells with respect to a given criteria.
- The syntax is SUMIF(range, criteria, sum_range).
- Blank and text values are ignored in SUMIF.
AVERAGE, MIN, and MAX
- AVERAGE returns the arithmetic mean of the arguments.
- MIN returns the smallest number in a set of values.
- MAX returns the largest number in a set of values.
Get complete notes with diagrams and examples
Full NotesKey Concepts
Frequently Asked Questions
What are the important topics in Formulas, Functions and Charts for NIOS Class 12 Data Entry Operations?
How should I revise Formulas, Functions and Charts for the NIOS Class 12 board exam?
Sources & Official References
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Formulas, Functions and Charts
Practice Quiz
Test yourself with a quick quiz
Important Questions
Exam-style questions with answers
Formula Sheet
The chapter's formulas in one place
Chapter Summary
Understand the chapter at a glance
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
For serious students
Get the full Formulas, Functions and Charts chapter — start free.
Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Data Entry Operations. Free to start, no card needed.