do calculations
create graphics
plot graphs
plot charts
By manual entry
By auto-sum
By formula
By sum function
10
3
7
1
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
CTRL+P
CTRL+Shift+P
Alt+P
CTRL+Alt+P
Center
Split Cells
Split and merge
Merge and center
Letter
Fax
Agenda
E-mail
Two
Three
Four
Five
.odp
.ods
.odd
.odt
8
12
14
Match the following chart elements with their descriptions.
A-1, B-2, C-3, D-4
A-4, B-1, C-2, D-3
A-3, B-4, C-1, D-2
A-2, B-3, C-4, D-1
32000
48000
60000
None of these
Find and replace
By Copy only
By copy command
By preview command
Data Series
Chart Series
Chart Elements
Chat type
Nested Function
Function
General Function
Condition Function
Ctrl + ;
Shift + D
Ctrl + D
Alt + D
'=' sign
Alphabets
Numbers
All of the these
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
7,2
7+2
9
5,7
###
The cell size increase automatically
####
#Name?
Horizontal
Vertical
Both A and B
None of These
.ott
.odf
Sorting
Filter
Inserting
Deleting
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
AMJ
XFD
AMG
EMJ
1024
1048576
16384
None
Bottom left of the menu bar
Top left over menubar
On the status bar
Bottom right side of the menu bar
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
15
56
-1
Date( )
Now( )
Time( )
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
DCOUNT
DCOUNTA
DSUM
SUM
#name?
#name
Whatever is written in a formula will remain the same
Column
Value
Address
Cell
Line chart
Pie chart
Bar chart
Square chart
16348
1084576
1024598
Bring to Front
Send to Back
Send to Front
Forward One
Print View
Print Preview
Print Screen
Print Document
35
-35
2
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
Freeze current column
Freeze current cell
Freeze current row
Freeze First Row
OpenDocument
Microsoft Excel
PDF
All the above
Ctrl + 4
Ctrl + 3
Ctrl + 2
Ctrl + 1
Media Playback
3D settings
Painting
Drawing
11
13
N10
M11
M9
M12
A3
$A$3
A$3
$A3
AutoFilter
Advanced Filter
Standard
Formula Bar
Address Book
Name box
See Only Specific Data
Arrange data
Copy Data
Making Chart