Page 196 - CA 165 ver 1.0 Class 9
P. 196
B. Case Based MCQs
Worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A workbook
is a collection of multiple worksheets. (A workbook is like a book and the worksheet is like a page of a book).
By default, a workbook opens with three worksheets, namely Sheet1, Sheet2 and Sheet3. User can change the
name of the sheets and may delete or add extra sheets if required. The name of each sheet appears in the sheet
tab towards the bottom of the worksheet. The active sheet i.e. the sheet being used, is highlighted.
1. Which of the following is a shortcut to open a new workbook?
i. Ctrl+N ii. Ctrl+W
iii. Ctrl+O iv. Ctrl+P
2. The extension of a file in Calc is .....................................
i. .xlsx. ii. .doc
iii. .ods iv. .odf
3. Which among the following is an active cell in a worksheet that is highlighted with a thick boundary?
i. Cell Address ii. Cell Pointer
iii. Name Box iv. None of these
C. Fill in the blanks.
1. A ‘Calc’ worksheet contains .................................... columns and 65,536 rows.
2. .................................... helps to change the direction of contents in a cell.
3. Series of numbers can be filled using .................................... feature.
4. .................................... button is used to enter or edit formula in Calc.
5. The extension of Calc file is .................................... which automatically gets attached with the file name.
PART B
A. Short answer type questions.
1. How can a sheet of workbook be hidden?
2. How will you add a new sheet in your workbook?
3. Explain the ‘Autofill’ feature of Spreadsheet.
4. What are the different types of data that can be entered in the cells?
5. Differentiate between Wrap Text and Shrink to fit cell size.
B. Long answer type questions.
1. Explain any two logical functions with example.
2. Define Operators. List and describe all the operators.
3. Write down the steps to hide columns in OpenOffice Calc.
4. Write short notes on:
i. Formula Bar ii. Operands
iii. Sheet Tab iv. Formatting Cells
C. Application based questions.
1. Rohit is preparing monthly sales report with the help of Spreadsheet. While typing, the text is not
accommodated within the column width. Which option should he use so that text appears properly?
2. Amandeep wants to use shortcut tool for adding the values of a range of cells using the function ‘SUM’.
Name this tool.
194 Touchpad Computer Applications-IX

