Page 290 - open office
P. 290
1 . What is justified alignment
Ans. The contents will be displayed completely within the column width by increasing the column width.
11. What is the use of fill handle
Ans. The Calc Fill Handle tool is used to automatically fill input in series. It fills the next cells when we drag it with the
next predefined value. For example, if you want to fill the numbers in sequence of even numbers 2, 4, 6...., or
days of the week as Monday, Tuesday,.... or month names as an, Feb,...., we need to enter the first two values,
select them and drag to the next cells to generate the series.
B. Application based questions: L if e Sk il l s & V a l ues
1. Ashmit wants to present the information in the form of a chart. He has a data of single series and the graph
must show relative circular size of each value. Which chart type must he use?
Ans. Pie chart
2. Rohit is preparing a monthly sales report with the help of a Spreadsheet. While typing, the text is not
accommodated within the column width. Which option should he use to make the text appear properly?
Ans. Shrink to fit Cell size
Unsolved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. We can replace multiple occurrences of a word using which of the following facilities of Calc? [CBSE Handbook]
i. By find and replace ii. By replace only
iii By copy command iv. By preview command
2. The ‘Chart Wizard’ dialog box appear with four steps on the left side. Which of the following is not a step
among these steps?
i. Data Series ii. Chart Element
iii. Chart Type iv. Legend
3. What is the name of the mechanism to arrange the data in a particular order?
i. Sorting ii. Searching
iii. Filtering iv. Validating
4. Which of the following option is used to print a chart?
i. Insert Chart ii. File iew
iii. File Print iv. iew Chart
5. How many axes does charts in Calc have?
i. Two ii. Three
iii. Five iv. Four
290 Touchpad Information Technology-IX

