Font size
WorksheetsWhat I know Module 6
Total questions: 10
Worksheet time: 5mins
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
