NEW
Font size
WorksheetsWhat I know TLE
Total questions: 10
Worksheet time: 5mins
To begin with an Excel function, what sign should be used when you are manually calculating?
a. Plus (+)
b. Minus (-)
c. equal (=)
d. multiply (x)
What function that returns the sum of the squares of the arguments?
a. SUMIF
b. MOD
c. SUMPRODUCT
d. SUMSQ
This function returns the sum of the products of corresponding ranges orarrays.
a. SUMIF
b. MOD
c. SUMPRODUCT
d. SUMSQ
.It is an application program designed to perform basic mathematical andarithmetic operations.
a. Electronic spreadsheet
b. Slide Presentation
c. Word Document
d. Publisher
It multiplies all the numbers given as argument.
a. Quotient
b. Sum
c. Product
d. Power
What functions should be used when adding all the numbers in a range of cell?
a. Sum
b. Product
c. Quotient
d. MOD
What function should be used when adding the cells specified by the condition or criteria?
a. SUMPRODUCT
b. SUMIF
c. SUMIFS
d. SUMSQ
It returns the integer portion of a division.
a. Quotient
b. Sum
c. Product
d. Power
This function returns the remainder after a number is divided by a divisor.
a. SUMPRODUCT
b. MOD
c. SUMIF
d. SUMSQ
What is the most popular electronic spreadsheet program that we used today?
a. Lotus Symphony
b. Google Sheet
c. Microsoft Excel
d. LibreOffice
