WorksheetsDPA Quiz
Total questions: 40
Worksheet time: 13mins
Name
Class
Date
1.
What is the extension of worksheet file?
a)
.xls
b)
.ods
c)
.odb
d)
.com
2.
Which of the following type of package does Calc refer to?
a)
Spreed Sheet
b)
Double Sheet
c)
Multi Sheet
d)
Cannot be Determined
3.
workbook is collection of
a)
data
b)
pdf
c)
images
d)
spreadsheets
4.
By default, worksheets that are present in computer workbook are
a)
10
b)
4
c)
3
d)
NONE
5.
A column heading in Open office Calc as a
a)
Number
b)
Symbol
c)
Date
d)
Alphabet
6.
The basic unit of a worksheet into which you
enter data in spreadsheet is called a
a)
Cell
b)
Table
c)
Box
d)
Column
7.
Workbook Based on Software
a)
WINDOWS
b)
DOS
c)
UNIX
d)
LINUX
8.
Formulas in Excel start with
a)
/
b)
f
c)
-
d)
=
9.
What is the shortcut key for repeat the last command?
a)
Alt+Y
b)
Ctrl+Y
c)
Ctrl+shift+Y
d)
Ctrl+Alt+Y
10.
The cell that is in use is called
a)
Highlighted cell
b)
Main cell
c)
Active cell
d)
Formula cell
11.
Workbook is a collection of
?
a)
Worksheets
b)
Diagrams
c)
Menus
d)
Buttons
12.
is a grid of rows and columns.
a)
Workbook
b)
Worksheet
c)
Range
d)
Cell
13.
How to define cell address?
a)
Column Name
follow by Row number
b)
Column
number follow by Row name
c)
Column name only
d)
Row number only
14.
Select the Relative Cell Reference form below:
a)
A1
b)
A
c)
1
d)
$A$1
15.
Which tool is used to join few cells and place the content at the middle of joined cell?
a)
From format
cell dialog box, click on merge
b)
From format
cell dialog box, select the
c)
From format
cell dialog box, choose merge
d)
Click on merge and
center toll from formatting toolbar
16.
1) What is the default extension of OpenOffice Calc?
a)
.xls
b)
.ods
c)
.xlsx
d)
.csv
17.
Longer Text can be broken into multiple lines
inside the cell. This can be achieved by
.
a)
Freeze Pane
b)
Wrap Text
c)
Justify
d)
Split Pane.
18.
In OpenOffice.ods, presentation can be prepared using application.
a)
writer
b)
calc
c)
draw
d)
impress
19.
Which of the following is an extension of worksheet created in Cals?
a)
.doc
b)
.ods
c)
.obj
d)
.xls
20.
In spreadsheet the command that is used to
merge selected cells into one single cell is called-
a)
Merge
b)
Split
c)
Join
d)
Freeze
21.
The absolute cell reference is written as in spreadsheet
a)
A1
b)
$A1
c)
$A$1
d)
A$1
22.
On which place, we can show current cell address?
a)
On standard tool bar
b)
On status bar
c)
On properties window
d)
On Address bar
23.
Which of the following is the extension of a worksheet created in Calc?
a)
.ods
b)
.odd
c)
.xls
d)
.obj
24.
Worksheet is collection of
a)
cells
b)
rows
c)
columns
d)
data
25.
In a spreadsheet absolute cell reference can be represented as
a)
B3
b)
$B$3
c)
B$3
d)
$B3
26.
Which of the following symbol is used to make a cell as an absolute reference?
a)
+
b)
%
c)
&
d)
$
27.
Computer spreadsheet cell that is highlighted with a heavy border is a
a)
Active Cell
b)
Cell containing formula
c)
Locked Cell
d)
Cell
28.
In Workbook the keyboard shortcut for creating a chart from the selected cells
a)
F3
b)
F5
c)
F12
d)
F11
29.
MS Excel file can NOT be directly exported as
a)
PDF
b)
TXT
c)
PPT
d)
CSV
30.
How many alignments are there in worksheet ?
a)
5
b)
4
c)
3
d)
2
31.
The process of identifying specific rows and
columns so that so that certain columns and rows are always visible on the screen is called
a)
Locking
b)
Freeze Pane
c)
Selecting
d)
Fixing
32.
By which of the following we can change the appearance of the value in a cell?
a)
Indentation
b)
Design
c)
Format
d)
Alignment
33.
Which of the following is the default cell reference in spreadsheet?
a)
Relative reference
b)
Absolute reference
c)
Mixed reference
d)
None of above
34.
Which of the following is full form of .CSV?
a)
Common
Separated Value
b)
Comma
Separated Value
c)
Common Special Value
d)
Comma Special Value
35.
By which option we can see the preview of the selected part in excel?
a)
Page Preview
b)
Quick Print
c)
Format Painter
d)
Freeze Panel
36.
To apply transpose, which of the following option is used?
a)
Paste
b)
Row to column
c)
Paste Special
d)
None of above
37.
tool is used to copy formatting
from one cell or text and then apply it elsewhere?
a)
Paste
b)
Paste special
c)
Format painter
d)
None of these
38.
Workbook is a collection of
a)
Worksheets
b)
Page set-up
c)
Buttons
d)
Diagrams
39.
In Microsoft Excel spreadsheets, rows are labelled as
a)
1,2,3,4....
b)
A,B,C,D....
c)
A1,B1,C1,D1...
..
d)
I,II,III,....
40.
How can we add another sheet location on current doucument sheet ?
a)
Hyperlink
b)
Script
c)
Insert
d)
Arrange
100 %
