wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel

Total questions: 25

Worksheet time: 15mins

Name
Class
Date
1.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

2.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

3.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

4.

This is the:

a)

title bar

b)

formula bar

c)

group

d)

none of the above

5.
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
6.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc

d)

$A$1, $A$2, etc.

7.

Which feature helps to automatically fill a series like 1, 2, 3, 4?

a)

Merge Cells

b)

Auto Fill

c)

Cell Style

d)

Format Painter

8.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

9.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

10.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
11.
This is a:
a)
tab
b)
ribbon
c)
group
d)
none of the above
12.
Can be used travel from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
13.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

14.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

15.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=( )Sum

d)

=Sum( )

16.

For multiplying numbers in A1 AND B1,you use the following formula

a)

=A1/B1

b)

=A1*B1

c)

A1%B1

d)

A1*B1

17.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
18.
Numbers in Excel is automatically aligned  ____.
a)
Right
b)
Left
c)
Center
d)
Justify
19.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
20.
The area within the red box is called
a)
Active Cell
b)
Fill Handle
c)
Cell
d)
Row
21.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

22.

What is the file extension of a Microsoft Excel file?

a)

.docx

b)

.pptx

c)

.xlsx

d)

.pdf

23.

A spreadsheet is made up of:

a)

Pictures and videos

b)

Charts only

c)

Columns and rows

d)

Slides

24.

Values in Excel are usually:

a)

Text only

b)

Displayed on the left

c)

Numbers and calculations

d)

Always colored

25.

Which shortcut starts a new line within the same cell (Windows)?

a)

Ctrl + Enter

b)

Shift + Enter

c)

Alt + Enter

d)

Tab + Enter