Column
Value
Address
Cell
Ctrl + F2
Ctrl + F4
Ctrl + F3
None of these
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
Sorting
Inserting
Filtering
Deleting
Data formatting
Data sorting
Data filtering
Data validation
Searching
Validating
14000
14200
14300
14243.25
Function
Formula
Graph
Chart
8
10
12
14
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
None
To add data
Formatting
To add formula
All of these
Draw
Impress
Calc
Writer
Base
B1&B5
B1*B5
B1#B5
B1:B5
.ods
.xls
.odx
.txt
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
32000
48000
60000
Ctrl + v
Ctrl + M
Ctrl + Shift + F
Ctrl + ]
Alt +D
Ctrl + ;
Shift + K
200
300
00
2.75
1
15
56
-1
Change
Text
Transpose
Convert
Save As
Save
Save File
Save As File
=SUM(J14:J16)
=SUM(J14?J16)
SUM(J14:J16)
J14+J15+J16
OpenDocument
Microsoft Excel
PDF
All the above
.odt
.odp
.xlsx
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Ctrl + 4
Ctrl + 3
Ctrl + 2
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
Untitled1
Calc1
Spreadsheet1
None of These
511
508
510
509
Letter
Fax
Agenda
E-mail
@
#
$
&
Insert
Data
Tools
View
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Data Series
Chart Series
Chart Elements
Chat type
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
Format
Style
Sheet
Edit
AMJ
XFD
AMG
EMJ
Left
Right
Center
Justified
3
7
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
Line chart
Pie chart
Bar chart
Square chart
Mathematical
Financial
Statistical, logical
Find and replace
By Copy only
By copy command
By preview command
Row
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
Ctrl+]
Ctrl+[
Ctrl+}
Ctrl+{
Google Drive
One Drive
IBM Lotus Notes
FTP