wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheets - Lesson 1

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

You can automatically adjust a column width to "fit" the content by:

a)

clicking the column heading

b)

clicking the row heading

c)

double-clicking between the two column headings

d)

double-clicking between the two cells

2.

Combining multiple cells in your spreadsheet is called:

a)

formatting

b)

aligning

c)

merging

d)

mixing

3.

What special formatting can you use to set your information apart from the other cells on your spreadsheet?

a)

Currency formatting

b)

Date & time formatting

c)

Sorting & filtering

d)

Borders & color shading

4.

Instead of resizing your column to accommodate your content, what can you use to fit your content to the size of the cell?

a)

Paint formatting

b)

Text wrapping

c)

Filtering

d)

Sorting

5.

What can the Autofill handle do?

a)

Copy cell content and/or populate cells with series (pre-defined or sequential) of content

b)

Copy cell content

c)

Populate cells with series (pre-defined or sequential) of content

d)

Overwrite copied content

6.

What commands will change the amount of numbers shown to the right of the decimal point?

a)

Increase/Decrease Decimal

b)

Increase/Decrease Indent

c)

Align Left and Right

d)

Format Percent

7.

What formatting tool adds a dollar symbol, a comma separator and two default decimal places to a number?

a)

Percent

b)

Currency

c)

Comma

d)

Increase Decimal

8.

What keyboard shortcut will select all the cells in a spreadsheet?

a)

Shift + A

b)

Ctrl + A

c)

Alt + A

d)

Tab + A

9.

Using your mouse, you can click a single cell to select it or click and drag your pointer across a range of cells to select multiple cells. You can select random cells anywhere on the spreadsheet by holding down the ________ key and clicking each cell.

a)

Shift

b)

Ctrl

c)

Alt

d)

Enter

10.

When entering text into a cell, your spreadsheet program automatically aligns your text to:

a)

the left side of the cell

b)

the top of the cell

c)

the right side of the cell

d)

the bottom of the cell

11.

When entering numbers into a cell, your spreadsheet program automatically aligns your numbers to:

a)

the left side of the cell

b)

the top of the cell

c)

the right side of the ell

d)

the bottom of the cell

12.

How can users customize spreadsheets to only display specific criteria?

a)

Copy the data

b)

Filter the data

c)

Align the data

d)

Sort the dara

13.

Which of the following is the correct reference for a cell range?

a)

A2...E15

b)

F15-J28

c)

B2;F30

d)

A7:D20

14.

What keyboard shortcut always moves the cursor into cell A1?

a)

Shift + Home

b)

Shift + A

c)

Ctrl + Home

d)

Crtl + 1

15.

Which format would be recommended for a cell that contained the data 1/24/2015?

a)

Time

b)

Date

c)

Number

d)

Currency

16.

Which of the following will place data in a specific order?

a)

Sorting

b)

Centering

c)

Filtering

d)

Copying

17.

Which of the following is an example of a cell reference?

a)

Column C

b)

=SUM

c)

Row 1

d)

A5

18.

Spreadsheet columns are easily identified by:

a)

Roman numerals

b)

numbers

c)

letters

d)

colors

19.

Spreadsheet rows are easily identified by:

a)

numbers

b)

letters

c)

Roman numerals

d)

colors

20.

A spreadsheet program is used to store data in:

a)

a database

b)

a text document

c)

rows and columns

d)

letters and numbers