wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel: basic understanding

Total questions: 13

Worksheet time: 7mins

Name
Class
Date
1.

The intersection of a column and row is a

a)

Connection Point

b)

Cell

c)

Box

d)

Insertion Point

2.

Numbers in a spreadsheet that will be used for calculations

a)

Values

b)

Text

c)

Functions

d)

Formulas

3.

The vertical parts (Up and down) of a spreadsheet that are labeled alphabetically

a)

Columns

b)

Rows

c)

Cells

d)

Boxes

4.

The editable settings in spreadsheet software that allow you to change the display of each cell

a)

Formulas

b)

Functions

c)

Formats

d)

None of the Above

5.

The individual "pages" inside a workbook

a)

Worksheet

b)

Workbook

c)

Worksite

d)

Worktab

6.
Why would you want to change the column width?
a)
To draw attention to the data in those cells.
b)
To make sure the column headings are always visible when scrolling.
c)
To make sure all of the information in the column is visible.
7.
You have decided to center the text within a cell. What have you done?
a)
Merged Cells
b)
Wrapped Text
c)
Changed Alignment
d)
Autofit Content
8.

What does the button in red mean?

a)

Align the text on the borders of the page

b)

Extend the content on the entire length of the cell.

c)

Group together the selected cells and center the content.

d)

None of the above

9.

Which of the following cursor allows you to select a range of cells

a)
b)
c)
d)
10.

Appears at the border of the column letters. Drag to widen or narrow the width of a column.

a)
b)
c)
d)
11.

The fill handle - used for copying formula or extending a data series.

a)
b)
c)
d)
12.

Used to select a whole row/column when positioned on the row number or column letter.

a)
b)
c)
d)
13.

What is the difference between a worksheet and a workbook?

a)

A worksheet is a workbook within a workbook

b)

A worksheet is a sheet within a workbook

c)

A worksheet has to be inserted into a workbook

d)

A worksheet is part of the cells in a workbook