DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
By using simple formulas
|
|
|
By using parentheses
|
|
|
They cannot be forced
|
|
|
By positioning the operations from left to right
|
Detailed explanation-1: -To change the order of evaluation, enclose in parentheses the part of the formula to be calculated first. For example, the following formula produces 11 because Excel performs multiplication before addition. The formula multiplies 2 by 3 and then adds 5 to the result.
Detailed explanation-2: -Parentheses () is used to change the order of an operation. Using parentheses makes Excel do the calculation for the numbers inside the parentheses first, before calculating the rest of the formula.
Detailed explanation-3: -Very often in chemical formulae, we use parentheses to form subgroups of atoms within a molecule. Usually this has some meaning about the structure of the molecule, but don’t worry about that for now. Parentheses are useless in a chemical formula if they don’t have a subscript, so we’ll assume one is always there.
Detailed explanation-4: -In general, Excel’s order of operation follows the acronym PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) but with some customization to handle the formula syntax in a spreadsheet.