wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheet Overview (Basic)

Total questions: 20

Worksheet time: 20mins

Name
Class
Date
1.

What software do we use to create spreadsheet?

a)

Word

b)

PowerPoint

c)

Publisher

d)

Excel

2.

What is the purpose of spreadsheet?

a)

To present information on different engaging slides

b)

To deliver a speech to a crowd

c)

To perform basic and complex mathematical calculation

d)

To excel your research papers and citations

3.

Each box on a spreadsheet is called a ________________.

a)

Box

b)

Cell

c)

Row

d)

Column

4.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

5.

Cells that run vertically on a spreadsheet

a)

Row

b)

Column

6.

The letter at the top of each column is called a:

a)

Cell reference

b)

Column header

c)

Row header

d)

Range

7.

The number to the left of a row is called a:

a)

Cell reference

b)

Column header

c)

Row header

d)

Range

8.

The cell that is currently selected

a)

Cell reference

b)

Cell range

c)

Label

d)

Active cell

9.

A single page in Excel is called a:

a)

Worksheet

b)

Workbook

10.

Multiple pages in Excel is called a:

a)

Worksheet

b)

Workbook

11.

Which is an example of a cell reference in a spreadsheet?

a)

6C

b)

45

c)

fall

d)

B9

12.

Double-clicking between two columns will _______________ the column.

a)

Delete

b)

Resize

c)

Copy

d)

Fill

13.

Format cells as _______________ when working with amounts of money.

a)

Scientific

b)

Percent

c)

Currency

d)

Number

14.

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

a)

Text colour

b)

Borders

c)

Fill colour

d)

Bold

15.

A group of cells is called _______________.

a)

Range

b)

Autosum

c)

Row

d)

Column

16.

Place where you can rename each worksheet is called _______________. It is located at the bottom of the worksheet window.

a)

Name Box

b)

Formula

c)

Chart

d)

Sheet Tab

17.

SUM, AVERAGE, MAX and IF are examples of what?

a)

Formulae

b)

Function

c)

Tables

d)

Statistical Tools

18.

When you key in a formulae or function in a spreadsheet, what do you key in first?

a)

Addition symbol

b)

Hashtag symbol

c)

Equal symbol

d)

Asterisk symbol

19.

In Excel, what is this button used for?

a)

To change the border colour

b)

To change the colour of an image

c)

To change the font colour

d)

To fill the cell with a colour

20.

Which tab in Excel has charts and tables?

a)

Home tab

b)

Insert tab

c)

File tab

d)

View tab