%
$
&
=
Ctrl+E
Ctrl+W
Ctrl+T
Ctrl+Q
File
Edit
View
Insert
Bottom left of the menu bar
Top left over menubar
On the status bar
Bottom right side of the menu bar
Print View
Print Preview
Print Screen
Print Document
OpenDocument
Microsoft Excel
PDF
All the above
AutoFilter
Conditional formatting
Pivot tables
Data validation
C1:10H
C1:H10
C1:H-10
C1:H:10
Ctrl+F12
F2
Ctrl+1
Ctrl+F1
Media Playback
3D settings
Painting
Drawing
Shape
Object
Chart
Pie
Match the following chart elements with their descriptions.
A-1, B-2, C-3, D-4
A-4, B-1, C-2, D-3
A-3, B-4, C-1, D-2
A-2, B-3, C-4, D-1
Non-breaking space
Non-breaking hyphen
Word Joiner
Sentence Joiner
Horizontal
Vertical
Both A and B
None of These
*
/
-
Ctrl + v
Ctrl + M
Ctrl + Shift + F
Ctrl + 1
Untitled1
Calc1
Spreadsheet1
None of these
.odt
.ods
.odp
.xlsx
256
1028
10000
Ctrl + Space
Shift + Space
Ctrl + Shift + Page down
None
###
The cell size increase automatically
####
#Name?
.ODF
.ODS
.OBT
400
6.25
7
500
To create charts and graphs
To format cells
To perform calculations and manipulate data
To insert images
Function
Formula
Graph
247
200
240
200.47
Ctrl + Shift + 1
Ctrl + Shift + 5
Ctrl + Shift + 4
Ctrl + Shift + 3
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
Filter
Sort
List
Arrange
Sorting
Inserting
Deleting
Data formatting
Data sorting
Data filtering
35
-35
12
2
Filtering
Title bar
Standard Toolbar
Formatting Toolbar
Formula Bar
511
508
510
509
Address Book
Name box
300
00
2.75
Bubble
Circle
Baloon
Hollow
10
3
No one
B1&B5
B1*B5
B1#B5
B1:B5
Heading1
Good
Bad
Poor
Nested Function
General Function
Condition Function
1
Recalculated formulas in all sheets
Update chart
Open Styles
Create a document template
Ctrl + C
Ctrl + Shift + M
Shift + F3
Ctrl + F2
Ctrl + F3
Alt + F3
11
13
Google Drive
One Drive
IBM Lotus Notes
FTP
Match the following error types in LibreOffice Calc with their meanings.
A-3, B-1, C-4, D-2
A-4, B-3, C-2, D-1
A-2, B-4, C-1, D-3
DCOUNT
DCOUNTA
DSUM
SUM