Font size
WorksheetsElectronic Spreadsheet
Total questions: 35
Worksheet time: 18mins
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
What is a spreadsheet?
a box in which you can enter a single piece of data.
vertical series of cells in a chart, table, or spreadsheet. They go up and down on the spreadsheet.
an electronic document in which data is arranged in the rows and columns
What is the formula bar?
The cells that go up and down on a spreadsheet.
The cells that go left to right on a spreadsheet.
The tool that lets you do math with the data on the spreadsheet.
What are headings on a spreadsheet?
series of cells laid out in a horizontal fashion in a table or spreadsheet.
The names of the types of data that is typed in the column or spreadsheet.
a box in which you can enter a single piece of data.
What are rows on a spreadsheet?
cells that go left to right on a spreadsheet.
cells that go up and down on a spreadsheet.
names of the data on a spreadsheet.
What are columns on a spreadsheet?
series of rows and columns in a spreadsheet that contains related data.
cells that go up and down on a spreadsheet.
cells that don't go anywhere.
What is a table on a spreadsheet?
cells that go left to right.
The names of the types of data that is typed in the column or spreadsheet.
series of rows and columns in a spreadsheet that contains related data.
What is the name of this cell?
D
9
D9
What is the name of this row?
Row A
Row 5
Row A5
What are the name of these columns?
C, D, E, F
A,B,C.D
ABC123
How do you name a cell from a spreadsheet?
Column first, then row
Row first, then column
By reading it.
What are the components of a worksheet?
Range
Text
Formula
Number
A worksheet consists of ____________ columns and ____________ of rows.
(a)
To go to specific cell, which key we need to press?
F3
F8
F5
F6
How many types of data we can be entered in Excel
5
8
3
Only 1
Which type of graph is shown in the picture?
(a)
