Skip to main content
Chapter 8 of 9
Practice Quiz

Formulas, Functions and Charts — Practice Quiz

NIOS · Class 10 · Data Entry Operations

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

76 questions38 flashcards10 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 function adds all the numbers in a range of cells?

3

What is the syntax of the SUM function?

4

How many arguments can SUM, AVERAGE, MIN and MAX each take at most?

76 Questions·
multiple choicemultiple correct

Sample Questions

1multiple correct
1 marks

Which set contains only elements that can be part of a formula in Excel?

Show answer

Mathematical operators, Cell references, Text or values, Worksheet functions

A formula can include mathematical operators, cell references, text or values, and worksheet functions.

2multiple choice
1 marks

Which function returns the arithmetic mean of the arguments?

Show answer

AVERAGE

AVERAGE returns the arithmetic mean of the arguments.

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

4multiple choice
1 marks

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

Show answer

MAX

MAX returns the largest number in a set of values.

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

Practise All

Frequently Asked Questions

What are the important topics in Formulas, Functions and Charts for NIOS Class 10 Data Entry Operations?
Key topics in Formulas, Functions and Charts include Formulas and Worksheet Functions, SUM and SUMIF Functions, AVERAGE, MIN, and MAX Functions, Charts and Chart Types. Study these first, then practise questions on each for the NIOS Class 10 board exam.
How many practice questions are there for Formulas, Functions and Charts?
There are 76 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 10 Data Entry Operations. Free to start, no card needed.