R _ Complex calculations

A complex formula : has more than one mathematical operator which of these are complex formula

• 2+3*4-1

• (5+2)*8

• 3*4

• 5+2*8

In MS Excel complex calculations where there is more than one part to the formula, the order of the calculations is ----------------

• from left to right

• from right to left

Which symbol is for Power or exponent

• ^

• *

• /

A cell in MS Excel takes its name from the column ----------- and row ------------

• letter , number

• number , letter

which part of these complex formulas will be calculated first 2+3*4-1

• 2+3

• 3* 4

• 4-1

which part of these complex formulas will be calculated first 7+5^2*3

• 7+5

• 5^2

• 2*3

In this complex formula 2/4^3-(5+2)*8 if we removed the parentheses which part will be calculated first

Which of the next cell references is true

• A2

• B0

• 7A

• C4

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet

• True

• False

To format a number as a percentage you need to have a number in -------format

• decimal

• general format