A unique identifier for each cell in the spreadsheet
A function used to format cells
A hyperlink to another cell or document
A shortcut key for accessing cells
1024
1048576
16384
None
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
Open Find dialog box
Open Find & Replace dialog box
Font dialog box
Format dialog box
Media Playback
3D settings
Painting
Drawing
Bubble
Circle
Baloon
Hollow
32000
48000
60000
None of these
Cell
Column
Row
Sheet
Shift+F2
Shift+F5
Shift+F3
CTRL+F9
Function
Formula
Graph
Chart
7,2
7+2
9
5,7
Ctrl + Shift + B
Ctrl + Shift + P
Ctrl + Shift + +
8
10
12
14
Sorting
Searching
Filtering
Validating
11
13
OpenDocument
Microsoft Excel
PDF
All the above
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above
14000
14200
14300
14243.25
Ctrl + Shift + V
Ctrl + V
Ctrl + Alt + V
Shift + V
Left
Right
Center
Justified
File
Edit
View
Insert
Print View
Print Preview
Print Screen
Print Document
AutoFilter
Advanced Filter
Standard
Store data
Manipulate data
Create graphical representation of data
All of these
7
3
No one
1048576 Rows & 1024 Columns
1048576 Rows & 16384 Columns
16384 Rows & 1048576 Columns
1024 Rows & 1048576 Columns
Mathematical
Financial
Statistical, logical
Date( )
Now( )
Time( )
Directly typing function name in a cell
Using function wizard or selecting from toolbar
Both (a) and (b)
Depends on the function
File name
Location where the file is to be saved
Both A and B
Inserting
Deleting
Relative address
Absolute address
Mixed address
Dynamic address
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Heading1
Good
Bad
Poor
By manual entry
By auto-sum
By formula
By sum function
To add data
Formatting
To add formula
15
4
5
Data Series
Chart Series
Chart Elements
Chat type
Calculating result
Sorting on result
Filtering on result
Cut, Copy, Paste
Find and Replace
Select All
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
do calculations
create graphics
plot graphs
plot charts
See Only Specific Data
Arrange data
Copy Data
Making Chart
cell reference
cell identify
cell across
cell identification number
1
'=' sign
Alphabets
Numbers
All of the these
A dotted border
A dark wide border
A blinking border
By italic text
Date
Cell Value
256
1028
10000
None of These
Ctrl + C
Ctrl + M
Ctrl + Shift + M