Skip to main content
Chapter 8 of 10
Syllabus

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.

72 questions38 flashcards12 formulas & key relations5 concepts

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.

4 Topics · NIOS Class 12 Data Entry Operations · 2026-27

Topics in Formulas, Functions and Charts

1

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.
2

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.
3

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.
4

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

FormulasBasic formula examplesFunctionsSUM and AutoSumSUMIFAVERAGEMIN and MAXCharts

Work through every topic in Formulas, Functions and Charts with notes and quizzes

Start This Chapter

Frequently Asked Questions

What are the important topics in Formulas, Functions and Charts for NIOS Class 12 Data Entry Operations?
Key topics in Formulas, Functions and Charts include Formulas in Excel, SUM and AutoSum, SUMIF, AVERAGE, MIN, and MAX. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How should I revise Formulas, Functions and Charts for the NIOS Class 12 board exam?
Learn the core ideas first, then work through the 72 practice questions on Formulas, Functions and Charts. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

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.