Formulas, Functions and Charts — Chapter Summary
NIOS · Class 12 · Data Entry Operations
Summary of Formulas, Functions and Charts for NIOS Class 12 Data Entry Operations. Key concepts: A formula must begin with, If A1 = 2 and SUM(number1.
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 chapter summary and more.
Free trial, no card needed.
Overview
Notice how a single formula can add marks, compare values, or combine several calculations at once. Count the cell references carefully, because the equal sign starts every formula, operators such as +, /, <, and > connect the parts, and functions like SUM, AVERAGE, MIN, and MAX make repeated calcul
Key Concepts
A formula must begin with
A formula must begin with the equal-to sign. It can include mathematical operators, logical operators, cell references, text or values, and worksheet
If A1 = 2
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 simple cell-sum formula can also be
SUM(number1
SUM(number1,number2,...) adds all the numbers in a range of cells. It supports up to 255 arguments. A short form for the same addition is =SUM(B3:E3).
SUMIF(range
SUMIF(range, criteria, sum_range) adds cells according to a given condition. Criteria can be a number, expression, or text. Blank and text values are
AVERAGE(number
AVERAGE(number, number2,...) returns the arithmetic mean of the arguments and supports up to 255 arguments.
Learning Objectives
- Use formulas to get the desired result
- Use functions for quick calculations
- Create various charts
- Draw graphics using Clip Art and SmartArt
- Insert and edit a picture from a file
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
Revision Notes
Key points for last-minute revision
Formula Sheet
The chapter's formulas in one place
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.