1
15
56
-1
Date( )
Now( )
Time( )
N10
M11
M9
M12
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
=
*
/
-
AutoFilter
Conditional formatting
Pivot tables
Data validation
Ctrl + A
Ctrl + shift + Space
Ctrl + Shift + A
A & B both
Cut, Copy, Paste
Find and Replace
Select All
All of these
Ctrl + V
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
Bubble
Circle
Baloon
Hollow
.odt
.ods
.odp
.xlsx
Ctrl + C
Ctrl + Shift + M
None
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
1024
1048576
16384
None of These
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
To create charts and graphs
To format cells
To perform calculations and manipulate data
To insert images
256
1028
10000
X.502
X.503
X.510
X.509
500%
400%
350%
600%
Store data
Manipulate data
Create graphical representation of data
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
Ctrl + Shift + S
Ctrl + F2
Shift+F7
CTRL+F7
Shift+F9
CTRL+F9
Line chart
Pie chart
Bar chart
Square chart
Bring to Front
Send to Back
Send to Front
Forward One
Ctrl + v
Media Playback
3D settings
Painting
Drawing
1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above
See Only Specific Data
Arrange data
Copy Data
Making Chart
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
Shift+F2
Shift+F5
Shift+F3
Left
Right
Center
Justified
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
Chart Title
Data Label
Chart Area
Chart Line
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
File name
Location where the file is to be saved
Both A and B
None of these
Advanced Filter
Standard
Sorting
Up and Down scroll
Right and left
Horizontal and Vertical
All of above
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Ctrl + Shift + :
A and B both
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Shift + 1
Alt + 1
Ctrl + Alt + 1
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
300%
200%
%
$
&
AMJ
XFD
AMG
EMJ
Pause
Stop
Freeze
Scroll Off
Nested Function
Function
General Function
Condition Function
Split Cells
Split and merge
Merge and center