Page 210 - CA_165_V2.0_C9_Flipbook
P. 210
D. 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.
SECTION C
(Case-based/Passage-based Type Questions)
A. A sheet is the working area or page on the screen. A sheet consists of rows and columns. A spreadsheet is a
collection of multiple sheets. (A spreadsheet is like a book and the sheet is like a page of a book). By default,
a spreadsheet opens with three sheets, 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 sheet. The active sheet i.e. the sheet being used, is highlighted.
1. Which of the following is a shortcut to open a new spreadsheet?
i. Ctrl+N ii. Ctrl+W
iii. Ctrl+O iv. Ctrl+P
2. The extension of a file in OpenOffice Calc is .....................................
i. .xlsx. ii. .doc
iii. .ods iv. .odf
3. Which among the following is an active cell in a sheet that is highlighted with a thick boundary?
i. Cell Address ii. Cell Pointer
iii. Name Box iv. None of these
B. Sophia is using OpenOffice Calc to maintain the inventory of a small bookstore. She has columns for Item
Name, Quantity in Stock, Price per Unit, Total Value, and Supplier Name. She needs to:
● Enter data for new items in the inventory.
● AutoFill the Total Value for all items based on the formula.
● Save the updated inventory report.
1. Which feature will help Sophia quickly copy the Total Value formula to all other rows?
i. Sorting ii. AutoFill
iii. Data Validation iv. Freeze Panes
2. How should Sophia enter new items in the inventory?
i. Manually type the data into the cells ii. Use the Paste function
iii. Create a table iv. Use the Chart function
3. What shortcut key should Sophia use to save the spreadsheet after entering the inventory data?
i. Ctrl + O ii. Ctrl + P
iii. Ctrl + Z iv. Ctrl + S
208 Touchpad Computer Applications (Ver. 2.0)-IX

