wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Basics of spreadsheet

Total questions: 15

Worksheet time: 8mins

Name
Class
Date
1.

what is the first sentence ?

a)

AutoFill - allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text

b)

AutoFill can also be used to copy functions.

c)

.You can also alter text and numbers with this feature

2.

what is the second sentence ?

a)

AutoFill - allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text

b)

AutoFill can also be used to copy functions.

c)

.You can also alter text and numbers with this feature

3.

what is the third sentence ?

a)

AutoFill - allows you to quickly fill cells with repetitive or sequential data such as chronological dates or numbers, and repeated text

b)

AutoFill can also be used to copy functions.

c)

.You can also alter text and numbers with this feature

4.
Which tool should you use to create a shape with many equilateral sides?
a)
Polygon
b)
Brush
c)
Elipse
d)
Pen
5.
Which tool should you use to sample a colour and use it as a fill colour?
a)
Colour Picker
b)
Colour Chooser
c)
Paint Pot
d)
Paint Brush
6.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

7.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

8.

We can insert _______ through the ClipArt or from any other file.

a)

Text

b)

Pictures

c)

Coverpage

d)

Border

9.

The _______ consists of some pre-defined images.

a)

Pictures

b)

ClipArt

c)

Text

d)

Borders

10.

We cannot add textbox in Ms Word.

a)

True

b)

False

11.

What do you use to create a chart?

a)

A.Pie Wizard

b)

B.Excel Wizard

c)

C.Data Wizard

d)

D.Chart Wizard

12.

Which answer best describes a chart?

a)

A. A chart is most commonly used to display trends.

b)

B. A chart is most commonly used to display comparisons

c)

C. A chart is usually displayed in columns.

d)

D. A chart is usually displayed using lines.

13.

The group that contains the commands used for switching to another workbook view.

a)

Workbook view group

b)

Zoom group

c)

Show group

d)

Insert tab

14.

The keyboard shortcut that is used to move the cell pointer one screen up.

a)

Page up

b)

Up arrow

c)

Home

d)

Ctrl+Home

15.

The technique in moving the display without changing the position of the cell pointer.

a)

Scrolling

b)

Panning

c)

Zooming

d)

Showing