NEW
Font size
WorksheetsElectronic Spreadsheet
Total questions: 20
Worksheet time: 10mins
Which of the following technique can be used to allow only date value in cell?
Data formatting
Data sorting
Data filtering
Data validation
Which of the following options when selected deletes all data validation?
Delete formatting
Delete all
Delete formula
Delete me
We can replace multiple occurrences of a word using which of the following facilities of Calc?
Find and replace
By replace only
By copy command
By preview command
What is the name of mechanism to arrange the data in a particular order?
Sorting
Searching
Filtering
Validating
What is the name of mechanism to filter out unnecessary data?
Sorting
Searching
Filtering
Validating
Which of the following type of package does Calc refer to?
Spreadsheet
Double sheet
Multi-sheet
Cannot determine
Which of the following is an extension of a worksheet created in Calc?
.ods
.odd
xls
.obj
How can one calculate the total of values entered in a worksheet column of?
By manual entry
By auto-sum
By formula
By sum function
If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell numbers used in the formula?
The cell row and columns are changed at destination.
The cell row change at destination.
The cell columns are changed at destination.
No change will scour.
What is the correct way to enter a function in Calc?
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 the these
Which of the following option is used to print a chart?
Insert → Chart
File → View
File → Print
View → Chart
How many axes does charts in Calc have?
Two
Three
Two or three
Four
The chart preview can be seen in
Page preview
Chart preview
Export chart
All of these
In a spreadsheet, we can change the column width and row height.
$A1$B2 is an example of mixed referencing.
There are 'n' number of sheets in a spreadsheet.
A spreadsheet is also called as worksheet.
A cell is a combination of row and column.
MS Excel is an electronic spreadsheet software that accepts data.
