Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Topic 3

Total questions: 11

Worksheet time: 22mins

Name
Class
Date
1.

Allows you to turn borders on or off of a particular part of a cell

a)

Drag

b)

Borders Button

c)

Expand the selection

d)

Shading

2.

A method of adjusting column width with use of the mouse and the double headed arrow pointer.

a)

Drag

b)

Autofit

c)

Borders Button

d)

Dialogue Box

3.

Use the “bucket” on the Home tab to change fill color

a)

Pattern

b)

Expand the selection

c)

Shading

d)

Borders Button

4.

Helps rearrange your data so you can use it more efficiently.

a)

Drag

b)

Dialogue Box

c)

Borders Button

d)

Sorting

5.

Use “Format” in the Cell group of the Home tab to apply a combination of colors to fill a cell

a)

Autofit

b)

Expand the selection

c)

Pattern

d)

Shading

6.

A method of adjusting column width where one cell of the column is resized just wide enough to hold the text in the cell you selected.

a)

Autofit

b)

Dialogue Box

c)

Pattern

d)

Border Tab

7.

Excel will keep the data touching your column attached to the cell it is currently touching and sort them together.

a)

Drag

b)

Expand the selection

c)

Dialogue Box

d)

Borders Button

8.

Double-click the right edge of a column’s heading and the column width changes to be as wide as the longest text in any cell in the column.

a)

Sorting

b)

Continue with the current selection

c)

Border Tab

d)

Autofit All

9.

Use “Format” in the Cell group of the Home tab to select the border style and color.

a)

Border Tab

b)

Autofit All

c)

Continue with the current selection

d)

Auto fill

10.

Excel will ONLY sort the column you selected and the columns attached to it will remain as they are.

a)

Autofit All

b)

Shading

c)

Sorting

d)

Continue with the current selection

11.

A pop up window will allow you to type in the exact width you want a column’s cell to be.

a)

Dialogue Box

b)

Pattern

c)

Autofit

d)

Expand the selection