WorksheetsCLASS IX ELECTRONIC SPREADSHEET
Total questions: 24
Worksheet time: 12mins
What is the last column in LibreOffice Calc?
AMJ
XFD
AMG
EMJ
What is the default file extension in LibreOffice Calc?
.odt
.ods
.odp
.xlsx
What is the shortcut key of inserting time in LibreOffice Calc?
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
None of the above
What is the shortcut key of inserting current date in LibreOffice Calc?
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
None of the above
How many total rows are there in LibreOffice Calc?
1024
1048576
16384
None of Above
How many total columns are there in LibreOffice Calc?
1024
1048576
16384
None of Above
What is a spreadsheet in a LibreOffice?
Draw
Impress
Calc
Writer
Find the correct formula
b1=c1*8
=c1*8
=c*8
b1=c*8
$b$6 is an example of ______________ cell reference
absolute
relative
mixed
circular
$c6 is an example of _________ cell reference
absolute
relative
mixed
circular
Characters are by default __________ aligned
right
left
center
justify
The small black square in the bottom-right corner of
the selected cell or range is called a ___________
fill mode
fill up
auto fill
fill handle
The default cell referencing is ____________
absolute
relative
mixed
circular
Select Correct Formula for 'SUM Function'
a. =SUM(FIRST NUMBER + LAST NUMBER)
b. =SUM (First cell address : Last cell address)
c. =SUM ( C2: E2)
d. =SUM(C2+E2)
The contents of Cell A1, B1, C1 and D1 are 5, –25, 30 and –35, respectively. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1).
(a)
The ____________ in Calc is also referred to as spreadsheet.
Workbook
Sheet
worksheet
book1
By default numbers are ________ aligned
right
left
center
justify
Find the correct formula
b1=c1*8
=c1*8
=c*8
b1=c*8
Characters are by default __________ aligned
right
left
center
justify
The combination of the column letter and row number for a cell in an Calc spreadsheet is called ...............
Cell across
Cell reference
Cell identify
Cell Identification number
The ____________error means that there is an error in the formula, range or name of the function.
#Name?
#REF!
#######
#VALUE! error
9. This type of chart is used to illustrate changes in a value over a period of time.
Line
Bar
Pie
Column
Observe the image and choose the correct type of Chart
Line Chart
Pie Chart
Area Chart
Scatter Chart
