2.10 Other Processing Methods 1

What does a '1' in the attendance spreadsheet indicate?

• The student was absent on that day.

• The student attended on that day.

• The student was late on that day.

• The student left early on that day.

Answer explanation

In the attendance spreadsheet, a '1' indicates that the student attended on that day, while other options like absence, lateness, or leaving early would be represented by different values.

Which function allows you to count cells based on a specific criterion?

• COUNT

• SUMIF

• COUNTIF

• AVERAGEIF

Answer explanation

The COUNTIF function is specifically designed to count cells that meet a certain criterion, making it the correct choice. COUNT counts all cells, SUMIF sums values based on criteria, and AVERAGEIF averages them.

In the context of the VLOOKUP function, what does the 'V' stand for?

• Vertical

• Variable

• Value

• Vector

Answer explanation

In the VLOOKUP function, the 'V' stands for 'Vertical'. This indicates that the function searches for a value in the first column of a table and returns a value in the same row from a specified column, hence the vertical orientation.

What is the primary difference between VLOOKUP and HLOOKUP functions?

• VLOOKUP searches horizontally, HLOOKUP searches vertically.

• VLOOKUP searches vertically, HLOOKUP searches horizontally.

• VLOOKUP is used for numbers, HLOOKUP is used for text.

• VLOOKUP is faster than HLOOKUP.

Answer explanation

The primary difference is that VLOOKUP searches vertically in columns for a value, while HLOOKUP searches horizontally in rows. This distinction is crucial for selecting the appropriate function based on data layout.

Which of the following is a correct use of the COUNTIF function to count cells with values greater than 10?

• `=COUNTIF(A1:A10, ">10")`

• `=COUNTIF(A1:A10, "<10")`

• `=COUNTIF(A1:A10, "=10")`

• `=COUNTIF(A1:A10, "10")`

Answer explanation

The correct use of the COUNTIF function to count cells with values greater than 10 is `=COUNTIF(A1:A10, ">10")`. This formula accurately counts all cells in the range A1:A10 that contain values exceeding 10.

In a climate dashboard, what is the purpose of using the VLOOKUP function?

• To calculate the average temperature.

• To find and display data for a specific month across ten years.

• To draw a graph of the highest temperature recorded.

• To sort the data in ascending order.

Answer explanation

The VLOOKUP function is used to search for a specific value in a table and return related data. In this case, it helps find and display data for a specific month across ten years, making it the correct choice.

Which of the following is NOT a valid argument for the VLOOKUP function?

• Lookup value

• Table array

• Row index number

• Range lookup

Answer explanation

The 'Row index number' is NOT a valid argument for the VLOOKUP function. The correct arguments are 'Lookup value', 'Table array', and 'Range lookup', which are essential for the function to operate properly.

What does the HLOOKUP function return?

• A value from a column

• A value from a row

• A sum of values

• A count of values

Answer explanation

The HLOOKUP function searches for a value in the first row of a table and returns a value from a specified row in that column. Therefore, it returns a value from a row, making this the correct choice.

If you want to count the number of students who attended more than 3 days, which function would you use?

• SUM

• COUNTIF

• AVERAGE

• MAX

Answer explanation

To count the number of students who attended more than 3 days, you would use the COUNTIF function. This function allows you to count cells that meet a specific condition, in this case, attendance greater than 3.

Which of the following best describes the purpose of using spreadsheet functions like VLOOKUP and HLOOKUP?

• To perform complex mathematical calculations

• To search for and retrieve specific data from a table

• To format cells with different colours

• To create pivot tables

Answer explanation

The purpose of functions like VLOOKUP and HLOOKUP is to search for and retrieve specific data from a table, making it easier to find information without manually scanning through rows or columns.