wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MS Excel Basics 1

Total questions: 20

Worksheet time: 39mins

Name
Class
Date
1.

Which of the following keys can be used to move around in a worksheet?

a)

Arrow keys

b)

Tab key

c)

Enter key

d)

All of the above

2.

A column is identified by which of the following?

a)

Number

b)

Letter

c)

Symbol

d)

None of the above

3.

Which of the following is not a correct cell address?

a)

2D

b)

A27

c)

BB15

d)

All of the above

4.

There is more than one command to insert and delete columns and rows in Excel.

a)

True

b)

False

5.

A row is identified by which of the following?

a)

Number

b)

Letter

c)

Symbol

d)

None of the above

6.

What is the function of the mouse pointer in the image?

a)

It allows you to select more than one cell

b)

It copies what is in the cell

c)

It allows you to widen the column

d)

It allows you to move the contents of a cell

7.

This is the name of the cell in the worksheet that is currently selected.

a)

Active cell

b)

Highlighted cell

c)

Formula cell

d)

Inactive cell

8.

What is the function of the mouse pointer in the image?

a)

It selects the entire column

b)

It selects the entire row

c)

It moves the entire column

d)

it moves the entire row

9.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

10.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

11.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
12.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
13.
_____ are vertical. 
a)
Rows
b)
Columns
14.
7) Study the image below this question.  What is the purpose of the two words circled in orange? 
 
 
 
 

a)
a) These represent the names of the individual workbooks you have saved.  If you click on the "Sales 2" tab it will open this workbook. 
b)
b) These reflect a selected range of cells in the worksheet.  If you click on "Sales 2" it will take you to the selected cell. 
c)
c) These represent worksheets that have been created in the workbook.  If you click on them they will take you to the different sheets. 
d)
d) This is the Name Box and represents named ranges in the worksheet.  If you click on "Sales 2", you can rename the range. 
15.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

16.

What is the file extension for Excel worksheets?

a)

.png

b)

.pptx

c)

.xlsx

d)

.docx

17.

Which command is used to insert a cut or copied selection to a cell or range of cells?

a)

Paste

b)

Document Properties

c)

Copy

d)

Range

18.

Content that has been cut or copied to the clipboard will have a marching dashed green border around it.

a)

TRUE

b)

FALSE

19.

What is the address of this cell?

a)

B3

b)

3B

c)

AB3

d)

None of them is correct

20.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row