Page 32 - TP_Pluse_V2.2_Class_6
P. 32
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
The first spreadsheet precedence from left to right.
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
computer. 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.
Charles Simonyi is
called the father of Let’s BaCk-uP
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.
Auto Fill feature automatically fills a series of data in your
A spreadsheet can worksheet.
have upto 1024 fonts. Formulas in Excel begin with an equal (=) sign.
A cell can have upto Excel calculates expressions within parentheses ‘(‘ , ’)’ first.
32,767 characters.
30 Plus (Ver. 2.2)-VI

