NEW
Font size
WorksheetsChapter 20 - Spreadsheets
Total questions: 10
Worksheet time: 5mins
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.
=ADD
=SUM
=TOTAL
=ADDITION
A teacher wants to determine the average score of students in a test from a list of marks.
=MEAN
=FIND
=AVERAGE
=SUM
You have a list of daily temperatures recorded for a week. You need to find out the highest temperature recorded during the week.
=HIGHEST
=MAX
=SUM
=COUNT
In a list of product prices, you want to round each price to the nearest whole number.
=ROUND
=INTEGER
=COUNT
=IF
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."
=COUNT
=COUNTA
=COUNTB
=COUNTIF
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.
=COUNTA
=COUNT
=COUNTIF
=COUNTB
You have a list of employees with their salaries and need to find out who has the least salary.
=MAX
=FIND
=SEARCH
=MIN
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.
=IF
=FIND
=SEARCH
=COUNT
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.
=SEARCH
=FIND
=LOOKUP
=SUM
You need to find out how many students scored above 80 in an exam from a list of scores.
=COUNTA
=COUNTIF
=COUNT
=FIND
