Electronic Spreadsheet Quiz

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