NEW
Font size
WorksheetsElectronic Spreadsheet
Total questions: 20
Worksheet time: 10mins
Option to print the document so that the height of the page is less than its width
Portrait
Landscape
In Word Processing text formatting is available
True
False
What is the column header name for 14th Column
D
E
X
N
In a spreadsheet, Rows move in ___________ direction.
Vertical
horizontal
diagonal
A _________ is the intersection of a row and column.
box
cell
pointer
_____________displays the contents of active cell.
Tool bar
Address bar
Formula bar
Alignment bar
Columns in MS Excel ranges from _____ to ______
A to XFD
A to Z
A to BZ
A to WFD
What is the file extension for MS Excel worksheet file ?
.doc
.html
.exl
.xlsx
A __________ is a collection of multiple worksheets.
Workbook
Interface
Cell
What will be the cell address of the cell formed by the intersection of the 5th Column and 8th Row
F8
E8
D8
A8
In a spreadsheet, a column is denoted by ___________
symbols
numbers
letters
In a spreadsheet, all formulae must begin with _______ sign.
#
=
$
&
To count only numerical data's, _________ function is used.
COUNTIF
COUNTA
COUNTBLANK
COUNT
To count both numbers and text based data's, _________ function is used.
COUNT
COUNTIF
COUNTA
COUNTBLANK
What is the column header name for 27th Column
Z
AB
AA
BA
In a Spreadsheet(MS Excel), Column next to column "AZ" is ___________
AA
BB
BA
A
In a spreadsheet, Rows are denoted by Letters ?
True
False
In Text Editor Text formatting is available
True
False
Notepad is an example of Word Processor
True
False
The most widely used word processing software in late 1970s was
MS Word
Libre office
AppleWorks
WordStar
