WorksheetsElectronic Spreadsheet Class 9 Quiz
Total questions: 53
Worksheet time: 27mins
LibreOffice Calc is used to perform the _________ activities.
Tabulation of data
Simple mathematical calculations
Arranging data in ascending and descending order
All of the above
Calc is the spreadsheet application of _________ suite.
Microsoft Office
LibreOffice
Both a) and b)
None of the above
After installing _________ operating System, by default LibreOffice gets installed.
All of the above
Windows 10
MacOS
Ubuntu
Menu bar is located just below the ________.
Title Bar
Standard Toolbar
Formula Bar
Formatting Toolbar
Placing the mouse cursor over any icon displays a small box called a _______.
None of the above
Toolbar
Tooltip
Toolmenu
This selected or activated cell is called as _________.
None of the above
Active Cell
Inactive Cell
No Cell
When we are selecting multiple columns in a spreadsheet it is called _________.
Row range
Column range
None of the above
Cell range
When we are selecting multiple rows in a spreadsheet it is called _________.
None of the above
Cell range
Row range
Column range
The ___________ is used to select more than one ‘range of cells’ in a worksheet.
Alter key
Shift key
Control key
Enter key
Label text may combine with __________.
Letters
Numbers
Special Symbols
All of the above
Any expression that begins with __________ is treated as a formula.
#
%
$
=
The results obtained from a formula always get updated _________ when the values of these cells change.
Manually
Never
Some time
Automatically
To calculate the total number of cells from A1 to A5, which formula will you use?
=A1+A2+A3+A4+A5
=sum(A1;A5)
Both a) and b)
None of the above
To find the average of the cells from A1 to A5, which formula will you use?
Both a) and b)
=average(A1;A5)
=(A1+A2+A3+A4+A5)/5
None of the above
To find the maximum value from the cells A1 to A5, which formula will you use?
Both a) and b)
None of the above
=max(A1;A5)
=maximum(A1;A5)
To find the minimum value from the cell A1 to A5, which formula will you use?
None of the above
Both a) and b)
=min(A1;A5)
=minimum(A1;A5)
To count the total number of cells from A1 to A5, which formula will you use?
=countblank(A1;A5)
=count(A1;A5)
None of the above
Both a) and b)
You can open the Format Cell dialog box by pressing the shortcut key _________.
Ctrl + P
Ctrl + F
Ctrl + D
Ctrl + I
In the spreadsheet, which numerical value is not allowed at the start?
1
0
5
2
The date format in a spreadsheet is set to ________ by default.
dd-mm-yyyy
mm-dd-yyyy
dd-yyyy-mm
yyyy-dd-mm
How many types of alignment are there in electronic spreadsheet?
2 (left, right)
5 (left, right, center, top, bottom)
3 (left, right, center)
4 (left, right, center, justify)
Shortcut key for copy in electronic spreadsheet is?
Ctrl + V
None of the above
Ctrl + X
Ctrl + C
Shortcut key for cut in electronic spreadsheet is?
None of the above
Ctrl + V
Ctrl + X
Ctrl + C
Shortcut key for paste in electronic spreadsheet is?
Ctrl + V
None of the above
Ctrl + X
Ctrl + C
The small black square in the bottom-right corner of the selected cell is called a _______.
Fill content
Fill handle
Fill document
None of the above
Which one is a correct referencing in spreadsheet?
Mixed referencing
Relative referencing
All of the above
Absolute referencing
_________ is the way to refer the formula from one cell to the next cell.
Address
Referencing
Link
None of the above
When you drag any formula in any direction, the formula gets copied in the new cell this is known as _______.
Mixed reference
Relative reference
All of the above
Absolute reference
In __________, a $ symbol is used before the column name to make it constant.
Absolute reference
Relative reference
Mixed reference
All of the above
You can easily comprehend data in spreadsheets using _________.
None of the above
Filter
Chart
Formula
Choose the correct example of the chart in the spreadsheet.
Column Chart
Bar Chart
Line Chart
All of the above
Which technique can be used to allow only date value in cell?
Data filtering
Data validation
Data sorting
Data formatting
Which Calc feature allows us to replace multiple occurrences of a word?
Delete me
Delete formula
Delete formatting
Delete all
We can replace multiple occurrences of a word using which facility of Calc?
By copy command
By replace only
Find and replace
By preview command
What is the name of the mechanism that organizes data in a specific order?
Sorting
Validating
Searching
Filtering
What is the name of the mechanism that filters out irrelevant information?
Validating
Filtering
Searching
Sorting
Which of the following types of packages does Calc refer to?
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Which of the following is an extension of a Calc worksheet?
.obj
.xls
.odd
.ods
How can one calculate the total of values entered in a worksheet column?
By manual entry
Without formula
By sum function
By auto-sum
What happens if we move a cell carrying a formula that refers to another cell?
The cell columns are changed at destination.
The cell row and columns are changed at destination.
The cell row changes at destination.
No change will occur.
How do you enter a function in Calc correctly?
Directly typing function name in a cell
Using function wizard or selecting from toolbar
Both (a) and (b)
Depends on the function
A function should start with__________________.
‘=’ sign
alphabets
numbers
All of these
A chart is printed using which of the following options?
File → Print
File → View
Insert → Chart
View → Chart
How many axes do Calc charts have?
Three
Two
Two or three
Four
In__________, you can see a preview of the chart.
Page preview
All of these
Chart preview
Export chart
The column immediately next to column “Z” is ___________________.
None of the above
AZ
A
AA
The default extension of a workbook created using LibreOffice Calc is _____________.
.xls
.odf
.ods
.mdf
The spreadsheet feature used to continue the series is called as __________________.
Type Handle
Auto Handle
Fill Handle
None of the above
The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to ______________.
Row and Column
Column only
None of the above
Row only
The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to _____________.
None of the above
= D2 + E3
= B1 + C4
= B1 +C2
The cell address of the cell formed by the intersection of the ninth column and the eighth row will be _____________.
18
19
17
81
$A1$B2 is an example of _____________ referencing in spreadsheet software.
Absolute referencing
Mixed referencing
Relative referencing
None of the above
Numbers entered into a cell are automatically ___________ aligned.
None of the above
Left align
Center align
Right align
