Page 260 - Trackpad 402_Class-X_Final
P. 260
3. In Calc, using the Subtotals dialog, you can select arrays and then choose a statistical function to apply to them. For
efficiency, you can choose up to groups of array to which to apply a function. [2022]
a. two b. three
c. four d. five
4. Solver option under Tools menu amounts to a more elaborate form of . The difference is that the Solver
deals with equations with multiple . [2022]
a. Unknown variables, Goals Seek b. Variables, Equation
c. Goal Seek, Unknown variables d. Subtotal, Goal seek
5. Usually, you run a formula to calculate a result based upon existing values. By contrast, using, you can discover what values
will produce the result that you want. [2022]
a. Subtotal b. Scenario
c. Sort Lists d. Goal Seek
6. Rama and two of her friends are doing survey of gender wise employment rates of their locality as a school project using
Spreadsheet. They all want to work simultaneously to complete it on time. What option they should use to access the same
Spreadsheet to speed up their work. [2022]
a. Consolidate Worksheet b. Shared Worksheet
c. Link Worksheet d. Lock Worksheet
7. In Calc, you can use a cell reference in one or several formulas to refer to: [2022]
a. Data from one or more contiguous cells on the worksheet b. Data contained in any Software
c. Data contained in any format in databases d. Images in picture gallery
8. In Calc, to create the reference with the mouse: [2022]
a. Both Spreadsheets need not be open b. Select the cell in which the formula is going to be entered
c. There is no need of symbol d. Cell reference is not required
9. can be used in Calc to jump to a different location from within a spreadsheet and can lead to other parts
of the current file, to different files or even to websites. [2022]
a. Tables b. Goal Seek
c. Auto Sum d. Hyperlinks
10. In Spreadsheets,
Statement I: To consolidate by row labels or column labels, the label must be contained in the selected source ranges.
Statement II: The text in the labels must be identical, so that rows or columns can be accurately matched.
Statement III: If the row or column label does not match any that exist in the target range, it will be appended as a new row
or column.
Consider the above three statements, identify the correct one. [2022]
a. Only Statements I and II are correct b. Only Statements II and III are correct
c. Only Statement II is correct d. All the Statements are correct
11. Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet.
Statement II: If you later open a worksheet in which consolidation has been defined, this data will not be available again.
Consider above two statements, identify the correct one. [2022]
a. Statement I is wrong b. Statement II is wrong
c. Both the Statements I and II are wrong d. Both the Statements I and II are correct
12. Rohan has 50,000 that he wants to invest in two mutual funds for one year. Fund A is a low risk fund with 18% interest rate
and Fund B is a higher risk fund with 21% interest rate. Which feature of spreadsheets (Calc) will be help him to decide
[2022]
a. Solver b. Subtotal
c. Linking sheets d. Macros
13. is one of the functions available in the spreadsheet to perform addition of selected numbers in the sheet.
[2020]
260 Trackpad Information Technology-X

