Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel Functions Quiz

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

What function adds all the numbers in a range of cells?

a)

SUM

b)

DIFFERENCE

c)

PRODUCT

d)

QUOTIENT

2.

How can you calculate the difference between two numbers in Excel?

a)

Using the DIFFERENCE function

b)

Using subtraction (-)

c)

Using addition (+)

d)

Using the AVERAGE function

3.

What function multiplies all the numbers in a range of cells?

a)

SUM

b)

PRODUCT

c)

AVERAGE

d)

COUNT

4.

What function returns only the integer portion of a division?

a)

QUOTIENT

b)

ROUND

c)

AVERAGE

d)

MAX

5.

What function calculates the average of a range of numbers?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

6.

What function returns the largest number in a range of cells?

a)

MAX

b)

MIN

c)

COUNT

d)

NOW

7.

What function returns the smallest number in a range of cells?

a)

MAX

b)

MIN

c)

AVERAGE

d)

SUM

8.

What function performs a logical test and returns one value for TRUE and another for FALSE?

a)

IF

b)

SUM

c)

AVERAGE

d)

COUNT

9.

What function counts the number of numeric values in a range of cells?

a)

COUNT

b)

SUM

c)

AVERAGE

d)

MAX

10.

What function returns the current date and time?

a)

NOW

b)

TODAY

c)

AVERAGE

d)

SUM

11.

What function returns the current date without the time?

a)

NOW

b)

TODAY

c)

AVERAGE

d)

SUM

12.

What function rounds a number to a specified number of digits?

a)

ROUND

b)

ROUNDUP

c)

ROUNDDOWN

d)

AVERAGE

13.

What function rounds a number up, away from zero?

a)

ROUNDUP

b)

ROUND

c)

ROUNDDOWN

d)

AVERAGE

14.

What function rounds a number down, toward zero?

a)

ROUND

b)

ROUNDUP

c)

ROUNDDOWN

d)

AVERAGE

15.

Which software is commonly used for creating spreadsheets, performing data analysis, and generating charts?

a)

MS Word

b)

MS PowerPoint

c)

MS Excel

d)

MS Access