Spreadsheets basics

What is the space within the black border?

• a cell

• a box

• a variable

• a column

When you type a formula, what symbol must it start with?

• !

• *

• +

• =

In a cell reference, for example B2, what does the letter refer to?

• The row the cell is in.

• The worksheet the cell is in

• The column the cell is in.

• The spreadsheet the cell is in.

In a cell reference, such as B2, what does the number stand for?

• the column the cell is in

• the worksheet the cell is in

• the row the cell is in

• the value of the cell

Mathematical calculations in a spreadsheet are called:

• words

• values

• formulas

• labels

Which of the following is an example of a multiplication formula?

• A-B

• =C10-B9

• 14 x 10 = 140

• =B2*B3

Which of the following is an example of an addition formula?

• =B4+D7

• 2+3+6=11

• F3*G7

• =B9/B6

What symbol is used to signify range ?

• +

• -

• :

• ;

Write the Formula for addition in Spreadsheet for C7, A5, B4 and D1

(Follow the order of numbers)

What is cell ?

• intersection of rows and columns

• another name of row

• another name of formula

• It is no term in spreadsheet