.odt
.ods
.odp
.xlsx
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
To apply predefined formatting to cells based on specific conditions
To perform complex calculations and data analysis
To filter and display only the rows that meet specific criteria
To create charts and graphs
Date
Formula
Cell Value
All the above
To add data
Formatting
To add formula
All of these
Match the following cell referencing types with their descriptions.
A-2, B-1, C-4, D-3
A-4, B-3, C-2, D-1
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
A dotted border
A dark wide border
A blinking border
By italic text
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
None of These
File name
Location where the file is to be saved
Both A and B
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
Data
Math / Tring
Mathematical
String
%
$
&
=
Bring to Front
Send to Back
Send to Front
Forward One
do calculations
create graphics
plot graphs
plot charts
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
Financial
Statistical, logical
Sorting
Filter
Inserting
Deleting
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
Store data
Manipulate data
Create graphical representation of data
.ODF
.ODS
.OBT
Ctrl + V
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
Flipping a selection convert it into a floating selection
Flip Horizontal flip the left side to the right side
Flip Horizontal flips the right to the left side
Flip vertical flips the top to the bottom
*
/
-
Cell
Column
Row
Sheet
File
Edit
View
Insert
200
300
00
2.75
'=' sign
Alphabets
Numbers
All of the these
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
400
6.25
7
500
By manual entry
By auto-sum
By formula
By sum function
Instant messaging, address book, antivirus, mailing list
Forms, data analysis, conditional formatting, sorting and filtering
Graphics, templates, spell checker, thesaurus
Accessibility, multimedia, hyperlinks, updated
1
15
56
-1
Shift+F7
CTRL+F7
Shift+F9
CTRL+F9
Print View
Print Preview
Print Screen
Print Document
Pause
Stop
Freeze
Scroll Off
See Only Specific Data
Arrange data
Copy Data
Making Chart
Untitled1
Calc1
Spreadsheet1
Ctrl+f
Ctrl+D
Ctrl+L
Ctrl+1
Up and Down scroll
Right and left
Horizontal and Vertical
Bubble
Circle
Baloon
Hollow
98
97
91
None
Ctrl + ;
Ctrl + Shift + :
A and B both
Function
Graph
Chart
Shape
Object
Pie
Corel Draw
Wordstar
EXCEL
MS-WORD