wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel

Total questions: 42

Worksheet time: 24mins

Name
Class
Date
1.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Database Software

d)

Presentation Software

2.

The letters in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

3.

The numbers in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

4.

An Excel file format extension is

a)

doc

b)

xlsx

c)

txt

d)

mp3

5.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
6.
What is the name given to the intersection of a row and a column in a spreadsheet? 
a)
cell
b)
block
c)
cube
d)
square
7.

Letters of the alphabet going across the top of the spreadsheet.

a)

Title Bar

b)

Column Labels

c)

Row Labels

d)

Status Bar

8.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Formula Bar

c)

Column Labels

d)

Row Labels

9.

The intersection of a column and a row is called a __________.

a)

Four-way Stop

b)

Formula Bar

c)

Cell

d)

Template

10.

These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.

a)

Row Bars

b)

Column Bars

c)

Scroll Bars

d)

Home Bars

11.

Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.

a)

Enter Keys

b)

Arrow Keys

c)

Piano Keys

d)

Tab Key

12.

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

13.

What icon do you choose to align the text at the top, middle, or bottom of a cell?

a)
b)
c)
d)
14.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

15.

The cell address of the highlighted cell is

a)

C

b)

4

c)

A4

d)

C4

16.

These are known as

a)

workbooks

b)

worksheets

c)

formula bar

d)

cell

17.

What does the indicated icon do in the red box?

a)

Apply underline

b)

Apply italic

c)

Make text bigger

d)

Apply bold

18.

What does the indicated icon in the red box do?

a)

Change number of active cells

b)

Change font colour

c)

Change font size

d)

Change the number of calculations

19.

Division symbol in spreadsheet.

a)

/

b)

+

c)

=

20.

Multiplication symbol in Microsoft Excel

a)

&

b)

*

c)

^

21.

When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.

a)

A) AutoSum

b)

B) Custom Fill

c)

C)Fill Handle

d)

D)Ctrl+C

22.

Which of the following is not a term of MS-Excel?

a)

A. Cells

b)

B. Rows

c)

C. Columns

d)

D. Document

23.

The basic unit of a worksheet into which you enter data in Excel is called a

a)

A.cell

b)

B.table

c)

C.box

d)

D.column

24.

The advantage of using a spreadsheet is:

a)

A. calculations can be done automatically.

b)

B. changing data automatically updates calculations

c)

C. more flexibility

d)

D. All of the above

25.

There are three types of data found in a spreadsheet.

a)

A. data, words, numbers

b)

B. equations, data, numbers

c)

C. words, numbers, labels

d)

D. numbers formulas, labels

26.

Pre-designed and formatted files called ______ help to create new worksheets quickly.

a)

Documents

b)

Templates

c)

Folders

d)

Cell Reference

27.

The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.

a)

Document

b)

Presentaion

c)

Publicaiton

d)

Worksheet

28.

The electronic spreadsheet you work in is contained in a file called a ______________ with the file extension .xlsx.

a)

Binder

b)

Folder

c)

Cabinet

d)

Workbook

29.

This area tells you the name of the project and the name of the program you have open.

a)

Status Bar

b)

Formula Bar

c)

Title Bar

d)

Quick Access Toolbar

30.

A cell that has a dark border around it.

a)

Jail Cell

b)

Sleepy Cell

c)

Active Cell

d)

Stem Cell

31.

The ________ contains a grid of columns and rows, the formula bar and the ribbon.

a)

Worksheet Window

b)

Document Window

c)

Presentation Window

d)

Publication Window

32.

Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.

a)

PO Box

b)

Cell Reference

c)

Status Bar

d)

Formula Bar

33.

A selection of two or more cells is known as a ____.

a)

Cluster

b)

Range

c)

Conglomorate

d)

Big mess

34.

Every Excel formula/equation must begin with _____.

a)

an equal sign

b)

please and thank you

c)

cell reference

d)

a prayer

35.

The ____ performs the arithmetic calculations in a formula.

a)

Calculator

b)

Grid-lines

c)

Status Bar

d)

Operator

36.

Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.

a)

Status Bar

b)

Scroll Bar

c)

Outside Window

d)

Formula Bar

37.

The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.

a)

Scroll Box

b)

Fill Handle

c)

Cell Reference

d)

Ribbon Tab

38.

A combination of numbers and symbols used to express a calculation.

a)

Active Cell

b)

Label

c)

Formula Bar

d)

Formula

39.

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

a)

Formula

b)

Formula Bar

c)

Cell Address

d)

Cell Grid

40.

An Excel file/Google sheet that contains individual worksheets. Also called a spreadsheet file.

a)

Workbook

b)

Drag

c)

File

d)

Headings

41.

A “page” within an Excel workbook that contains columns, rows, and cells.

a)

Workbook

b)

Worksheet

c)

Label

d)

Cell

42.

It is known as the spreadsheet application.

a)

MS Word

b)

MS Excel

c)

MS PowerPoint

d)

MS Publisher