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