Page 60 - Penta Book's ICT Catalogue

TASK 1
Complex calculations

You know how to make simple calculations using Microsoft Excel. What about a complex
algebraic expression? Well, it’s time to make difficult things much easier and faster.

Calculation rules The calculation order: The basic calculations
When you do complex and their symbols in
Microsoft Excel are:
calculations and there is more 1 Firstly, do the operations in
than one part to the formula, the parentheses. * multiplication
order of the calculations is from 2 Secondly, do the ^ exponent
left to right, but any part of the calculations with exponents. / division
formula in parentheses will be 3 Then, do the multiplications
calculated first. and divisions. + addition

4 And in the end, do the - subtraction
additions and subtractions. % percentage

Let’s find the result of ((2021^2/2021)-2020)^2021 DIGITAL TEENS 2 MODULE 5 Computing and ICT . Sample Pages

To calculate the formula:
> On a worksheet, click cell
A1. 1
> Type =, to start the formula. 8
GRADE
> Type the mathematical 1
formula ((2021^2/2021)-
2020)^2021. 2 2
> Press Enter  . 3
3

Let’s try another one! This time, you are going to write a formula which will contain a cell reference.
In this way, you will produce a result that may change if the data in those cells also change.
Type the numbers below:

1
To calculate the expression
((C1^A1)-(D1^B1))+((B1/
A1)*A1)^2:

> Click cell A3 and type =
((C1^A1)-(D1^B1))+
((B1/A1)*A1)^2. 1
2 When you click a cell,
> Press Enter  . 2
its reference appears
Penta Books in the formula box. 59