What I know Module 6

1. It multiplies all the numbers given as argument.

• Pow

• Quotient

• Product

• Sum

What functions should be used when adding all the numbers in a range of cell?

• Sum

• Quotient

• Product

• MOD

What function should be used when adding the cells specified by the condition or criteria?

• SUMSQ

• SUMIFS

• SUMIF

• SUMPRODUCT

It returns the integer portion of a division.

• Sum

• Pow

• Product

• Quotient

This function returns the remainder after a number is divided by a divisor.

• SUMSQ

• SUMPRODUCT

• MOD

• SUMIF

What is the most popular electronic spreadsheet program that we used today?

• LibreOffice

• Google Sheet

• Lotus Symphony

• Microsoft Excel

To begin with an Excel function, what sign should be used when you are manually calculating?

• multiply (x)

• Plus (+)

• equal (=)

• Minus (-)

What function that returns the sum of the squares of the arguments?

• SUMIF

• SUMPRODUCT

• MOD

• SUMSQ

This function returns the sum of the products of corresponding ranges or arrays.

• SUMSQ

• MOD

• SUMPRODUCT

• SUMIF

It is an application program designed to perform basic mathematical andarithmetic operations.

• Publisher

• Slide Presentation

• Electronic spreadsheet

• Word Document