Page 272 - open office
P. 272
B. Application based questions: L if e Sk il l s & V a l ues
1. Amandeep wants to use a shortcut tool for adding the values of a range of cells. Name this tool.
Ans. Autosum
2. Deepashika is working on her Social Studies project. She is trying to record the data on a spreadsheet about
some Indian cities as shown:
How will you find out which city has the maximum population and minimum temperature
Ans. MA (C2:C5)
MI (B2:B5)
Unsolved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. A function should start with ..................................
i. ‘=’ sign ii. Alphabets
iii. Numbers iv. All of the these
2. What is the correct way to enter a function in Calc CBSE Handbook
i. Directly typing function name in a cell
ii. Using function wizard or selecting from toolbar
iii. Both i and ii
iv. Depends on the function
3. How can one calculate the total of values entered in a worksheet column
i. By sum function ii. By auto-sum
iii. By formula iv. All of these
4. Which of the following type of package does Calc refer to
i. Spreadsheet ii. Double sheet
iii. Multi-sheet iv. Cannot be determined
B. Fill in the blanks.
1. A Calc worksheet contains ................................. columns and 1 ,4 ,5 6 rows.
2. The extension of Calc file is ................................. that automatically gets attached with the file name.
3. By default, ‘Calc’ workbook opens with ................................. worksheets.
4. Active cell in a worksheet is known as ................................. .
2 2 Touchpad Information Technology-IX

