wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MS EXCEL

Total questions: 40

Worksheet time: 1hrs 20mins

Name
Class
Date
1.

A row is...

a)

cells that run horizontally

b)

cells that run vertically

c)

cells that run diagonally

2.
A column is...
a)
cells that run horizontally
b)
cells that run vertically
c)
cells that run diagonally
3.
A cell is...
a)
where a row & column intersect
b)
cells that run vertically
c)
cells that run horizontally
4.
A spreadsheet shows us...
a)
a graphical representation of data
b)
calculations 
c)
cells organized by rows and columns and filled with data and information
5.
A workbook is...
a)
a graphical representation of data
b)
collection of spreadsheets
c)
intersection of a row & a column
6.
A graph show you...
a)
a graphical representation of data
b)
collection of spreadsheets
c)
intersection of a row & a column
7.
A formula allows you...
a)
to paste a picture
b)
color a cell
c)
to quickly make calculations 
8.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

9.

The intersection of a row and a column is called this.

a)

Active Cell

b)

Chart

c)

Column

d)

Row

10.

This symbol must be typed first to use a formula.

a)

Plus Sign

b)

Equal Sign

c)

FX

d)

Function

11.

In Excel, rows are identified by this

a)

Letters

b)

Numbers

12.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

13.

You are not able to open, save, rename and close a file in Excel the way you would in MS Word.

a)

TRUE

b)

FALSE

14.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

15.

To edit something on a worksheet you need to select this first?

a)

Columns

b)

Rows

c)

Cell Range

d)

Worksheet

16.

Columns go in what direction?

a)

Vertical

b)

Horizontal

17.

In Excel, columns are identified by the use of this?

a)

Letters

b)

Numbers

18.

Rows go in what directions?

a)

Vertical

b)

Horizontal

19.
When you click on a "sheet tab", it is located...
a)
at the top of the cells
b)
at the bottom of the workbook window which display the name of each worksheet
c)
only in the "File" menu
20.
When you "create a series", you are creating...
a)
a list of numbers, dates, times, or text
b)
a picture
c)
a block of adjacent cells in a worksheet
21.
A "cell reference" is the...
a)
location of the cell by row number & column letter
b)
tabs that appear at the bottom of the workbook 
c)
a block of cells
22.
The Quick Access Toolbar is:
a)
customizable
b)
found at the bottom of the screen
c)
found on the right side of the screen
d)
none of the above
23.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
24.
This is the:
a)
entry bar
b)
group
c)
name box
d)
none of the above
25.
The space on the spreadsheet where a column and a row intersect:
a)
cell
b)
name box
c)
entry bar
d)
none of the above
26.
This is the:
a)
title bar
b)
entry bar
c)
group
d)
none of the above
27.
What is this?
a)
active cell
b)
column
c)
cell
d)
none of the above
28.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
29.
The cell in a spreadsheet application in which data may be entered:
a)
cell reference
b)
name box
c)
active cell
d)
none of the above
30.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
31.
Unique address of a cell that is the coordinate of the intersection of a row and a column:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
32.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
33.
This is a:
a)
row
b)
column
c)
cell
d)
none of the above
34.
This is the:
a)
tab
b)
title bar
c)
group
d)
none of the above
35.
What part of the EXCEL screen is this:
a)
active cell
b)
cell
c)
name box
d)
none of the above
36.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
37.
This is a:
a)
cell
b)
row
c)
column
d)
none of the above
38.
This is a:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
39.
A vertical row of cells in a spreadsheet – identified by letters:
a)
row
b)
column
c)
tab
d)
none of the above
40.
This is the:
a)
entry bar
b)
title bar
c)
tab
d)
none of the above