Electronic Spreadsheet Advanced Class 10 Important Questions & Answers

Share with others

Electronic Spreadsheet Advanced Class 10

Electronic Spreadsheet Advanced Class 10
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.

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.

Q10. Define the term Goal Seek in reference to Spreadsheet.

Electronic Spreadsheet Advanced Class 10

Q11. Match the following

OptionMenu
SubtotalTool Menu
Goal SeekData Menu
ScenarioData Menu
Consolidate Tool Menu
SolverTool Menu
Electronic Spreadsheet Advanced Class 10

Q12. What is Solver in Spreadsheet?

Q13. How can you insert a new sheet?

Q14. How can you rename a sheet?

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.

Q20. Write the steps to add comment to a shared spreadsheet.

Electronic Spreadsheet Advanced Class 10

Q21. How can you edit the entered comment?

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.


Electronic Spreadsheet Advanced Class 10

Electronic Spreadsheet Advanced Class 10

Electronic Spreadsheet Advanced Class 10


Share with others

6 thoughts on “Electronic Spreadsheet Advanced Class 10 Important Questions & Answers”

  1. 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

    Reply

Leave a Reply

error: Content is protected !!