review TLE 6 EXCEL

MS Excel is one of the most commonly used computerized

worksheet.

• 
• 

SUMPRODUCT is a function that returns the remainder

after a number is divided by a divisor.

• 
• 

MS Excel is widely used in accounting and financial

applications, statistics, engineering calculations, as well as

in analyzing data.

• 
• 

To create and enter functions without the equal (=) sign,

excel will still calculate a result.

• 
• 

2. What functions should be used when adding all the

numbers in a range of cell?

• a. Sum

• b. Product

• c. Quotient

• d. MOD

3. What function should be used when adding the cells

specified by the condition or criteria?

• a. SUMPRODUCT

• b. SUMIF

• c. SUMIFS

• d. SUMSQ

4. It returns the integer portion of a division.

• a. Quotient

• b. Sum

• c. Product

• d. Power

5. This function returns the remainder after a number is

divided by a divisor.

• a. SUMPRODUCT

• b. MOD

• c. SUMIF

• d. SUMSQ

6. What is the most popular electronic spreadsheet program

that we used today?

• a. Lotus Symphony

• b. Google Sheet

• c. Microsoft Excel

• d. LibreOffice

7. 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)