Sec 1 CPA WA3 Revision

Which is the most suitable use of a word processor?

• Calculating the total marks of a cpa test.

• Typing out the reflection for a learning journey.

• Drawing a picture of the Singapore flag.

• Recording a sound clip for an English assignment

Answer explanation

A word processor is used to create documents, usually to be printed out.

How many rows and columns are in the table shown?

• 3 rows and 3 columns

• 4 rows and 4 columns

• 4 rows and 3 columns

• 3 rows and 4 columns

Answer explanation

Rows are horizontal (side to side)

Columns are vertical (up and down)

How many cells have been merged?

• 1

• 2

• 3

• 4

What is the text alignment used in the text shown in the box?

• Left

• Right

• Center

• Justified

What has been done to Table 1 to obtain Table 2?

• Delete column

• Insert column

• Merge cells

• Unmerge cells

To use a formula, which of the following signs should be applied?

• #

• $

• !

• =

Answer explanation

In a spreadsheet, all formulas must begin with an '=' sign

What is the cell address of the selected cells?

• B3:D3

• B5:D5

• B3:D5

• D5:B3

Answer explanation

Cell address for a block of cells (range):

top left : bottom right

What is the formula in cell C7?

• =SUM(C3:C5)

• =C3-C5

• =B7*D7

• =B2:C7

Answer explanation

The SUM function is used to add up the values in cells. Another formula that could be used is =C3+C4+C5

What tool was used to create this graphic?

• difference

• union

• interpolate

• rotate

Which tool was used to change the graphic?

• Union

• Difference

• Interpolate

• ellipse

Answer explanation

union: join together

difference: cut away (like a cookie cutter)