ICT Paper A - Grade 5

AutoSum feature calculates the lowest value in the list.

• True

• False

• Partially Correct

Using the given spreadsheet the correct formula to find the average of values from A4 through D4 will be:

• AVERAGE(B4:D4)

• AVG(A4:D4)

• AVG(N/A,B4:D4)

• AVERAGE(A4:D4)

Using the spreadsheet given the correct answer to the formula =Count(A1:D4) will be:

• 4

• 16

• 14

• None of the Above

Using the spreadsheet given the correct answer to the formula =CountA(A1:D4) will be:

• 4

• 16

• 14

• None of the Above

Using the spreadsheet given the correct answer to the formula =MIN(A1:D4) will be:

• N/A

• N/A, N/A

• 3

• 18

Using the given spreadsheet the correct answer to the formula MAX(A1:D4) will be:

• 203

• 900

• 750

• 400

Using the given spreadsheet choose the correct Excel formula to find all the values greater than 100.

• COUNTIF(A1:D4, "><100")

• COUNTIF(A1:D4, ">=100")

• COUNTIF(A1:D4, ">100")

• COUNTIF(A1:D1, "=>100")

It is not important to type '=' before a formula or a function in Excel.

• True

• False

In Excel, the name of the bar where information appears as you input data in called ?

• File Bar

• Help Bar

• Formula Bar

• Window Bar

The function COUNT is specific for _________________

• Counting cells

• Counting text

• Counting number

• Counting tables