wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Chapter 20 - Spreadsheets

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

You are managing the expenses for monthly grocery and have a list of different costs in a column. You want to quickly find out the total amount spent.

a)

=ADD

b)

=SUM

c)

=TOTAL

d)

=ADDITION

2.

A teacher wants to determine the average score of students in a test from a list of marks.

a)

=MEAN

b)

=FIND

c)

=AVERAGE

d)

=SUM

3.

You have a list of daily temperatures recorded for a week. You need to find out the highest temperature recorded during the week.

a)

=HIGHEST

b)

=MAX

c)

=SUM

d)

=COUNT

4.

In a list of product prices, you want to round each price to the nearest whole number.

a)

=ROUND

b)

=INTEGER

c)

=COUNT

d)

=IF

5.

You are tracking attendance in a class, and you have a list of "Present" and "Absent" marks. You need to count how many times students were marked "Present."

a)

=COUNT

b)

=COUNTA

c)

=COUNTB

d)

=COUNTIF

6.

A sales report contains both numerical data (sales amounts) and text data (sales regions). You need to count how many cells in the report contain numerical data.

a)

=COUNTA

b)

=COUNT

c)

=COUNTIF

d)

=COUNTB

7.

You have a list of employees with their salaries and need to find out who has the least salary.

a)

=MAX

b)

=FIND

c)

=SEARCH

d)

=MIN

8.

In a list of exam scores, you want to check if a student has scored more than 40 to determine if they passed or failed and display the result.

a)

=IF

b)

=FIND

c)

=SEARCH

d)

=COUNT

9.

You have a long list of student names in one column and their corresponding grades in another. You need to find the grade of a specific student.

a)

=SEARCH

b)

=FIND

c)

=LOOKUP

d)

=SUM

10.

You need to find out how many students scored above 80 in an exam from a list of scores.

a)

=COUNTA

b)

=COUNTIF

c)

=COUNT

d)

=FIND