Formulas, Functions and Charts — Syllabus
NIOS · Class 12 · Data Entry Operations
What Formulas, Functions and Charts covers in NIOS Class 12 Data Entry Operations: 4 topics, for the 2026-27 session.
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 syllabus and more.
Free trial, no card needed.
Topics in Formulas, Functions and Charts
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.
Key Concepts
Central concept: Using formulas, functions, charts, and graphics to calculate, summarize, and present worksheet data in Excel 2007
Work through every topic in Formulas, Functions and Charts with notes and quizzes
Start This ChapterFrequently 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
Revision Notes
Key points for last-minute revision
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
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.