Skip to main content
Chapter 8 of 10
Practice Quiz

Formulas, Functions and Charts — Practice Quiz

NIOS · Class 12 · Data Entry Operations

Try a 4-question quiz on Formulas, Functions and Charts for NIOS Class 12 Data Entry Operations: tap an answer to check it and see why.

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 practice quiz and more.

Free trial, no card needed.

Quick Quiz: Formulas, Functions and Charts

0/4

Tap an answer to check it instantly. No sign-up needed for these 4.

1

Which symbol must a formula begin with in Excel?

2

Which of the following can be part of an Excel formula?

3

What appears in the formula bar when a cell containing a formula is selected?

4

What does the SUM function do?

72 Questions·
multiple choice

Sample Questions

1multiple choice
1 marks

What is the correct syntax of the SUM function?

Show answer

SUM(number1,number2,...)

The syntax of SUM is SUM(number1,number2,...).

2multiple choice
1 marks

How many arguments can the SUM function take at maximum?

Show answer

255

SUM supports a maximum of 255 arguments.

3multiple choice
1 marks

Which function is used to get the average of numbers?

Show answer

AVERAGE()

AVERAGE returns the arithmetic mean of the arguments.

4multiple choice
1 marks

Which function returns the smallest number in a set of values?

Show answer

MIN()

MIN returns the smallest number in a set of values.

+68 more questions on Formulas, Functions and Charts (NIOS Class 12 Data Entry Operations)

Practise 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 practice questions are there for Formulas, Functions and Charts?
There are 72 questions on Formulas, Functions and Charts. Try the 4-question sample quiz on this page first; each answer shows an explanation when you tap it.

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.