CPA_Sec 1_Excel

Which of the following describes the use of spreadsheets?

• To create audio clips.

• To create charts.

• To design logos.

• To prepare brochures.

How many rows and columns are there?

• 5 rows, 6 columns

• 6 rows, 5 columns

• 6 rows, 7 columns

• 7 rows, 8 columns

Which cell contain Jamie?

Which range of cells contain position of all students?

What is the format of the cells A3:A6?

• currency

• date

• number

• percentage

What is the alignment of the cells A2: C2?

• centre

• justify

• left

• right

Which cells in the spreadsheet have been merged?

Hadi wanted to use a spreadsheet to divide two numbers. He typed “125 / 5” into a cell and pressed the Enter key, but this did not return an answer. What could be the reason?

• He added spaces between the numbers.

• He should have used the division (÷) symbol.

• He should have used the equal (=) sign.

• He used the wrong font.

Sufen used a spreadsheet to sum up 3 numbers as shown. By typing “=B1+B2+B3” to obtain the answer, she is using ________________.

• cell adding

• cell addressing

• cell ranging

• cell referencing

Type in an alternate way to get the sum of the 3 number.