Chapter 20 - Spreadsheets

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