1.
Which of the following technique can be
used to allow only date value in cell?
(a) Data formatting
(b) Data sorting
(c) Data filtering
(d)
Data
validation
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.
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
10.
A function should start with
___________________.
(a)
'=' sign
(b) alphabets
(c) numbers
(d) All of the these
11.
Which of the following option is used to
print a chart?
(a) Insert \rightarrow Chart
(b) File \rightarrow View
(c)
File
\rightarrow Print
(d) View \rightarrow Chart
12.
How many axes does charts in Calc have?
(a)
Two
(b) Three
(c) Two or three
(d) Four
13.
The chart preview can be seen in
___________________.
(a)
Page preview
(b) Chart preview
(c) Export chart
(d) All of these
Q.2. Differentiate between a Workbook and a Worksheet.
Ans. A worksheet looks like a spreadsheet page. On the other hand, a workbook is a collection of all such worksheets in a single file. By default, a workbook consists of one or more worksheets.
Q.3. Define a cell range. How do we specify range in
LibreOffice Calc?
Ans. A cell range is a rectangular region on a worksheet consisting of two or more continuous cells. The address of the first and the last cell in the cell range is separated by a colon (:) sign. For example, the address A1:D7 refers to all the cells for cell A1 to cell D7. Similarly the address D10:F5 refers all the cells from D10 to F5.
Q.4. What do you understand by the term Column Header?
Ans. A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identity, from A to XFD. You can select a column by clicking on its header.
Q.5. What are Sheet tabs?
Ans. Sheet tab shows all the worksheets which are present in the workbook. By default, you will see one worksheet in your new workbook with the name of Sheet1.
Q.6. How can you assign a name to a range?
Ans. You can assign names to a cell or a range of cells. Naming cells is a much more user-friendly technique than working with cell co-ordinates.
To assign name to a range, follow the given steps:
(a) Select the desired range of cells.
(b) Now, type a suitable name for the range in the Name Box and press the Enter key.
(c) This name will be added in the drop-down list of the Name Box. Whenever, you select this name from the list, the associated range will be selected automatically.
Q.7. Define the active cell.
Ans. It is a cell which is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar. You can activate a cell by clicking on it or by using your arrow buttons.