Skip to main content
Chapter 8 of 10
Chapter Summary

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.

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