Ans. Solver option under Tools menu is a more elaborate form of Goal Seek. The difference is that the Solver deals with equations with multiple unknown variables.
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”?
Ans. An absolute link will stop working only if the target is moved. A relative link will stop working only if the start and target locations change relative to each other.
Q17. In Spreadsheet Hyperlink icon is present on ___________________ toolbar.
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?
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.
Ans. We can use a shared worksheet in unshared mode by saving the shared worksheet using another name or path. This creates a copy of the spreadsheet that is not shared.
Q35. What is a Record Changes feature in Open Office Calc?
Ans. Record Changes feature is used to track what data was changed, when the change was made, who made the change and in which cell the change has occurred.
Q36. Write the steps to turn ON the “Record Changes” feature in Calc?
Ans. A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.
Ans. Hyperlinks 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 web sites
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