Questions
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
View Answer
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
View Answer
Answer: Spreadsheet package
Advertisement
3
______________ help us to see patterns.
A
Charts
B
Graphs
C
Spreadsheets
D
Calculations
View Answer
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
View Answer
5
In a computer spreadsheet, tool used to construct formulas is called
A
formula bar
B
filter
C
auditing toolbar
D
format printer
View Answer
6
By default, worksheets that are present in a computer excel workbook are
View Answer
7
In a computer spreadsheet, absolute cell reference can be represented as
View Answer
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
View Answer
9
Vertical dimension of a computer spreadsheet is called
A
row
B
column
C
record
D
field
View Answer
10
In a computer spreadsheet, block of cells is called
A
range
B
column
C
workbook
D
function
View Answer
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
View Answer
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
View Answer
13
Faster way to change horizontal alignment in a computer document is
A
align left
B
center
C
align right
D
all of these
View Answer
14
Title bar in MS-Excel displays name of the
A
worksheet
B
workbook
C
formula
D
location
View Answer
15
In a computer, cell's address that is included in range C5:E7 is
View Answer
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
View Answer
18
In a computer spreadsheet, a preprogrammed Formula is basically a
A
function
B
cell
C
graph
D
range
View Answer
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
View Answer
Answer: page setup dialog box
20
In a computer, graphics representation of data is named as
A
chart
B
graphics
C
picture
D
figure
View Answer
