ict test

What is the AVERAGE() function?

• Calculates the sum of a range of numbers.

• Calculates the mean of a range of numbers.

• Finds the maximum value in a range of numbers.

• Finds the minimum value in a range of numbers.

Before writing any formula, we select the cell and press…

• +

• =

• :

• ;

Choose the wrong expression in Excel.

• =SUM(A1:A5)

• =AVERAGE(B1:B5)

• =SUM(A1:A5;B1:B5)

• =COUNT(A1:A5)

Choose the correct expression in Excel.

• =SUM(A1:A5)

• =SUM(A1+A5)

• =SUM(A1:A5)

• =TOTAL(A1:A5)

What will A3 contain if A1=500, A2=450, and autofill is used?

• 400

• 450

• 300

• 500

What will A3 contain if A1=300, A2=350, and autofill is used?

• 400

• 300

• 350

• 5

Can a cell be transferred from horizontal to vertical?

• No

• Yes, using Copy-Paste only.

• Yes, using the Transpose option.

• Yes, using Autofill.

What kind of address is $C$1?

• Relative reference.

• Mixed reference.

• Absolute reference.

• Dynamic reference.

What kind of address is C$1?

• Relative reference

• Mixed reference.

• Absolute reference.

• Dynamic reference.

What kind of address is $C1

• Relative reference.

• Mixed reference.

• Absolute reference.

• Dynamic reference