wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel

Total questions: 25

Worksheet time: 14mins

Name
Class
Date
1.

Which of the following is the icon for Microsoft Excel?

a)
b)
c)
d)
2.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

3.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
4.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

5.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
6.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
7.

A vertical line of cells is _____________.

a)

Maximum

b)

Minimum

c)

Column

d)

Formulas

8.

In Excel, it means Add

a)

+

b)

/

c)

\

d)

*

9.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
10.

Excel file is saved as a ____________

a)

document

b)

workbook

c)

worksheets

d)

presentation

11.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
12.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
13.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
14.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
15.
File, Menu, Edit, Insert are all located on the what?
a)
Page View
b)
Standard Toolbar
c)
Menu Bar
16.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
17.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
18.

Which of these symbols is used for multiply in Excel?

a)

\

b)

/

c)

*

d)

|

19.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

20.

What is the name of the cell that is colored blue?

a)

2

b)

B

c)

2B

d)

B2

21.

Without using mouse, which keyboard function keys can be used to travel from cell to cell in a spreadsheet?

a)

tab

b)

enter

c)

arrow keys

d)

all of the above

22.
By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.
a)
True
b)
False
23.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
24.

Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?

a)

=(C3+C5+C9)/3

b)

=SUM(C2:C10)

c)

=AVERAGE(C2:C10)

d)

=(C3+C5+C9)

25.

Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.

Which of the following suggestions would help Luisa?

a)

Make the cell wider

b)

Change the number formatting in the cell

c)

Change the font format in the cell

d)

Delete the data and re-type it