Page 33 - Plus_V2.2_C6_Flipbook
P. 33
ORDER OF OPERATION Factopedia
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. The first spreadsheet
software was VisiCalc
For example, the formula = 10 + 10 * 2 gives a result of 30 as Excel launched in 1979
multiplies 10 by 2 and then adds 10. designed for Apple II
However, the formula =(10 + 10)*2 produces a result of 40. This is because computer.
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.
Charles Simonyi is
Let’s BaCk-uP called the father of
Excel software.
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.
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.
AutoFill feature automatically fills a series of data in your
worksheet. A spreadsheet can
Formulas in Excel begin with an equal (=) sign. have upto 512 fonts.
A cell can have upto
Excel calculates expressions within parentheses ‘(‘ , ’)’ first.
32,767 characters.
More on Excel 2016 31

