Page 253 - Trackpad 402_Class-X_Final
P. 253
6. Which function cannot be performed through Subtotal in a Spreadsheet? [CBSE Sample Paper 2022]
a. Sum b. Product
c. Average d. Percentage
7. Which type of questions are tested by using the Scenarios?
a. Auto b. Short
c. What-if d. Long
8. It refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to
calculate. [CBSE Sample Paper 2022]
a. Row b. Column
c. Autosum d. Cell Reference
9. Which of the following is more elaborate form of Goal Seek? [CBSE Sample Paper 2022]
a. Subtotal b. Scenario
c. Solver d. Consolidate
10 means combining data in a spreadsheet from different worksheets into master worksheet.
[CBSE Sample Paper 2022]
a. Hyperlinks b. Consolidating
c. Linking d. Filter
11. Which of the following is the correct step to record changes?
a. Edit → Changes → Record b. File → Changes → Record Changes
c. Tools → Changes → Record Changes d. Data → Changes → Record Changes
12. Which of the following menu contains the Subtotal option?
a. File b. Data
c. Tools d. Insert
13. Which of the following is not an example of cell referencing?
a. A1:B6 b. G6
c. C10:C20 d. 7Q
14. Which of the following is not present in the Insert Sheet dialog box?
a. Before current sheet b. After current sheet
c. New Sheet d. Create
15. Which of the following options is used to share a worksheet?
a. Share Document b. Share Worksheet
c. Share d. None of these
Ans. 1. c 2. d 3. b 4. b 5. c 6. d 7. c 8. d 9. c 10. b 11. a 12. b 13. d 14. d 15. a
B. Fill in the blanks.
1. and are some of the important data analysis tools available in OpenOffice spreadsheet.
2. Groupwise calculation of sum, average, max, min, count etc. can be done by using the option of OpenOffice
calc.
3. are what-if analysis tools of OpenOffice Calc that helps you set multiple values for the same cell.
4. tool helps you do backward calculation of the input to obtain the desired output.
5. Macros are present in menu.
6. Comments option is present under the menu.
7. option is used to combine two worksheets.
8. A saves you from the tedious repetitive tasks.
9. The Run Macro option under the menu is used to run a macro.
Electronic Spreadsheet (Advanced) 253

