GRADE 10 ICT POP QUIZ 2

You need to sum the values in cells A1 to A10 but only if the values are greater than 50. Which formula would you use?

• =SUM(A1)

• =IF(A1>50, SUM(A1), 0)

• =SUMIF(A1, ">50")

• =COUNTIF(A1, ">50")

If you want to count the number of non-blank cells in a range from B1 to B20, which function would you use?

• =COUNT(B1)

• =COUNTA(B1)

• =COUNTBLANK(B1)

• =COUNTIF(B1, "<>")

In a VLOOKUP formula, what does the FALSE parameter indicate in the following formula: =VLOOKUP(A1, B1, 2, FALSE)?

• It returns an approximate match.

• It returns an exact match.

• It excludes text values.

• It sorts the values before looking them up.

You want to search for a value in the first row and return a value from the third row in a horizontally structured table. Which function would be most appropriate?

• =VLOOKUP(A1, B1, 3, FALSE)

• =HLOOKUP(A1, B1, 3, TRUE)

• =VLOOKUP(A1, B1, 3, TRUE)

• =HLOOKUP(A1, B1, 3, FALSE)

In which scenario is HLOOKUP more suitable than VLOOKUP?

• When data is organized in rows and you need to search horizontally.

• When data is organized in columns and you need to search vertically.

• When you need to perform a lookup in a single cell.

• When you need to perform a lookup in a large dataset.

When you are searching for a value in the first row and retrieving values from lower rows.

• When you are retrieving data from a pivot table.

• When you are searching for a value to the left of the lookup column.

• When you are searching for a value in the first row and retrieving values from lower rows.

• When you are searching for a value to the left of the lookup column.

What would the formula =ROUNDDOWN(6.789, 2) return?

• 6.79

• 6.78

• 6.8

• 7.00

What does the COUNTIF function do in Excel?

• Counts all the values in a range.

• Counts cells that meet a single condition or criterion.

• Counts blank cells.

• Counts cells with numeric values only.

If the formula =INT(-3.7) is applied, what will the result be?

• -3

• -4

• 0

• 3

What does the HLOOKUP function do in Excel?

• Looks for a value horizontally in a table and returns a value in the same column.

• Looks for a value horizontally in the first row of a table and returns a value in the same column.

• Looks for a value vertically in a column and returns a value in the same row.

• Looks for a value in any row of a table and returns the maximum value.