Download PDF
Free download in PDF Spreadsheet Multiple Choice 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.
(1)
In a spreadsheet, letters are used to represent _____________
[A]
Columns
[B]
Blocks
[C]
Rows
[D]
Cells
(2)
A numeric data analysis tool that allows us to create a computerized ledger.
[A]
Mathematical Package
[B]
Graphics package
[C]
Spreadsheet package
[D]
Word processing package
Answer: Spreadsheet package
(3)
______________ help us to see patterns.
[A]
Charts
[B]
Graphs
[C]
Spreadsheets
[D]
Calculations
(4)
In a computer spreadsheet, to choose built in function we used is
[A]
defined function
[B]
function finder
[C]
built in function
[D]
paste function
(5)
In a computer spreadsheet, tool used to construct formulas is called
[A]
formula bar
[B]
filter
[C]
auditing toolbar
[D]
format printer
(6)
By default, worksheets that are present in a computer excel workbook are
[A]
10
[B]
4
[C]
3
[D]
None
(7)
In a computer spreadsheet, absolute cell reference can be represented as
[A]
B3
[B]
$B$3
[C]
B$3
[D]
$B3
(8)
Computer spreadsheet cell that is highlighted with a heavy border is a
[A]
active cell
[B]
cell containing a formula
[C]
locked cell
[D]
cell
(9)
Vertical dimension of a computer spreadsheet is called
[A]
row
[B]
column
[C]
record
[D]
field
(10)
In a computer spreadsheet, block of cells is called
[A]
range
[B]
column
[C]
workbook
[D]
function
(11)
In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?
[A]
you will be in the cell A1
[B]
you will be in the cell B5
[C]
you will be in the cell B3
[D]
you will be in the cell B6
Answer: you will be in the cell B5
(12)
In computer spreadsheet, a workbook is a group of
[A]
many rows
[B]
many columns
[C]
worksheet
[D]
least number of column
(13)
Faster way to change horizontal alignment in a computer document is
[A]
align left
[B]
center
[C]
align right
[D]
all of these
(14)
Title bar in MS-Excel displays name of the
[A]
worksheet
[B]
workbook
[C]
formula
[D]
location
(15)
In a computer, cell's address that is included in range C5:E7 is
[A]
C8
[B]
D6
[C]
E4
[D]
D9
(16)
In a computer, correct row address is
[A]
AA
[B]
25
[C]
3B
[D]
C5
(17)
In a computer, if custom format is #, # # # then 1500 will be displayed as
[A]
150,00
[B]
15,00
[C]
1,500
[D]
15,000
(18)
In a computer spreadsheet, a preprogrammed Formula is basically a
[A]
function
[B]
cell
[C]
graph
[D]
range
(19)
In a computer, page orientation is changed through
[A]
page setup dialog box
[B]
setup dialog box
[C]
paper dialog box
[D]
print dialog box
Answer: page setup dialog box
(20)
In a computer, graphics representation of data is named as
[A]
chart
[B]
graphics
[C]
picture
[D]
figure
Take Mock Tests