WorksheetsSpreadsheets basics
Total questions: 15
Worksheet time: 9mins
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)
(a)
What is cell ?
intersection of rows and columns
another name of row
another name of formula
It is no term in spreadsheet
Which is NOT a formula?
b2+b3+b4
=b1+b2+b3
=b4*c4
=b5/b7
Select all correct cell references for the yellow cells
D3:F4
D3, E3, F3, D4, E4, F4
3D:4F
3D, 3E, 3F, 4D, 4E, 4F
B:B references (a) _
