Page 52 - 2502_Pakistan-kifayat_C-8

Double Tap Century #Technology Literacy
21 st
Skills #Critical Thinking
State whether these statements are true or false.
a. Excel makes calculations easier.

b. We can apply all types of mathematical operations like addition, subtraction,
multiplication and division in Excel.

c. The input of =25+B2 will give an error message.

ORDER OF OPERATION

When performing calculations using a formula, Excel follows certain rules of precedence:
Excel calculates expressions within parentheses ‘(‘ , ’)’ first.

Excel calculates multiplication and division before addition and subtraction.

Excel calculates consecutive operators with the same level of precedence from left to right.

For example, the formula = 10 + 10 * 2 gives a result of 30 as Excel multiplies 10 by 2 and then adds 10.

However, the formula =(10 + 10)*2 produces a result of 40. This is because Excel calculates the expression
(10 + 10) within the parentheses first. It then multiplies by 2.

If you are unsure of the order in which Excel calculates, use parentheses even if the parentheses aren’t
necessary. Parentheses also make your formulas easier to read.

CHARTS FOR DATA PRESENTATION

A chart is an effective way to display data in a pictorial form. Chart makes it easier to draw comparisons
and analyse the growth, relationships, and trends among the values in a table.

Components of a Chart

Chart Title: Chart title describes the main aim and content of the chart.

X-axis: X-axis is the horizontal axis of the chart. It is also called the category axis.

Y-axis: Y-axis is the vertical axis of the chart. It is also called the value axis.

Plot Area: It is the rectangular area bounded by the two axis. It contains the actual chart and includes

the plotted data, data series, category, and value axes.

50 Premium Edition-VIII