Download PDF
Free download in PDF Spreadsheet Objective Type Questions and Answers for competitive exams. These short objective type questions with answers are very important for Board exams as well as competitive exams. These short solved questions or quizzes are provided by Gkseries.
(21)
Which of the following isn’t a part of a spreadsheet?
[A]
row number
[B]
column number
[C]
column letter
[D]
cell address
(2)
Spreadsheets cannot:
[A]
do calculations
[B]
create graphics
[C]
plot graphs
[D]
plot charts
(23)
An easier way to set up complicated calculations.
[A]
Decimals
[B]
Fractions
[C]
Booleans
[D]
Functions
(24)
The cell that is in use.
[A]
Active cell
[B]
Highlighted cell
[C]
Main cell
[D]
Formula cell
(25)
The placement of information within a cell at the left edge, right edge, or centered is :
[A]
Alignment
[B]
Identification
[C]
Indentation
[D]
Placement
(26)
A change in the appearance of a value or label in a cell.
[A]
Alteration
[B]
Format
[C]
Indentation
[D]
Design
(27)
An entry in a spreadsheet cell representing wages or test scores is most likely a
[A]
label
[B]
value
[C]
formula
[D]
calculation
(28)
Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as
[A]
decoration
[B]
data appearance
[C]
functions
[D]
charting
(29)
In a computer, element which is not a part of chart is
[A]
plot area
[B]
fill handler
[C]
series
[D]
chart area
(30)
In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is
[A]
7
[B]
12
[C]
1.5
[D]
None
31
In a computer spreadsheet, first part of number format describes
[A]
text values
[B]
negative number
[C]
positive number
[D]
zero values
32
Extension of computer MS-Excel file is
[A]
wrd
[B]
xls
[C]
doc
[D]
jpg
33
Cell in a computer spreadsheet that contain a formula or function will show
[A]
formula or function
[B]
cell's address
[C]
resulting display value
[D]
range
Answer: resulting display value
34
In a computer spreadsheet, function which is used to count numbers of entries in given range is called
[A]
length
[B]
counter
[C]
counting
[D]
count
35
Main window in a computer spreadsheet is called
[A]
work sheet
[B]
work
[C]
account book
[D]
work book
36
In a computer, fourth part of number format describes
[A]
text values
[B]
positive number
[C]
negative number
[D]
zero values
37
In a computer spreadsheet, each cell contain a
[A]
formula
[B]
value
[C]
label
[D]
all of these
38
In a computer spreadsheet, number of arguments which SUM function require are
[A]
4
[B]
3
[C]
1
[D]
None
39
In a computer spreadsheet, SUM, AVERAGE, MIN and MAX are examples of
[A]
functions
[B]
calculations
[C]
formulas
[D]
relative addressing
40
In a computer spreadsheet, cell range A3 through G3 should be keyed in as
[A]
A3:G3
[B]
A3 to G3
[C]
A3-G3
[D]
A3?.G3
Take Mock Tests