wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Electronic Spreadsheet

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

Option to print the document so that the height of the page is less than its width

a)

Portrait

b)

Landscape

2.

In Word Processing text formatting is available

a)

True

b)

False

3.

What is the column header name for 14th Column

a)

D

b)

E

c)

X

d)

N

4.

In a spreadsheet, Rows move in ___________ direction.

a)

Vertical

b)

horizontal

c)

diagonal

5.

A _________ is the intersection of a row and column.

a)

box

b)

cell

c)

pointer

6.

_____________displays the contents of active cell.

a)

Tool bar

b)

Address bar

c)

Formula bar

d)

Alignment bar

7.

Columns in MS Excel ranges from _____ to ______

a)

A to XFD

b)

A to Z

c)

A to BZ

d)

A to WFD

8.

What is the file extension for MS Excel worksheet file ?

a)

.doc

b)

.html

c)

.exl

d)

.xlsx

9.

A __________ is a collection of multiple worksheets.

a)

Workbook

b)

Interface

c)

Cell

10.

What will be the cell address of the cell formed by the intersection of the 5th Column and 8th Row

a)

F8

b)

E8

c)

D8

d)

A8

11.

In a spreadsheet, a column is denoted by ___________

a)

symbols

b)

numbers

c)

letters

12.

In a spreadsheet, all formulae must begin with _______ sign.

a)

#

b)

=

c)

$

d)

&

13.

To count only numerical data's, _________ function is used.

a)

COUNTIF

b)

COUNTA

c)

COUNTBLANK

d)

COUNT

14.

To count both numbers and text based data's, _________ function is used.

a)

COUNT

b)

COUNTIF

c)

COUNTA

d)

COUNTBLANK

15.

What is the column header name for 27th Column

a)

Z

b)

AB

c)

AA

d)

BA

16.

In a Spreadsheet(MS Excel), Column next to column "AZ" is ___________

a)

AA

b)

BB

c)

BA

d)

A

17.

In a spreadsheet, Rows are denoted by Letters ?

a)

True

b)

False

18.

In Text Editor Text formatting is available

a)

True

b)

False

19.

Notepad is an example of Word Processor

a)

True

b)

False

20.

The most widely used word processing software in late 1970s was

a)

MS Word

b)

Libre office

c)

AppleWorks

d)

WordStar