wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel

Total questions: 20

Worksheet time: 11mins

Name
Class
Date
1.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

2.

A four-sided arrow does what in Excel?

a)

copies the contents of one cell to others around it

b)

moves the contents of one cell to another location

c)

selects the cell

3.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

4.

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

a)

cell bar

b)

formula bar

c)

status bar

d)

name box

5.

If you click a number at the left of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

6.

Where are the two places to find the autosum feature?

a)

Home ribbon

b)

Insert ribbon

c)

Function ribbon

d)

Formulas ribbon

7.

To exit an active formula, you always click out of the current cell?

a)

True

b)

False

8.

If the following was entered into a cell, what would appear in that cell? sum(A1:B3)

a)

the sum of A1 through B3

b)

sum(A1:B3)

c)

nothing

9.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

10.

If you change the value in a cell then the associated graph will NOT change.

a)

True

b)

False

11.

Select all of the following that are available under the Autosum button:

a)

sum

b)

minimum

c)

average

d)

maximum

e)

division

12.

What are the two (2) ways to display a spreadsheet in Microsoft Excel?

a)

fixed

b)

value

c)

variable

d)

formula

13.

If you center or merge and center it does exactly the same thing.

a)

True

b)

False

14.

What tool allows you to capture the formatting in one location and easily format other cells the same way?

a)

copy and paste

b)

cut and paste

c)

format painter

d)

alignment tool

15.

What is the difference in the following numbers: 1/3, .33, 33%

a)

the value

b)

the format

c)

the function

16.

What happens to a spreadsheet when you use the Ctrl~ command on a PC?

a)

calculates the values in formulas

b)

autofits the columns and rows

c)

displays the formulas

d)

nothing

17.

Which page orientation makes the sides longer than the top and bottom?

a)

landscape

b)

portrait

c)

fixed

d)

variable

18.

Margins are the white space on the spreadsheet where nothing prints.

a)

True

b)

False

19.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

20.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping