Electronic Spreadsheet Advanced Class 10 MCQ
Q1. _________ allows you to gather data from different worksheets into a master worksheet.
a. Data Consolidation
b. Goal Seek
c. Solver
d. Total data
Q2. Consolidate option is available under _________ menu.
a. View
b. Tool
c. Insert
d. Data
Q3. Data can be consolidated from two sheets only.(T/F)
a. True
b. False
Q4. We can consolidate data by ________
a. Row Label
b. Column Label
c. Both of the above
d. None of the above
Q5. Which of the following functions are available in consolidate window?
a. Max
b. Min
c. Count
d. All of the above
Electronic Spreadsheet Advanced Class 10 MCQ
Q6. In which option we have to specify the target range(Where we want the result to be displayed)
a. Source data range
b. Copy results to
c. Need result at
d. target range
Q7. If you select ________ then any values modified in the source range are automatically updated in the target range.
a. Link to source data
b. Link to sheet data
c. Link to original data
d. Link to source range
Q8. Which option is used to name a range of cells?
a. Range name
b. Cell Range
c. Define Range
d. Select Range
Q9. Define range option is available under ________ menu.
a. Insert
b. View
c. Developer
d. Data
Q10. The text in the row label or column label must be identical, otherwise, new row or column will be inserted.(T/F)
a. True
b. False
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Q11. SUBTOTALS _________ data arranged in an array (that is, a group of cells )
a. Add
b. Average
c. Find
d. Clear
Q12. Subtotals is available in __________ menu.
a. Tools
b. Format
c. Insert
d. Data
Q13. In Subtotals we can select up to _______ groups of arrays.
a. 3
b. 2
c. 4
d. Infinite
Q14. Identify the correct sequence
a. First open subtotals window and then select the data where we need to apply subtotals.
b. First Select data and then open subtotals window.
c. Both of the above are correct
d. None of the above
Q15. Scenarios are tool to test _________ questions.
a. if else
b. what else
c. what if
d. if
Electronic Spreadsheet Advanced Class 10 MCQ
Q16. Each scenario has a name.(T/F)
a. True
b. False
Q17. Scenario option is available in ___________________ menu.
a. Data
b. Tools
c. Insert
d. Windows
Q18. When we print a spreadsheet, only content of active scenario is printed.(T/F)
a. True
b. False
Q19. We can shift from one scenario to another by _____________
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above
Q20. We can create only 3 scenario for a given range of cells.(T/F)
a. True
b. False
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Q21. Which option is suitable to calculate the effect of different interest rates on an investment.
a. Scenario
b. Subtotal
c. Consolidate
d. None of the above
Q22. Default name of first scenario created in Sheet1 of Calc is ________
a. Sheet1_Scenario1
b. Sheet1_Scenario_1
c. Sheet_1_Scenario1
d. Sheet_1_Scenario_1
Q23. To select random multiple cell hold down ________ key as you click on each cell.
a. Alt
b. Shift
c. Ctrl
d. All of the above
Q24. Goal Seek Option available in __ menu.
a. Tools
b. Format
c. Data
d. Insert
Q25. Comment in Create Scenario dialog box is Optional(T/F)
a. True
b. False
Electronic Spreadsheet Advanced Class 10 MCQ
Q26. We can give different colors to different scenario?(T/F)
a. True
b. False
Q27. ____________ is more elaborate form of Goal Seek.
a. Scenario
b. Subtotal
c. Solver
d. All of the above
Q28. Solver option is available under _________ menu
a. Tools
b. Format
c. Edit
d. Insert
Q29. We can link one worksheet to another worksheet.(T/F)
a. True
b. False
Q30. We can not add/insert more sheets in a spreadsheet.(T/F)
a. True
b. False
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Q31. When you open a new spreadsheet, by default it has sheet named ______________.
a. Sheet1
b. Sheet_1
c. Sheet 1
d. None of the above
Q32. By default sheets tab are present at the _____________ of the spreadsheet.
a. Top
b. Bottom
c. Both of the above
d. None of the above
Q33. We can insert the new sheet in Calc by clicking on __ menu.
a. Format
b. Edit
c. Insert
d. Tool
Q34. Which of the following elements are present in “Insert Sheet” dialog box.
a. After Current Sheet
b. Before Current Sheet
c. No. of Sheets
d. All of the above
Q35. By default ________________ sheets are present in Spreadsheet.
a. 1
b. 2
c. 3
d. 4
Electronic Spreadsheet Advanced Class 10 MCQ
Q36. We can rename a new sheet in Calc.
a. After inserting a new sheet
b. While inserting a new sheet
c. Both of the above
d. None of the above
Q 37. We can rename an existing sheet in Calc by
a. Double click on one of the existing sheet
b. Right click on existing sheet and then choose rename
c. Both of the above
d. None of the above
Q 38. Formula to refer a cell A3 in sheet named S1 is
a. =S1A3
b. =S1.A3
c. =”S1″.A3
d. None of the above
Q 39. Hyperlink in Calc can be used
a. to jump from one sheet to another sheet.
b. to jump from one sheet to website
c. to jump from one section to another section of same sheet
d. All of the above
Q 40. Hyperlink in Calc can be either relative or absolute.(T/F)
a. True
b. False
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Q 41. Absolute link will stop working only if the target is moved(T/F)
a. True
b. False
Q 42. A relative link will stop working only if the target is moved.(T/F)
a. True
b. False
Q 43. If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will _____________
a. not work
b. work
c. may work
d. None of the above
Q 44. Hyperlink option is available in ______ menu.
a. File
b. Edit
c. Format
d. Insert
Q 45. Hyperlink icon is present on _________________
a. Format Toolbar
b. Standard Toolbar
c. Menu Bar
d. None of the Above
Electronic Spreadsheet Advanced Class 10 MCQ
Q 46. Hyperlink dialog box shows ___________ types of hyperlinks on left hand side.
a. 1
b. 2
c. 3
d. 4
Q 47. We can link a text in spreadsheet to any Web URL.(T/F)
a. True
b. False
Q 48. Hyperlink dialog box in Calc shows ________ options on left hand side.
a. Internet
b. Document
c. New Document
d. All of the above
Q 49. In Calc link to external data is present in _____________ menu.
a. File
b. Edit
c. Insert
d. View
Q 50. To register a data source in OpenOffice.org
a. Choose Tools -> Options -> OpenOffice.org Base -> Databases
b. Choose Tools -> Options -> Databases-> OpenOffice.org Base
c. Choose Tools -> Databases-> Options -> OpenOffice.org Base
d. None of the above
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Q 51. Spreadsheet software allows the user to share the workbook.(T/F)
a. True
b. False
Q 52. Several users can access shared workbook simultaneously.(T/F)
a. True
b. False
Q 53. Suman and her friends wants to work together in a spreadsheet. They can do so by
a. Sharing Workbook
b. Linking Workbook
c. Both of the above
d. None of the above
Q 54. In Calc “Share Document” dialog box can open by clicking on ______________ menu.
a. File
b. Edit
c. View
d. Tool
Q 55. We can not unshare a spreadsheet, once it is shared.(T/F)
a. True
b. False
Electronic Spreadsheet Advanced Class 10 MCQ
Q 56. After sharing the worksheet, the word ___________ is then shown on the title bar after the worksheet’s title
a. Sharing
b. Shared
c. Sharing Sheet
d. None of the above
Q 57. Share document option available in _____ menu
a. Tools
b. View
c. Edit
d. File
Q 58. The following features are known to be disabled in a shared spreadsheet
a. Edit > Changes, except for Merge Document
b. Insert > Names
c. Insert > Comment
d. All of the above
Q 59. Which of the following buttons are present on “Resolve Conflict” dialog box which appear during saving shared worksheet.
a. Keep Mine
b. Keep Other
c. Keep All Mine
d. All of the above
Q 60. Any cells modified by the other user in shared worksheet are shown with a ________ border.
a. Blue
b. Green
c. Red
d. Yellow
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Q 61. Which feature of Calc help to see the changes made in the shared worksheet?
a. Record Changes
b. Solver
c. Subtotal
d. None of the above
Q 62. To activate the record changes feature in shared worksheet ___________
a. Select File > Changes > Record from the menu bar.
b. Select Edit > Changes > Record from the menu bar.
c. Select View > Changes > Record from the menu bar.
d. Select Insert > Changes > Record from the menu bar.
Q 63. A __ colored border, appears around a cell where changes were made in shared worksheet.
a. Blue
b. Yellow
c. Green
d. Red
Q 64. A deleted column or row in shared worksheet is marked by a ______________ colored bar.
a. Light
b. Line
c. Solid
d. Heavy
Q 65. Record Changes feature of Calc help
a. Authors and other reviewers to know which cells were edited.
b. to record the screen
c. to make changes permanent
d. None of the above
Electronic Spreadsheet Advanced Class 10 MCQ
Q 66. Which of the following changes are not recorded in shared worksheet?
a. Changes any number
b. Changes any text
c. Cell Formatting
d. None of the above
Q 67. We can add a comment regarding any changes made in shared worksheet by
a. Edit > Changes > Comments
b. File > Changes > Comments
c. View > Changes > Comments
d. None of the above
Q 68. After adding comment to a changed cell of shared worksheet, we can see it by hovering the mouse pointer over the cell(T/F)
a. True
b. False
Q 69. Anil is the author of shared worksheet so he has the right to accept or reject changes made by the reviewers.(T/F)
a. True
b. False
Q 70. “Accept or Reject Changes” dialog box (for shared worksheet) can be opened by clicking on
a. File > Changes > Accept or Reject.
b. Edit > Changes > Accept or Reject.
c. View > Changes > Accept or Reject.
d. None of the above
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance on Electronic Spreadsheet Advanced Class 10 MCQ
Q 71. Worksheets can be merged from ____________________ menu.
a. Edit
b. File
c. View
d. Tools
Q 72. When sharing worksheets authors may forget to record the changes they make. Calc can find the changes by __________ worksheets
a. duplicating
b. comparing
c. checking
d. None of the above
Q 73. Edited worksheet can be compared with the original worksheet by selecting.
a. File –> Compare Document
b. Edit –> Compare Document
c. View –> Compare Document
d. Tools –> Compare Document
Q 74. A _____________ is a saved sequence of commands or keystrokes that are stored for later use
a. Solver
b. Autosum
c. Consolidate
d. Macro
Q 75. Macros are especially useful to ___________ a task.
a. do
b. repeat
c. simplify
d. complicate
Electronic Spreadsheet Advanced Class 10 MCQ
Q 76. Use ___________ Macro to start the macro recorder.
a. Tools > Macros > Record Macro
b. Tools > Record > Record Macro
c. Data > Macros > Record
d. None of the above
Q 77. Click _____________ to stop the macro recorder
a. Close Recording
b. End Recording
c. Stop Recording
d. None of the above
Q 78. To edit macro, go to
a. Tools –> Macros — > Edit Macros
b. Edit –> Macros — > Edit Macros
c. View –> Macros — > Edit Macros
d. None of the above
Q 79. Function names in Calc are not case sensitive.(T/F)
a. True
b. False
Q 80. When a document is created and saved, it automatically contains a library named ___
a. Module Library
b. Macro Library
c. Standard
d. None of the above
Electronic Spreadsheet Advanced Class 10 MCQ
Click here to check your performance Electronic Spreadsheet Advanced Class 10 MCQ
Disclaimer : I tried to give you the correct Questions and Answers of “Electronic Spreadsheet Advanced Class 10 MCQ ” , but if you feel that there is/are mistakes in the Questions or Answers of “Electronic Spreadsheet Advanced Class 10 MCQ “ given above, you can directly contact me at csiplearninghub@gmail.com. Also Share your feedback regarding “Electronic Spreadsheet Advanced Class 10 MCQ “ so that I can give better content to you.
This is the best.
Never Gonna give you up…
Thankyou so much Rick.
No 53 recheck karna please
Hi Guddu, Answer is correct.
Pls check 73ans. Ithink its wrong
73 is correct
Never gonna let you downnnnnn
sir its realy very helpfull with me and i am from rajasthan in bandikui in delhi public school bandikui so thank u so much for this site
it helped so much, thanks
Thankyou Mehak
Thank you, it helped me a lot for my Board Examinations. All the Best for your future articles. Thank you once again!! Actually it was suggested by my teacher. Sorry, I am not putting my real name.
All the best for your exams.
Sir please check the 8th question
It should be cell range
Hi Nishant, Answer is correct.
Sir aap bahaut ache mcq bnate ho ,par sir mycstutorial.in aapke mcq copy krta h
Thankyou so much for your feedback
Sir mycstutorial.in aapke mcq copy krta h
Thank u sir….. It Was helpful
My Pleasure Sumitha.
Very Helpful To me
Thankyou Very much for this .
🙏🙏🙏🙏
Can you pls check Qs. 38?
it is correct
Same here was recommended by my teacher.
its very helpful MCQ
thanks
Because of this we can remember well
This website helped me a lot to study for my IT exams.
Than you!
All the best Aaditya for your exams.
I think the answer to question 38 should be option B
sir isko padke full marks aa jayneg kya
Q 38. Formula to refer a cell A3 in sheet named S1 is
a. =S1A3
b. =S1.A3
c. =’S1′.A3
d. None of the above
Hide Answer
Ans. c. =’S1′.A3
Answer should be B)
Because while referencing a sheet with a space only quotations will come.
Eg: =’sheet marks’.F3
But for a sheet with only one word,quotations wont come.
Eg: =sheet.F3
So answer should be B.
Please change it.
Thankyou so much for the feedback. I corrected my typing error.
noo, the answer should be 3rd only, we always use quotation mark with sheet name.
Thank you so much sir for making mcqs for each subtopic of this chapter. It really helped me a lot in my board examinations!
Tomorrow is my exam . It helps me lot.
Thanks sir it is very helpful for me
thanks i think it would help for my board exams tooo
bye thnx
These MCQs are really helpful for me to score good marks in exam ……..
Thanks for these Questions…
very helpful…..thnkew
Thank you sir 😊😊
Aahh, this is a wonderful IT MCQ questions website. I am loving all the stuff right in here and it also helped me to read so much for my Term 1 exam’s! Thank you CS IP learning hub. Keep up the good work.
thank you so much its a great helping for me thanks for give us this
in q76. it should be Tools -> Macro -> Record Macro..Please check because in book its written
Hi Bhavya
Thanks for your feedback.
Regards
Hi sir thank you so much for providing these mcq’s it helped us a lot
And please kindly check ques no 40 i think the answer should be false because calc always display absolute hyperlink
very helpful sir, Thanks alot.. for making such sites as free. 🙂
Q55 we cannot unshare a shared document that is true
q 55 is wrong please check
Q.55 is wrong plz correct it 😡 otherwise it is perfect 😁
Hi Atharva, Q55 is correct