MS App > MS Excel Formulas FINAL EXAM

Front

Subtracts values in the two cells

Back

=B2-C9

Front

Multiplies the numbers in the two cells

Back

=D8*A3

Front

Select the function that multiplies the cells in the range

Back

=PRODUCT(A1:A19)

Front

Multiplies the cells in the range, and multiplies the result by 4

Back

=PRODUCT(F6:A1,4)

Front

Divides value in A1 by the value in A4

Back

=A1/A4

Front

Calculates the smallest number in a range

Back

=MIN(A1:A8)

Front

Calculates the largest number in a range

Back

=MAX(C27:C34)

Front

Returns a mathematical average of a given cell range

Back

=AVERAGE(A2:A10)

Front

Totals numbers in a given cell range

Back

=SUM(A2:A10)

Front

Finds the smallest value in a given cell range

Back

=MIN(A2:A10)