Page 282 - TP_IT_V1.0_C10_flipbpookl
P. 282
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. b 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 LibreOffice spreadsheet.
2. Groupwise calculation of sum, average, max, min, count etc. can be done by using the option of LibreOffice
Calc.
3. are what-if analysis tools of LibreOffice 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. is a feature that allows you to jump to a different location from within a spreadsheet.
6. Comments option is present under the menu.
7. refers to the process of combining data from multiple sheets of the spreadsheet into a single sheet.
8. A saves you from the tedious repetitive tasks.
9. The Run Macro option under the menu is used to run a macro.
10. The values written within the circular brackets of the function are called .
Ans. 1. Data consolidation and Goal Seek 2. Subtotal 3. Scenarios 4. Goal Seek 5. hyperlink
6. Insert 7. Data consolidation 8. Macro 9. Tools
10. Arguments
C. State whether these statements are true or false.
1. Renaming a sheet can also be done using Tools Menu.
2. Relative hyperlink contains a full URL.
3. Filter feature is used to extract data using some conditions on columns.
4. A What-if scenario is a collection of values applicable for calculations in a spreadsheet.
5. Link to source data is checked updates the target sheet if any changes made in the source data.
6. A Macro helps you save time as the long and time consuming tasks are saved as macros and can be
executed with a click of a button.
7. What-if analysis tool uses only one array of cells.
8. Compare Document option is used to merge two worksheets.
9. Data found in the edited version but not in the original is marked as inserted.
10. The Range option allows to show the changes made in the specified range of cells.
Ans. 1. False 2. False 3. True 4. True 5. True 6. True 7. False 8. False 9. True 10. True
280 Trackpad Information Technology (Ver. 1.0)-X

