PERFORMING ADVANCE CALCULAIONS USING ELECTRONIC SPREADSHEETS

It multiplies all the numbers given as argument.

• Quotient

• Sum

• Product

• Power

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

• Sum

• Product

• Quotient

• MOD

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

• SUMPRODUCT

• SUMIF

• SUMIFS

• SUMSQ

It returns the integer portion of a division.

• Quotient

• Sum

• Product

• Power

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

• SUMPRODUCT

• MOD

• SUMIF

• SUMSQ

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

• Lotus Symphony

• Google Sheet

• Microsoft Excel

• LibreOffice

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

• Plus (+)

• Minus (-)

• Equal (=)

• Multiply (x)

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

• SUMIF

• MOD

• SUMPRODUCT

• SUMSQ

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

• SUMIF

• MOD

• SUMPRODUCT

• SUMSQ

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

• Electronic Spreadsheet

• Slide Presentation

• Word Document

• Publisher