wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel

Total questions: 25

Worksheet time: 15mins

Name
Class
Date
1.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
2.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
3.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
4.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
5.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
6.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
7.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
8.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

9.

You can use the auto-sum key to subtract numbers.

a)

True

b)

False

10.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
11.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
12.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

13.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

14.

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

15.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Bottom left of spreadsheet document

c)

Top right of spreadsheet document

d)

Top left of spreadsheet document

16.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

17.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
18.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
19.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
20.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
21.

How do you insert a new row?

a)

click the row heading where you want to insert the new row and select Insert from the home tab

b)

Select the row heading where you want to insert the new row and select Edit >Row from the menu

c)

Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

d)

All of the above

22.

What is it called to have 3 cells become 1 cell?

a)

wrap text

b)

merge and center

c)

Fill Color

d)

joining cells

23.

What is it called when text goes underneath itself in one single cell?

a)

Wrap text

b)

Merge and center

c)

Formula Bar

d)

Auto Sum Button

24.

What is this picture called?

a)

Auto Sum

b)

Equation

c)

Formula Bar

d)

Answer Bar

25.

What is the name of this? (Red Square)

a)

Font size

b)

Wrap Text

c)

Merge

d)

Alignment