Home > CBSE IT 402 > Quizzes > IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 39% Most missed: “We can not add/insert more sheets in a spreadsheet.”

Libreoffice Calc, Openoffice...

Related test: IT-402 Electronic Spreadsheet Class 9 Practice Test

IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test
Time left 00:00
25 Questions

1. The following features are known to be disabled in a shared spreadsheet
2. Identify the correct sequence
3. Which option is suitable to calculate the effect of different interest rates on an investment.
4. After adding comment to a changed cell of shared worksheet, we can see it by hovering the mouse pointer over the cell
5. Default name of first scenario created in Sheet1 of Calc is ________
6. SUBTOTALS _________data arranged in an array (that is, a group of cells )
7. Goal Seek Option available in __menu.
8. A _____________is a saved sequence of commands or keystrokes that are stored for later use
9. We can insert the new sheet in Calc by clicking on __menu.
10. We can not unshare a spreadsheet, once it is shared.
11. Define range option is available under ________menu.
12. In Subtotals we can select up to _______groups of arrays.
13. Anil is the author of shared worksheet so he has the right to accept or reject changes made by the reviewers.
14. A __colored border, appears around a cell where changes were made in shared worksheet.
15. Spreadsheet software allows the user to share the workbook.
16. ____________is more elaborate form of Goal Seek.
17. Macros are especially useful to ___________a task.
18. Subtotals is available in __________menu.
19. Scenario option is available in ___________________menu.
20. We can rename an existing sheet in Calc by
21. We can shift from one scenario to another by _____________
22. By default sheets tab are present at the _____________of the spreadsheet.
23. Suman and her friends wants to work together in a spreadsheet. They can do so by
24. To select random multiple cell hold down ________ key as you click on each cell.
25. When sharing worksheets authors may forget to record the changes they make. Calc can find the changes by __________worksheets