Form 2 CL

What is the next column letter after "Z"?

• A

• ZA

• AA

• No such column letter

A pie chart is used to

• show a trend over a period of time

• show the average value of some categoreis of data

• show the difference between the smallest and the largest values in a set of data

• show the proportions of different categories of data

Sort the numbers 15, 27, 15, 8, 15, 7 in ascending order

• 7, 8, 15, 27

• 7, 8, 15, 15, 15, 27

• 27, 15, 8, 7

• 27, 15, 15, 15, 8, 7

Sort the numbers 15, 27, 15, 8, 15, 7 in descending order

• 7, 8, 15, 27

• 7, 8, 15, 15, 15, 27

• 27, 15, 8, 7

• 27, 15, 15, 15, 8, 7

It is known that cell A1 stores number. But why does it show "####" instead of a number?

• The cell is not wide enough to show the numner

• The number stores in the cell is a fraction

• The cell is locked

• The cell is blank

Which of the following spreadsheet formulae can calculate the square of the value stored in cell B7?

• =B7*B7

• =2^B7

• =SQRT(B7)

• =B7*2

Which of the following formulae CANNOT add up the values stored in cells C4, C5 and C6?

• =C6+C5+C4

• =SUM(C4:C6)

• =SUM(C6, C5, C4)

• =SUM(C4!C6)

Which of the following spreadsheet formulae can correct the number 34.5 to its nearest integer?

• =round(34.5,0)

• =round(0, 34.5)

• =round(34.5,1)

• =round(34.5, -1)

Worksheet

• An area that contains cells for data input in a spreadsheet

• A basic storage unit of a spreadsheet

• A graphical way to present the relationship between data

• Formed by a column letter and a row number

Cell address

• An area that contains cells for data input in a spreadsheet

• A basic storage unit of a spreadsheet

• A graphical way to present the relationship between data

• Formed by a column letter and a row number