wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Basics

Total questions: 35

Worksheet time: 22mins

Name
Class
Date
1.

What are the individual rectangles on a worksheet called?

a)

Rows

b)

Columns

c)

Cells

d)

Formulae

2.

A vertical line of cells in a spreadsheet is a what?

a)

Row

b)

Column

3.

A horizontal line of cells in a spreadsheet is a what?

a)

Row

b)

Column

4.

How are columns labelled on a worksheet?

a)

Letters

b)

Numbers

5.

How are rows labelled on a worksheet?

a)

Letters

b)

Numbers

6.

If you wanted to change the colour of the text inside a cell, which tool would you use?

a)

Text colour

b)

Fill colour

c)

Borders

d)

Bold

7.

If you wanted one cell or a number of cells to stand out from the rest which tool could you use?

a)

Bold

b)

Fill Colour

c)

Currency

d)

Borders

8.

What do all formulae start with in a spreadsheet?

a)

+

b)

/

c)

*

d)

=

9.

Something that automatically calculates something for you using the data in cells is a:

a)

Formula

b)

Formatting

10.

Which mathematical operator (symbol) would you use if you are adding the values in cells together?

a)

/

b)

-

c)

+

d)

=

11.

Which mathematical operator (symbol) would you use to multiply the values in two cells together?

a)

/

b)

-

c)

*

d)

=

12.

If you wanted to add the values in four consecutive cells together which function would you use?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

13.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
14.
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
15.
This function determines the average of the range of cells 
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
16.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
17.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
18.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
19.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
20.
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)
21.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
22.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
23.

Which of the following is an example of a cell reference?

a)

Column C

b)

=SUM

c)

Row 1

d)

A5

24.

What is the purpose of spreadsheets?

a)

To present information on different engaging slides

b)

To deliver a speech to a crowd

c)

To perform basic and complex mathematical calculations in an organized way

d)

To excel your written work

25.

Which formula would be used to calculate the largest number?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

26.

What are spreadsheets used for?

a)

To perform powerful calculations

b)

Make graphs and charts

c)

Analyse patterns in the data

d)

To store information and data

27.

Worksheets appear as tabs at the bottom of the spreadsheet.

a)

True

b)

False

28.

What is the correct order for the parts that make up a Cell Reference?

a)

Letter then Number

b)

Number then Letter

29.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
30.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
31.

The formula in C1 is replicated to cells C2 and C3. What value will be shown in cell C3?

a)

28

b)

22

c)

18

d)

32

32.

The formula in C1 is replicated to cells C2 and C3. What value will be shown in cell C3?

a)

49

b)

48

c)

26

d)

24

33.

An example of an absolute cell reference is: =$A$2

a)

True

b)

False

34.

A relative cell reference will not change when a formula is replicated.

a)

True

b)

False

35.

What is this?

a)

A document

b)

A spreadsheet

c)

I don't know :D

Similar Resources on Wayground

ADOBE FLASH CS6

35 questions

ADOBE FLASH CS6

quiz

Worksheet

•

6th - 7th Grade

he

38 questions

he

quiz

Worksheet

•

8th - 10th Grade

UH 1 TIK

30 questions

UH 1 TIK

quiz

Worksheet

•

7th Grade

ITP 7_Q1_THEORY TEST

35 questions

ITP 7_Q1_THEORY TEST

quiz

Worksheet

•

7th Grade

Chapter 12 Test Review

30 questions

Chapter 12 Test Review

quiz

Worksheet

•

7th - 12th Grade

Computing Fundamentals Pt 2

35 questions

Computing Fundamentals Pt 2

quiz

Worksheet

•

6th - 8th Grade

Programming Techniques

30 questions

Programming Techniques

quiz

Worksheet

•

8th - 10th Grade

Simple Machines Quiz 1

31 questions

Simple Machines Quiz 1

quiz

Worksheet

•

7th - 9th Grade