Module 6: Performing Advance Calculations Using Electronic Sprea

It multiplies all the numbers given as argument.

• Quotient

• Product

• Sum

• Power

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?

• SUMPRODUCT

• SUMIFS

• SUMIF

• SUMSQ

It returns the integer portion of a division.

• Quotient

• Product

• Sum

• Power

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

• SUMPRODUCT

• SUMIF

• MOD

• SUMSQ

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

• Lotus Symphony

• Microsoft Excel

• Google Sheet

• LibreOffice

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

• plus (+)

• equal (=)

• minus (-)

• multiply (x)

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.

• SUMIF

• SUMPRODUCT

• MOD

• SUMSQ

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

• Electronic spreadsheet

• Word Document

• Slide Presentation

• Publisher