Page 43 - TP_Prime_v2.2_Class_6
P. 43
• 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. MORE ON EXCEL
Let's Revisit
• Excel provides a lot of facilities to modify and process data.
You can specify a column width of 0 to 255 and a row height of 0 to 409.
The default column width is 8.43 characters and the default row height is 15 points. 41
Combining two or more cells is known as Merging.
Splitting cells means to separate two cells that were previously merged.
To further enhance your spreadsheet, you can format a number of elements such as text,
numbers, colouring, and table styles.
You can also customise the worksheet tab.
Auto Fill feature automatically fills a series of data in your worksheet.
Formulas in Excel begin with an equal (=) sign.
Excel calculates expressions within parentheses ‘(‘ , ’)’ first.
Mind Drill
Rapid Fire
1. Tick (✓) the correct option.
a. Home tab includes formatting elements such as ____________.
(i) Text wrap (ii) Merging cells
(iii) Cell style (iv) All of the above

