Skip to main content
Chapter 7 of 16
Formula Sheet

Functions in Calc — Formula Sheet

Gujarat Board · Class 10 · Computer Studies

16 formulas from Functions in Calc (Gujarat Board Class 10 Computer Studies) on one page, grouped by topic. Covers Basics of Functions in Calc.

70 questions60 flashcards16 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Functions in Calc? 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.

16 Entries · 4 Sections

Formulas and Key Relations

Core Idea and Syntax

=SUM(A1:A10)

=SUM(23,25)

=IF(Test,True,False)

AND(Cond_1,Cond_2,...,Cond_30)

OR(Cond_1,Cond_2,...,Cond_30)

Mathematical Functions

ABS(n)

=EXP(1)

FACT(n)

LN(Number)

LOG10(Number)

Statistical Functions

AVERAGE(x1,x2,...,x30)

GEOMEAN(x1,x2,...,x30)

HARMEAN(x1,x2,...,x30)

MEDIAN(x1,x2,...,x30)

MODE(x1,x2,...,x30)

Financial Function

NPER(Interest,Instalment,Loan,Future,Type)

Full sheet with units and worked examples

View All

Frequently Asked Questions

What are the important topics in Functions in Calc for Gujarat Board Class 10 Computer Studies?
Key topics in Functions in Calc include Basics of Functions in Calc, Mathematical Functions, Statistical Functions, Financial Function. Study these first, then practise questions on each for the Gujarat Board Class 10 board exam.
How many formulas are in Functions in Calc?
This sheet lists 16 formulas from Functions in Calc, grouped by topic. Learn what each symbol stands for so you can apply the formula, not just recall it.
How should I revise Functions in Calc for the Gujarat Board Class 10 board exam?
Learn the core ideas first, then work through the 70 practice questions on Functions in Calc. 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 Functions in Calc chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for Gujarat Board Class 10 Computer Studies. Free to start, no card needed.