wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel

Total questions: 20

Worksheet time: 20mins

Name
Class
Date
1.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Column Labels

c)

Row Labels

2.

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

a)

Column Labels

b)

Row Labels

c)

Status Bar

3.

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

a)

Formula Bar

b)

Cell

c)

Template

4.

The cell address of the highlighted cell is

a)

C

b)

A4

c)

C4

5.

An Excel file is generally called a .......................................... .

a)

workbook

b)

document

c)

presentation

6.

Select the correct example of a cell address:

a)

3611  

b)

901

c)

98A

d)

A25

7.

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

a)

&

b)

=

c)

#

d)

*

8.

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

a)

Workbook

b)

Drag

c)

File

d)

Headings

9.

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

a)

Workbook

b)

Worksheet

c)

Label

d)

Cell

10.

When creating a chart in Excel, what is the first thing you need to do?

a)

Select the data to be graphed.

b)

Select the Insert Tab

c)

Choose a chart from the ribbon

d)

Double click the active cell

11.
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
12.

A pie graph is a visual representation of what?

a)

Values change over time.

b)

comparison of a piece of data to the whole group

c)

a categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

13.

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

a)

A. Insert

b)

B. Copy

c)

C. Undo

d)

D. Replace

14.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

15.

By default the text data is________ aligned in cell.

a)

Left

b)

Center

c)

Right

d)

Bottom

16.

By default the number data is __________ aligned in cell.

a)

Right

b)

Center

c)

Top

d)

Left

17.

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

a)

Document

b)

Presentaion

c)

Publicaiton

d)

Worksheet

18.
Which button allows you to copy cell formats from one cell to another?
a)
Enter
b)
Autofit
c)
Format Painter
d)
Esc
19.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
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