Page 290 - TP_IT_V1.0_C10_flipbpookl
P. 290
12. How many sheets are provided by default in spreadsheets in a workbook? [2023]
13. Record changes feature of Calc marks a deleted column or row in a worksheet by a . [2023]
a. red border over the cell b. green border over the cell
c. red shade in the cell d. heavy colored bar
14. Give an example of statistical function in Calc. [2023]
15. Explain the following w.r.t. spreadsheets :
a. Scenario
b. Goalseek
16. function takes data from a series of worksheets or workbooks and summaries it into a single worksheet
that you can update easily. [2022]
a. Summation b. Data Consolidation
c. Data Format d. Data Chart
17. If you are continually working with the same range, then you may give a name to the range using option
under Data Menu. [2022]
a. Define data b. Define range
c. Define reference d. Define address
18. 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
19. 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
20. Usually, you run a formula to calculate a result based upon existing values. By contrast, using , youcan
discover what values will produce the result that you want. [2022]
a. Subtotal b. Scenario
c. Sort Lists d. Goal Seek
21. 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
22. 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
23. 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
24. 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
25. Arguments passed to a macro from Calc are always . [2022]
a. Strings b. References
c. Numbers d. Values
288 Trackpad Information Technology (Ver. 1.0)-X

