1024
1048576
16384
None of These
By manual entry
By auto-sum
By formula
By sum function
16348
1084576
1024598
4
20
25
50
CTRL+E
CTRL+ Alt+ E
CTRL+Shift+E
CTRL+F9
Match the following cell referencing types with their descriptions.
A-1, B-2, C-3, D-4
A-2, B-1, C-4, D-3
A-3, B-4, C-1, D-2
A-4, B-3, C-2, D-1
Format
Style
Sheet
Edit
Sorts data
Adjusts row/column size automatically
Creates formulas
Protects cells
Untitled1
Calc1
Spreadsheet1
None of these
15
3
5
256
1028
10000
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
32000
48000
60000
Heading1
Good
Bad
Poor
Letter
Fax
Agenda
E-mail
Center
Split Cells
Split and merge
Merge and center
Corel Draw
Wordstar
EXCEL
MS-WORD
Data formatting
Data sorting
Data filtering
Data validation
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Freeze current column
Freeze current cell
Freeze current row
Freeze First Row
None
Match the following mathematical functions with their purposes.
A-2, B-3, C-4, D-1
A-4, B-1, C-2, D-3
Goal Seek
Sort
Filter
Freeze Panes
Date
Formula
Cell Value
All the above
SUM
COUNT
AVERAGE
MEAN
Horizontal
Vertical
Both A and B
Sorting
Searching
Filtering
Validating
.ods
.odt
.ott
.odf
Mathematical
Financial
Statistical, logical
All of these
Ctrl + V
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
Ctrl + Shift + S
Ctrl + F2
Column
Value
Address
Cell
#name?
#name
Whatever is written in a formula will remain the same
####
C1:10H
C1:H10
C1:H-10
C1:H:10
Data
Math / Tring
String
Shift + F3
Ctrl + F3
Alt + F3
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
AutoFilter
Advanced Filter
Standard
Formatting sheets
Evaluating different scenarios
Creating charts
Printing reports
Date( )
Now( )
Time( )
10
7
No one
Line Chart
Bar Chart
Pie Chart
Scatter Chart
AMJ
XFD
AMG
EMJ
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
.xls
.odx
.txt
Inserting
Deleting
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
'=' sign
Alphabets
Numbers
All of the these
1199
1210
1188
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