SST 1 - 4 (Sec 1 CPA)

How many rows and columns are in the table below?

• 4 rows and 4 columns

• 4 rows and 5 columns

• 5 rows and 4 columns

• 5 rows and 5 columns

What is the range of cells that is shaded?

• 4B:7D

• 4B:D7

• B4:D7

• D7:B4

Which of the following is the content in cell C5?

• 32

• 42

• 66

• 55

Which cells have been merged?

Answer explanation

Answer: A1:C1

What is the range of cells that has been

right - aligned?

Answer explanation

Answer: A7:A10

Write down the formula used in cell B5 to calculate the Salary($) for Jan.

Answer explanation

Mr Koh worked 150 hours. This data is found in cell B3.

He is paid $20 per hour. This data is foun in cell B4.

So, his total salary would be

150 x 20 --> =B3*B4

Write down the formula used in cell B12 to calculate the Savings ($) for Jan.

Answer explanation

Mr Koh's salary is $3000 (B5)

He spent a total of $1356 (B10)

How much did he save?

$3000 - $1356

--> =B5-B10

If the value of B4 is changed from 20 to 30, which cell(s) will change in the value(s) automatically?

Answer explanation

B5 and B12 will also change.

If hourly pay is increased to 30, salary will also increase.

If salary is increased, the amount of savings will also change.

The content in cell B8 is a/an _______ data.

• currency

• date

• numeric

• text

How many rows and columns are selected in the following spreadsheet?

• 3 rows and 3 columns

• 3 rows and 4 columns

• 4 rows and 3 columns

• 4 rows and 4 columns