Spreadsheet Terminology
Spreadsheet terminology is confusing as it is a combination of formulae and presentation diction. This quiz comprises of a bunch of questions that will help you to understand the terminology used. All the best.
- 1.
What is the name of the square or box in a spreadsheet called?
- A.
Block
- B.
Cell
- C.
Brick
- D.
Wall
- E.
Cement
Correct Answer
B. Cell -
- 2.
What is the name of a cell that has a thick black line around it?
- A.
Formula
- B.
Active Cell
- C.
Addition
- D.
Cell Reference
- E.
Range
Correct Answer
B. Active Cell -
- 3.
What is the correct way to start a formula?
- A.
+
- B.
-
- C.
=
- D.
/
- E.
(
Correct Answer
C. = -
- 4.
What is the correct formulae for adding 2 cells together?
- A.
A1+A2
- B.
+A1/A2
- C.
=A1+A2
- D.
(A1+A2)
- E.
A1-A2
Correct Answer
C. =A1+A2 -
- 5.
What does autofill do?
- A.
Fills up the cells with colour
- B.
Adds figures in a row or column
- C.
Formats the data to currency
- D.
Calculates the remaining rows or columns
- E.
Copies cells
Correct Answer
D. Calculates the remaining rows or columns -
- 6.
How do you create an absolute cell reference?
- A.
Put a fence around it
- B.
Use the Format menu
- C.
Use a formula
- D.
Add £ signs before the cell
- E.
Add $ signs to the cell reference
Correct Answer
E. Add $ signs to the cell reference -
- 7.
Put this formula in the correct order (sumA1:A5=)
- A.
(=sum)A1:A5
- B.
Sum=(A1:A5)
- C.
(A1:A5)sum=
- D.
=sum(A1:A5)
- E.
=(A1:A5)sum
Correct Answer
D. =sum(A1:A5) -
- 8.
What is the name of the cell in column G row 20?
- A.
02G0
- B.
20G
- C.
G20
- D.
0G2
- E.
CG20
Correct Answer
C. G20 -
- 9.
Spreadsheets can be used to see different scenarios to see what might happen. What is this called?
- A.
Testing
- B.
Working Out
- C.
Estimating
- D.
Planning
- E.
Modelling
Correct Answer
E. Modelling -
- 10.
What is a combination of column letter and a row number?
- A.
Cell Name
- B.
Rows
- C.
Columns
- D.
A Meeting Place
- E.
All of the above
Correct Answer
A. Cell Name -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Sep 26, 2017Quiz Edited by
ProProfs Editorial Team -
Nov 09, 2009Quiz Created by
Ledwards
Back to top