Electronic Spreadsheet Advanced Class 10
Q1. What is Data Consolidation?
Q2. Consolidate option available in ___________ menu.
Q3. Write two functions which are available in function list of Consolidate data dialog box.
a. Sum b. Max c. Min d. Average
Q4. What do you mean by range of cells?
Q5. How can you give name to a range of cells?
Electronic Spreadsheet Advanced Class 10
Q6. What is Subtotal in Spreadsheet?
Q7. Subtotal option available in ___________ menu.
Q8. ___________ are a tool to test “what-if” questions.
Q9. Write the steps to create Scenario.
a. Select the cells that contain the values that will change between scenarios. b. Choose Tools > Scenarios c. On the Create Scenario dialog , enter a name for the new scenario. d. Click OK to close the dialog.
Q10. Define the term Goal Seek in reference to Spreadsheet.
Electronic Spreadsheet Advanced Class 10
Q11. Match the following
| Option | Menu |
| Subtotal | Tool Menu |
| Goal Seek | Data Menu |
| Scenario | Data Menu |
| Consolidate | Tool Menu |
| Solver | Tool Menu |
Option Menu Subtotal Data Menu Goal Seek Tool Menu Scenario Tool Menu Consolidate Data Menu Solver Tool Menu
Q12. What is Solver in Spreadsheet?
Q13. How can you insert a new sheet?
a. select the sheet that will be next to the new sheet. b. Select Insert > Sheet from the menu bar.
Q14. How can you rename a sheet?
a. Double-click on one of the existing worksheet names. b. Right-click on an existing worksheet name, then choose Rename from the resulting Context menu. c. Select the worksheet you want to rename and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.
Q15. How can you reference the ‘F4’ cell of a sheet named “Class X”?
Electronic Spreadsheet Advanced Class 10
Q16. What is the difference between Relative and Absolute hyperlink?
Q17. In Spreadsheet Hyperlink icon is present on ___________________ toolbar.
Q18. In Spreadsheet Hyperlink option is present in ___________________ menu.
Q19. Write the steps to share spreadsheet with others.
a. Open the sheet to be shared b. Tools > Share Document c. A dialog box opens. d. To enable sharing, select the box at the top of the dialog, and then click OK
Q20. Write the steps to add comment to a shared spreadsheet.
a. Make the change to the spreadsheet. b. Select the cell with the change. c. Choose Edit > Changes > Comments d. Type your own comment and click OK.
Electronic Spreadsheet Advanced Class 10
Q21. How can you edit the entered comment?
1 Select the cell with the comment that you want to edit. 2. Select Edit > Changes > Comments. 3. Edit the comment and click OK.
Q22. Intersection of row and column is called ____________
Q23. Formula in spreadsheet begin with _________ sign.
Q24. Parth scored 130 in Term1 and 140 in Term2 (out of 150 ). How much will he score in Term3 so that the aggregate becomes 80%. Which option will help him to find?
Q25. __________________ option under Tools menu is a more elaborate form of Goal Seek.
Electronic Spreadsheet Advanced Class 10
Q26. _______________ are predefined formulas in Calc.
Q27. ___________ is the top most bar of Calc Window.
Q28. Shortcut to open Function Wizard is __________
Q29. Suman wants to share her worksheet with others but she wants to protect her worksheet so that no one can make unnecessary changes. Help her to find such option.
Q30. A cell in the spreadsheet with dark boundary is called ______
Q31. Write the steps to open consolidate dialog box in OpenOffice Calc.
Q32. Write any four statistical functions available in Consolidate dialog box.
Q33. Which command can be used to switch the mode for a worksheet from unshared to shared and vice-versa?
Q34. How can we use a shared worksheet in unshared mode?
Q35. What is a Record Changes feature in Open Office Calc?
Q36. Write the steps to turn ON the “Record Changes” feature in Calc?
Q37. What is cell reference?
Q38. Write two ways of referencing other sheets.
Q39. What is the use of Hyperlink in Calc?
Disclaimer : I tried to give you the correct Questions and Answers of “Electronic Spreadsheet Advanced Class 10 ” , but if you feel that there is/are mistakes in the Questions or Answers of “Electronic Spreadsheet Advanced Class 10 “ given above, you can directly contact me at csiplearninghub@gmail.com. Also Share your feedback regarding “Electronic Spreadsheet Advanced Class 10 “ so that I can give better content to you.
the answer for 38th question is not opening . Pls solve this problem and this website is very much useful , thank you guys
👍🏻🖕🏻🖕🏻🖕🏻🖕🏻🌪️
You good bro?
Best learning material is provided and this needs a lot of effort.
Thank you
Wanna score good in IT…?! You’ve already reached the best way that will lead you to ur destination
THIS LEARNING MATERIAL IS VERY USEFUL AND HELPFUL THANKS A LOT FOR YOUR HARDWORK. IF YOU LEARN THIS MATERIAL 50 OUT OF 50 IS POSSIBLE
Sir I have a request check question number 37
Cell reference
Thank you for this all
It helps me
38. Two ways to reference cells in other sheets are – by entering the formula directly using the keyboard , or by using the mouse.