Ctrl + Shift + C
Ctrl + C
Ctrl + Shift + T
Ctrl + Alt + C
15
3
4
5
256
1028
10000
None of These
Nested Function
Function
General Function
Condition Function
Store data
Manipulate data
Create graphical representation of data
All of these
Insert
Data
Tools
View
A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…
.odt
.ods
.odp
.xlsx
Ctrl + V
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
OpenDocument
Microsoft Excel
PDF
All the above
Freeze current column
Freeze current cell
Freeze current row
Freeze First Row
7
10
1
Two
Three
Four
Five
Data Series
Chart Series
Chart Elements
Chat type
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
=
*
/
-
Cell
Column
Row
Sheet
Sorting
Inserting
Filtering
Deleting
Find and replace
By Copy only
By copy command
By preview command
Formula
Graph
Chart
Ctrl + ;
Shift + D
Ctrl + D
Alt + D
Save As
Save
Save File
Save As File
Line chart
Pie chart
Bar chart
Square chart
Ctrl + F6
Ctrl + H
Ctrl + F8
Ctrl + F1
1024
1048576
16384
None
Date
Cell Value
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
Ctrl + A
Ctrl+ Shift + A
Ctrl + Shift + Space
A and C Both
Horizontal
Vertical
Both A and B
Value
Address
Bold, Italics, Underline
Left, Center, Right, Justify
Font Name, Font Size, Font Color
511
508
510
509
56
-1
400
6.25
500
Tab
Ctrl + Tab
Ctrl + Shift + Tab
Shift + Tab
Untitled1
Calc1
Spreadsheet1
Prediction Values
Variable Cell
What if Values
Target Value
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
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
Chart wizard
Pie wizard
Object
Shap
Center
Split Cells
Split and merge
Merge and center
Draw
Impress
Calc
Writer
Data formatting
Data sorting
Data filtering
Data validation
7,2
7+2
9
5,7
To create charts and graphs
To format cells
To perform calculations and manipulate data
To insert images
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
###
The cell size increase automatically
####
#Name?
By manual entry
By auto-sum
By formula
By sum function
Type Monday, hold down right corner and pull down
Do inter press by writing monday
= week () uses the function
All of the above