wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Topic 2

Total questions: 11

Worksheet time: 22mins

Name
Class
Date
1.

Combines cells into one large cell but deletes all contents except the first (Upper Left) cell of the group.

a)

Multiple Lines of Text

b)

Merge Cells

c)

Move Text

d)

Autofill Series

2.

Highlight the text with your mouse and apply changes from the “font” group just as you would in Word

a)

Copy Text

b)

Formatting

c)

Repeat Text

d)

Autofill Series

3.

Only deletes the data in the cells, the cells will remain in place.

a)

Clearing Content

b)

Copy Text

c)

Unmerge Cells

d)

Autofill Series

4.

Removes the cells and the remaining cells around the ones removed will shift into the space left.

a)

Unmerge Cells

b)

Copy Text

c)

Deleting

d)

Clearing Content

5.

Select a cell that you want, hover your mouse on the green square (or blue dot in Google Sheets), drag “plus sign” in any direction to repeat.

a)

Multiple Lines of Text

b)

Typing

c)

Deleting

d)

Repeat Text

6.

Select a cell(s) that you want, R click “Copy”, move to a new cell, R click clipboard icon.

a)

Unmerge Cells

b)

Copy Text

c)

Formatting

d)

Autofill Series

7.

Select a cell, get a four-headed arrow, drag the text, release the mouse to drop the text.

a)

Move Text

b)

Clearing Content

c)

Autofill Series

d)

Multiple Lines of Text

8.

Select two cells with data that you want, hover your mouse on the green square, drag “plus sign” in any direction to continue the series

a)

Clearing Content

b)

Formatting

c)

Autofill Series

d)

Unmerge Cells

9.

Select the cell by clicking in it then type directly in the cell or type in the formula bar

a)

Typing

b)

Formatting

c)

Copy Text

d)

Autofill Series

10.

Splits a merged cell back into several separate cells.

a)

Clearing Content

b)

Move Text

c)

Unmerge Cells

d)

Multiple Lines of Text

11.

When typing in a cell, hold down “Alt” and press “Enter” on the keyboard at the same time.

a)

Formatting

b)

Repeat Text

c)

Multiple Lines of Text

d)

Merge Cells