1. What function should be used when adding the cells specified by the condition or criteria?
a. SUMPRODUCT
b. SUMIF
C. SUMIFS
d. SUMSO
2. It returns the integer portion of a division.
a. Quotient
b. Sum
c. Product
d. Power
3.what is the most popular electronic spreadsheet program used today ?
a.plus (+)
b.minus (-)
c. equal (=)
d.multiply (×)
4.
it is an application program designed to perform basic mathematical and arithmetic operations.
a.electronic spreadsheet
b.slide presentation
c.word document
d.publisher
Answers & Comments
Answer:
1. B. SUMIF
SUMIF function should be used when adding the cells specified by the condition or criteria.
2. A. Quotient
Quotient returns the integer portion of a division.
3. Microsoft Excel none of the choices
Microsoft Excel is the most popular electronic spreadsheet program used today.
4. A. Electronic spreadsheet
Electronic spreadsheet is an application program designed to perform basic mathematical and arithmetic operations.