wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Introduction to Spreadsheets

Total questions: 60

Worksheet time: 36mins

Name
Class
Date
1.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
2.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
3.
Which is an example of a cell reference is a spreadsheet?
a)
6C
b)
B9
c)
45
d)

Total

4.

Double-clicking between two columns will ____________ the column.

a)
delete
b)
copy
c)
resize
d)
fill
5.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
6.
Horizontal and vertical lines in a spreadsheet are called ____.
a)
rows
b)
graphs
c)
labels
d)
gridlines
7.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
8.
The location of a cell on a spreadsheet. It is a column letter followed by a row number.
a)
Cell range
b)
Cell reference
c)
Active cell
d)
Row
9.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
10.
A group of cells in a spreadsheet
a)
Cell reference
b)
Cell range
c)
Active cells
d)
Formulas
11.

The letters at the top of each worksheet are called:

a)

cell references

b)

row headers

c)

column headers

d)

ranges

12.

The numbers to the left of a worksheet are called:

a)

cell references

b)

column headers

c)

row headers

d)

ranges

13.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
d)

File

14.
Multiple pages in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
d)

Range

15.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
16.
What symbol do we use for multiplication in a Spreadsheet program? 
a)
/
b)
=
c)
^
d)
*
17.
What symbol do we use for division in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
=
18.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
19.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
20.
Which of the following is a formula that will add cells C9 and C10?
a)
=C9+C10
b)
C9+C10
c)
=C9:C10
d)
=C9*C10
21.
Which of the following is a formula that will divide cell A10 by cell A1?
a)
=A10/A1
b)
=A1/A10
c)
=A10*A1
d)
=Divide(A10:A1)
22.
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
23.
individual locations on a spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
24.
Individual pieces of information typed into the spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)

Data Entry

25.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
26.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
27.
Classification used for cells that contain text or for numbers that will not be used in calculations
a)
Label
b)
Value
c)
Formula
d)
Function
28.
This classification indicates that the data has the potential to be used in calculations.
a)
Label
b)
Value
c)
Formula
d)
Function
29.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)

Cell

30.

To find the total of a range of numbers B2 to G2, which of the following
would the formula's or function's calculation begin with?

a)
=
b)
SUM
c)

:

d)

B2

31.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
32.
A formula 
a)
is a rectangle where a column and a row meet
b)
goes up and down on the spreadsheet screen
c)
data type that will calculate a result. always starts with an "=" sign
d)
is software that processes and does calculations on the data entered by the user
33.
An icon is
a)
a number
b)
appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell
c)
one tab of spreadsheet gridlines
d)
a small picture
34.
The formula bar is
a)
a number
b)
appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell
c)
one tab of spreadsheet gridlines
d)
a small picture
35.
A value is
a)
a number
b)
appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell
c)
one tab of spreadsheet gridlines
d)
a small picture
36.
A worksheet is
a)
a number
b)
appears directly above the column headings of a spreadsheet and will display what has been typed into the active cell
c)
one tab of spreadsheet gridlines
d)
a small picture
37.
Gridlines are
a)
a graph / chart where the columns go up and down the graph/chart
b)
how it looks
c)
the across and up & down lines on the screen that separate cells in a spreadsheet
d)
a cell that is highlighted. cell that is being used now.
38.
The active cell is
a)
a graph / chart where the columns go up and down the graph/chart
b)
how it looks
c)
the across and up & down lines on the screen that separate cells in a spreadsheet
d)
a cell that is highlighted. cell that is being used now.
39.

Who would be most likely to use a spreadsheet every day as part of their job?

a)

Secretary

b)

Accountant

c)

Teacher

d)

Police

40.

What is the name of the cell marked with an orange rectangle?

a)

E6

b)

F5

c)

E5

d)

C8

41.

What does a cell address start with?

a)

Capital Letters

b)

numbers

c)

symbols

d)

logos

42.

What is the name of the spreadsheet application on Microsoft?

a)

Microsoft word

b)

Microsoft paint

c)

Microsoft excel

d)

Microsoft PowerPoint

43.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

44.

What is the label of the active cell?

a)

Y

b)

N

c)

Batman

d)

Superman

45.

What is the cell reference of the cell with label Coca-Cola inside?

a)

A3

b)

3A

c)

C5

d)

D7

46.
What are "words" classified as in a spreadsheet?
a)
values
b)
formulas
c)
labels
d)
cells
47.
What are "numbers" classified as in a spreadsheet?
a)
Labels
b)
Formulas
c)
Values
d)
Cells
48.
A row is a vertical reference in a spreadsheet.
a)
True
b)
False
49.

What is the general name given to the part of
this Spreadsheet highlighted in yellow?

a)

Row

b)

Column

c)

Letters

d)

Cells

e)

Spreadsheet

50.

What is the name of this part of the Spreadsheet highlighted in green in the middle of the screen?

a)

Row

b)

Column

c)

Letters

d)

Cells

e)

Spreadsheet

51.

What is the name of this part of a Spreadsheet highlighted in purple?

a)

Row

b)

Column

c)

Letters

d)

Cell

e)

Spreadsheet

52.

How do we call the text in bold in this spreadsheet?

a)

Values

b)

Columns

c)

Capitals

d)

Labels

53.

What do we call the entries in this spreadsheet highlighted in orange?

a)

Price

b)

Items

c)

Labels

d)

Values

54.

How do we identify the columns in a Spreadsheet

a)

With numbers

b)

With letters

c)

With a code

d)

With colours

55.

This part of MS Excel window is the _______.

a)

TITLE BAR

b)

MENU BAR

c)

FORMULA BAR

d)

TOOL BAR

56.

The part of the spreadsheet circled in RED is the _________.

a)

Toolbar

b)

Title Bar

c)

Formula Bar

d)

Menu Bar

57.

Which one is the FORMULA BAR?

a)
b)
c)
d)
58.

A range is a -

a)

Group of cells in a powerpoint

b)

Group of cells in workbook

c)

Group of cells in a notebook

d)

Group of cells in a worksheet

59.

Example of Arithmetic Operators -

a)

+

b)

=

c)

&

d)

:

60.

A formula contains -

a)

Cell address and Operators

b)

Cell range and Operators

c)

Function and Operators

d)

Cell reference and Operators

Similar Resources on Wayground

EXCEL

60 questions

EXCEL

quiz

Worksheet

•

University - Professi...

UTS Cloud Computing Gasal 20-21

60 questions

UTS Cloud Computing Gasal 20-21

quiz

Worksheet

•

University

MdExm 2024-2025 S1

60 questions

MdExm 2024-2025 S1

quiz

Worksheet

•

University

simdig pintar

57 questions

simdig pintar

quiz

Worksheet

•

10th Grade

PRELIM EXAMINATION 1B

57 questions

PRELIM EXAMINATION 1B

quiz

Worksheet

•

University

Excel Av. 15

60 questions

Excel Av. 15

quiz

Worksheet

•

6th - 8th Grade

Tin học 9. Ôn tập (t63)

64 questions

Tin học 9. Ôn tập (t63)

quiz

Worksheet

•

9th Grade

Power Point Pre-Assessment

65 questions

Power Point Pre-Assessment

quiz

Worksheet

•

6th - 8th Grade