Page 23 - Viva ICSE Computer Studies 8 : E-book

Excel 2016 is used to perform calculations either using a formula or a function. Let’s study more
about them.

Introduction

You have learnt diff erent formulae in mathematics. Similarly, Excel also has formulae. They are
user-defined instructions to perform calculations.
Learn More
The data in a formula consists of the following.
• Values: String or numeric • A formula in Excel begins
with an equal to (=) sign.
• Cell address: A1, B4 and so on • An Excel workbook contains
• Functions: MAX, MIN, SUM and more one worksheet by default.
• Operators: +, –, *, /, and more
Operators
• Parenthesis: ( ) Parenthesis
Function
Let’s look at an example given alongside.
= A2 + B3 3 – Sum (B4 : B7)
*
Range
Cell Address
Operators in Excel

The Excel operators perform actions on numeric values, text or cell references. There are
diff erent types of operators. Let’s learn about them.

Arithmetic Operators
The arithmetic operators perform calculations with numeric values only.

Operator Meaning Example

+ Addition = 20 + 4
– Subtraction = 11– 6
* Multiplication = 10 3
*
/ Division = 100 / 2

^ Exponentiation = 5 ^ 2
% Percentage = 100%

Relational Operators

The relational operators are used to compare two values. They give the result in true or false.

Operator Meaning Example
= Equal to 4 = 4
< Less than 10 < 50
> Greater than 50 > 5

<> Not equal to 10 <> 5
> = Greater than or equal to 10 > = 5
< = Less than or equal to 5 < = 9

11