Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel

Total questions: 30

Worksheet time: 10mins

Name
Class
Date
1.

An application that organizes data into cells, rows and columns is classified as a

a)

Database

b)

Spreadsheet

c)

Word Processor

d)

Text Editor

2.

The first electronic spreadsheet that was made for the Macintosh PC was

a)

Corel Quattro Pro

b)

Lotus 1-2-3

c)

OpenOffice.org Calc

d)

VisiCalc

3.

The spreadsheet program included in MS Office Productivity Suite is

a)

Access

b)

Excel

c)

PowerPoint

d)

Word

4.

Lotus 1-2-3 was invented by

a)

Bill Gates

b)

Bob Frankston

c)

Dan Bricklin

d)

Mitchell Kapor

5.

The person considered as the “Father of the Spreadsheet” is

a)

Bob Frankston

b)

Dan Bricklin

c)

Steve Jobs

d)

Thomas Watson

6.

A file containing one or more worksheets is called

a)

Document

b)

Text file

c)

Workpad

d)

Workbook

7.

An on-screen spreadsheet that contains various cells in columns and rows is known as

a)

Blank Page

b)

Spread

c)

Tab

d)

Worksheet

8.

The intersection of a row and column is called

a)

Cell

b)

Coordinate

c)

Grid

d)

Space

9.

A currently selected cell is called

a)

Active Cell

b)

Blank Cell

c)

Cell A1

d)

First Cell

10.

The part of the Excel window that displays the cell reference of the active cell is the

a)

Formula Bar

b)

Formula Box

c)

Name Box

d)

Status Bar

11.

There are 1,048,576

a)

Column Headers

b)

Column Markers

c)

Row Headers

d)

Row Markers

12.

The letters A to XFD above the worksheet are called

a)

Column Headers

b)

Column Markers

c)

Row Headers

d)

Row Markers

13.

The coordinate of the intersecting row and column is called

a)

Cell Reference

b)

Cell Grid

c)

Cell Name

d)

Cell Marker

14.

The faint lines around the cells that distinguishes cells on the worksheet are called

a)

Gridlines

b)

Margins

c)

Guidelines

d)

Guides

15.

The total number of cells in Excel 2016 spreadsheet is

a)

65,536

b)

1,048,576

c)

16,777,216

d)

17,179,869,184

16.

To edit the contents of a cell press

a)

F2

b)

F3

c)

F4

d)

F5

17.

To close the current workbook, press

a)

Ctrl+W

b)

Ctrl+X

c)

Ctrl+Y

d)

Ctrl+Z

18.

The part of the worksheet that runs horizontally and are identified by numbers are called

a)

Cell

b)

Column

c)

Gridline

d)

Row

19.

The part of the worksheet that runs vertically and are identified by letters are called

a)

Cell

b)

Column

c)

Gridline

d)

Row

20.

The total number of columns in Excel is

a)

16,384

b)

1,048,576

c)

16,777,216

d)

17,179,869,184

21.

Pressing Shift+Tab key moves the cell pointer one cell to the left.

a)

True

b)

False

22.

The cell pointer will move one cell up when you press Shift+Enter.

a)

True

b)

False

23.

Pressing the Tab key moves the cell pointer one screen to the right.

a)

True

b)

False

24.

The End key is used to move the cell pointer to the last cell on the column.

a)

True

b)

False

25.

Ctrl+PgDn goes down one screen.

a)

True

b)

False

26.

Press F6 to enter a specific cell address that you want to go to.

a)

True

b)

False

27.

The Home key is used to move the cell pointer to the first cell on the row.

a)

True

b)

False

28.

Several rows will be selected if you click and drag across the row headers.

a)

True

b)

False

29.

To resize a column, point on the grid line between the cells, then click and drag.

a)

True

b)

False

30.

AutoFit automatically fits the cell on the exact length of text only but not its size.

a)

True

b)

False