Cell
Tabel
Position
Data
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
Formula Bar
Address Book
Name box
None
Format
Style
Sheet
Edit
Insert
Tools
View
Letter
Fax
Agenda
E-mail
@
#
$
&
300%
200%
400%
500%
14000
14200
14300
14243.25
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
Nested Function
Function
General Function
Condition Function
=
*
/
-
Ctrl + W
Ctrl + Q
Ctrl + Shift + C
Shift + W
Change
Text
Transpose
Convert
Math / Tring
Mathematical
String
Cut, Copy, Paste
Find and Replace
Select All
All of these
Financial
Statistical, logical
Ctrl+Shift+V
Ctrl+V
Ctrl+C
Strl+Shift+S
Sorting
Inserting
Filtering
Deleting
1
15
56
-1
.odt
.ods
.odp
.xlsx
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Line
Pie
Bar
Column
247
200
240
200.47
Two
Three
Four
Five
8
10
12
14
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
Row
cell reference
cell identify
cell across
cell identification number
-5
5
25
50
511
508
510
509
AutoFilter
Conditional formatting
Pivot tables
Data validation
C1:10H
C1:H10
C1:H-10
C1:H:10
32000
48000
60000
None of these
B1&B5
B1*B5
B1#B5
B1:B5
98
97
91
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
Shift + 1
Ctrl + 1
Alt + 1
Ctrl + Alt + 1
Horizontal
Vertical
Both A and B
None of These
Searching
Validating
Chart wizard
Pie wizard
Object
Shap
Media Playback
3D settings
Painting
Drawing
By manual entry
By auto-sum
By formula
By sum function
OpenDocument
Microsoft Excel
PDF
All the above
2
3
4
Date
Formula
Cell Value
A dotted border
A dark wide border
A blinking border
By italic text