M4 T3

which function we should apply to get the value of the products ?

• =B2-B2*C2%

• =B2*C2%

• =B2+B2*C2%

• =C2-B2*C2%

Which function we should apply to get the total price ?

• =B5 - E5

• =D5 * E5

• =B5 + E5

• =E5 * B5 –C5%

The correct sequence of calculations is first addition and subtraction and then

multiplication and division.

• T

• F

if there are parentheses in an equation, first we do the calculations inside the

parentheses and then the rest.

• T

• F

The Sum function gives us the result of the addition of the numbers you´ve

selected.

• T

• F

The Average function calculates the largest number of a selected area

• T

• F

The AutoFill tool duplicates the formula that you´ve typed in the first cell, but

makes the appropriate changes each time.

• T

• F

7. Microsoft Excel only understands Latin characters in formulas.

• T

• F

The Max Functions gives the smallest numbers

• T

• F

The Min Function gives the largest numbers

• T

• F