Question

2. Which of the following options when selected deletes all
data validation?
(a) Delete formatting (b) Delete all
(c) Delete formula
(d) Delete me
3. We can replace multiple occurrences of a word using
which of the following facilities of Calc?
(a) Find and replace
(b) By replace only
(c) By copy command
(d) By preview command
4. What is the name of mechanism to arrange the data in a
particular order?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating
5. What is the name of mechanism to filter out unnecessary
data?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating
6. Which of the following type of package does Calc refer to?
(a) Spreadsheet (b) Double sheet
(c) Multi-sheet (d) Cannot determine
7. Which of the following is an extension of a worksheet
created in Calc?
(a) ods
(b) .odd
(c) .xls
(d) .obj
8. How can one calculate the total of values entered in a
worksheet column of?
(a) By manual entry (b) By auto-sum
(c) By formula (d) By sum function
9. 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?
(a) The cell row and columns are changed at destination.
(b) The cell row change at destination.
(c) The cell columns are changed at destination.
(d) No change will scour.
10. What is the correct way to enter a function in Calc?
(a) Directly typing function name in a cell
(b) Using function wizard or selecting from toolbar
(c) Both (a) and (b)
(d) Depends on the function
ce​

Answer 1

Answer:

1-a,2p

Explanation:

the data validation is a function in ms Excel that is used. to restrict a value of user can enter into a cell