Skip to main content
Chapter 8 of 10
Formula Sheet

Formulas, Functions and Charts — Formula Sheet

NIOS · Class 12 · Data Entry Operations

12 formulas from Formulas, Functions and Charts (NIOS Class 12 Data Entry Operations) on one page, grouped by topic.

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 formula sheet and more.

Free trial, no card needed.

12 Entries · 3 Sections

Formulas and Key Relations

Formulas

=B3+C3+D3+E3

=SUM(B3:E3)

=B1*C1

=A1*B1-C1+D1

=((A1*B1)+C1)/D1

Functions

SUM(number1, number2, ...)

SUMIF(range, criteria, sum_range)

AVERAGE(number, number2, ...)

MIN(number1, number2, ...)

MAX(number1, number2, ...)

Key relations

If A1 = 2, B1 = 3, C1 = 4, and D1 = 5, then =B1*C1 gives 12, =A1*B1-C1+D1 gives 7, and =((A1*B1)+C1)/D1 gives 2.

A short form for the same addition is =SUM(B3:E3).

Full sheet with units and worked examples

View All

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 many formulas are in Formulas, Functions and Charts?
This sheet lists 12 formulas from Formulas, Functions and Charts, grouped by topic. Learn what each symbol stands for so you can apply the formula, not just recall it.
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.