R _ Term2_Quiz (Complex Calc , Autofill, & Math)

To alert Excel that you are entering a formula and not text, type a(n) -------proceeding

the formula.

• *

• =

• -

In MS Excel when applying a percentage view to (0.234) it will result as -----------.

• 234%

• 2300%

• 23.4%

MS Excel follows the -----------and first adds the values inside the parentheses.

• formula guidelines

• order of operations

• not mentioned

---------- is a pre-set formula, that helps perform mathematical, statistical and logical operations.

• A function

• A complex formula

• A chart

The AutoFill tool duplicates the formula that you´ve typed in the first cell, but makes the appropriate changes each time.

• True

• False

Which expression is same as : =SUM(A3:A6)

• =SUM(A3,A6)

• =SUM(3:6)

• =SUM(A3,A4,A5,A6)

In this Excel sheet these 2 formulas will give the same result.

=SUM(A1:A3)

=SUM(10,25,32)

• True

• False

In this Excel sheet to find the total Sales for the first 6 months we need to type.

• =Sum(C5:C12)

• =Count(C5:C10)

• =Sum(C5:C10)

In MS Excel =POWER (5,2) and =5^2 are resulting the same answer.

• True

• False

In this complex formula: =2*(8-6)/2

if the parentheses are removed which part will be calculated first?

• 6/2

• (8-6)

• 2*8