wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

What I know Module 6

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

1. It multiplies all the numbers given as argument.

a)

Pow

b)

Quotient

c)

Product

d)

Sum

2.

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

a)

Sum

b)

Quotient

c)

Product

d)

MOD

3.

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

a)

SUMSQ

b)

SUMIFS

c)

SUMIF

d)

SUMPRODUCT

4.

It returns the integer portion of a division.

a)

Sum

b)

Pow

c)

Product

d)

Quotient

5.

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

a)

SUMSQ

b)

SUMPRODUCT

c)

MOD

d)

SUMIF

6.

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

a)

LibreOffice

b)

Google Sheet

c)

Lotus Symphony

d)

Microsoft Excel

7.

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

a)

multiply (x)

b)

Plus (+)

c)

equal (=)

d)

Minus (-)

8.

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

a)

SUMIF

b)

SUMPRODUCT

c)

MOD

d)

SUMSQ

9.

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

a)

SUMSQ

b)

MOD

c)

SUMPRODUCT

d)

SUMIF

10.

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

a)

Publisher

b)

Slide Presentation

c)

Electronic spreadsheet

d)

Word Document