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 ______


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.



Share with others

Leave a Reply

%d bloggers like this: