ICF9 - Uses functions and formulas in MS Excel (TLEIE60f-12)

Front

What formula in MS Excel do we use if we are going to add numbers?

Back

SUM

Answer explanation

In MS Excel, the SUM formula is used to add numbers together. It takes a range of cells as input and returns the total sum, making it the correct choice for adding numbers compared to COUNT, AVERAGE, or MAX.

Front

Formula to get the difference of selected cells in Microsoft Excel?

Back

=B2-B2

Answer explanation

The correct formula to find the difference between selected cells in Excel is =B2-B2. This formula subtracts the value in cell B2 from itself, resulting in zero, which demonstrates the syntax for cell subtraction.

Front

What formula do we use to do mathematical division in Microsoft Excel?

Back

QUOTIENT

Answer explanation

In Microsoft Excel, the formula used for division is the QUOTIENT function, which calculates the result of dividing one number by another. The other options (ADDITION, SUBTRACTION, DIVISION) do not specifically refer to a function for division.

Front

What symbol do we use to start a function or formula in Microsoft Excel? Options: +, -, =, /

Back

=

Answer explanation

In Microsoft Excel, all functions and formulas must begin with the equal sign '='. This indicates to Excel that what follows is a formula to be calculated, making '=' the correct choice.

Front

What mathematical symbol do we use in MS Excel to perform the Multiplication formula?

Back

*

Answer explanation

In MS Excel, the multiplication operation is performed using the asterisk symbol (*). The other symbols represent addition (+), subtraction (-), and division (/), making * the correct choice for multiplication.

Front

Which MS Excel formula is correct for getting the product? Options: =PRODUCT(C2-C3), =PRODUCT(C2:C3), -PRODUCT(C2:C3), =PRODUCT(C2/C3)

Back

=PRODUCT(C2:C3)

Answer explanation

The correct formula to get the product of values in cells C2 and C3 is =PRODUCT(C2:C3). This syntax specifies a range, allowing Excel to multiply the values together. The other options are incorrect.

Front

Which MS Excel formula is correct in getting the sum? Options: =B2+B3+B4, -B2+B3+B4, =B2.B3,B4, =B2+B3.B4

Back

=B2+B3+B4

Answer explanation

The correct formula for summing values in Excel is =B2+B3+B4. This formula adds the values in cells B2, B3, and B4 together. The other options use incorrect syntax or operators.

Front

Which MS Excel formula is correct in getting the quotient? Options: =B2/B3, =B3-B2, =B2OVERB3, =B2DIVIDEDBYB3

Back

=B2/B3

Answer explanation

The correct formula to get the quotient in MS Excel is =B2/B3. This divides the value in cell B2 by the value in cell B3, yielding the quotient. The other options do not perform division.

Front

Which MS Excel formula is correct in getting the difference? Options: =B2/B3, =B3-B2, =B2OVERB3, =B2DIVIDEDBYB3

Back

=B3-B2

Answer explanation

The correct formula to get the difference between two values in Excel is =B3-B2. This subtracts the value in B2 from the value in B3, providing the difference. The other options are incorrect for this purpose.

Front

What formula do we use to do mathematical multiplication in Microsoft Excel?

Back

PRODUCT

Answer explanation

In Microsoft Excel, the formula used for multiplication is the PRODUCT function. This function multiplies all the numbers given as arguments, making it the correct choice for performing multiplication.