# CBSE Class 10 Information Technology [IT] Electronic Spreadsheet Calc MCQs Notes

## CBSE Class 10 Information Technology [IT] Electronic Spreadsheet Calc MCQs Notes

IT-402/Class X /Part B,Unit-2 (Electronic Spreadsheet-Calc)

Question/Correct Answer /Type (Knowledge based/ Conceptual/Understanding/Reasoning Based/Skill Based)

Q1. Which feature of Calc is used to combine data spread across many worksheets in one sheet?

1. Subtotals
2. Data Consolidation
3. Sum
4. Scenarios

b.Data consolidation

Knowledge Based

2. Which among the following is an elaborate form of Goal seek and deals with multiple unknown variables?

1. Solver
2. Subtotal
3. Macro
4. Average
1. Solver

Understanding

3. Which type of hyperlink will stop working, if the target location is moved to a new location?

1. Relative
2. Absolute
4. Outside
1. Absolute

Skill

4. What is the name of the automatically created library which gets automatically loaded when the document is opened or when a document is created and saved in Calc?

1. Customised
2. Standard
3. Xls
1. Standard

Knowledge

5. Which menu and option is used to share a workbook by multiple people at the same time?

1. Toos🡪Merge document
2. Tools🡪 Shared document
3. Format🡪Share
4. None of these
1. Tools🡪Share document

Knowledge

6. In the ________tool, you may maximise, minimise the result according to a set of rules that you define.

1. Solver
2. Subtotal
3. Scenario
4. None of these
1. Solver

Concept Based

7. In the Hyperlink dialog box of Calc software, which options are displayed in the left side?

1. Internet
2. Document
3. New Document
4. All of the above
1. All of the above

Knowledge

8. Nehal and Nikita were sharing worksheets; but they forgot to record the changes they made.

How the Calc software can help them to find the changes done in worksheets?

1. By duplicating
2. By comparing
3. By checking

d) By sharing

b. By comparing

Understanding

9. Which of the following function, adds data arranged in arrays and then choose statistical function to apply to them?

1. Consolidation
3. Subtotal
4. Scenario

c. Subtotal

Understanding

10. Which of the following tool does not falls under ‘what if analysis’?

1. Macros
2. Scenarios
3. Goal Seek
4. Solver
1. Macros

Understanding

11. Under which menu do you find Goal Seek option?

1. Tools
2. Format
3. Data
4. Insert
1. Tools

Knowledge

12. How can you switch between scenarios?

1. Find and replace
2. Data Source
3. Navigator
4. None of the above
1. Navigator

Knowledge

13. Which tool is used to find the result by adjusting an input value?

1. Goal seek
2. Solver
3. Target value
4. None of these

options

1. Goal seek

Skill

14. What formula would be written to refer to a cell B1 in a sheet named savings.

1. =savingsB1
2. =savings.B1
3. =’savings’.B1
4. =”savings”.B1
1. =savings.B1

Skill

15. Which of the following changes are not recorded in shared worksheet?

1. Change any number
2. Change any text
3. Both a) and b) option
4. Insert any Picture
1. Insert any picture

Knowledge based

16. Which of the following is not a correct method of renaming a sheet in Calc?

1. Double click in the sheet name
2. Right click in sheet name and rename
3. Format🡪Rename
4. Edit🡪Rename
1. Edit🡪 Rename

Knowledge based

17. Which option should be selected in Data Consolidation dialog box to automatically update the target range when any values are updated in the source range?

1. Row labels
2. Column labels

Understanding

18. If you are continuously working with the same range, then what should be preferably be used to refer that range?

2. Data range
3. URLs
4. Define Range
1. Define range

Understanding

19. In Scenario dialog box, if you do not select this option, the scenario is not changed when you change cell values..

What is that option?

1. Display border
2. Copy back
3. Copy entire sheet
4. No Update
1. Copy back

Concept based

20. Calc provides a feature to review all the changes at once when multiple reviewers return edited versions of a worksheet at the same time.

What feature can be used?

1. Edit🡪Changes🡪Merge Document
2. Edit🡪Changes🡪Record
3. Edit🡪Changes🡪Merge
1. Edit🡪Changes🡪 Merge Document

Knowledge

Competency Based Questions

1. Rohit have two spreadsheets in the same folder linked to each other.

What will happen to the relative hyperlink, if he moves the entire folder to a new location?

1. The link will not work
3.  The link will be deleted

d) None of the above

2. Ms.  Neha entered some data in a Calc worksheet1 and applied some functions, formulas and formatting.

She wants to repeatedly use those functions/formulas and formatting used in worksheet1 in other sheets too.

Which feature of Calc should she use to do the task?

1. Editing
2. Formatting
3. Macro
4. Functions
1. Macro

The coach has submitted a budget to him for the season and he edits the cost and returns it back.

Mr Sandeep is concerned that whatever changes he is doing in the budget, will  that changes be easily  visible to the coach?

So he decided to use Calc, but what feature should be turned on, so that the changes made by Sandeep are easily visible to the coach?

2. Edit🡪Changes🡪Accept
3. Edit🡪Changes🡪Record
4. None of these
1. Edit🡪Changes🡪Record

4. Neel wants to calculate the interest amount.

Initially he has 20000 as Principal amount, rate of interest as 5% and Time is 3 years.

But he wants to see the changes that will result in interest amount by changing the principal amount from 20,000 to 50000 and then by 75000.

Which feature of Calc should he use to see the effect of changing the Principal in the investment amount?

1. Goal Seek
2. Scenarios
3. Average
1. Scenarios

5. Rohit, Mohit and Prashant are working in K& S co. Ltd. As Sales executives. The company wants to find the total sales done by them month wise.

Which feature of Calc should the company use or employ for finding the sales done by the salesman in different months e.g. Total Sales for the month of October, November and December etc. ?

1. Data Consolidation
2. Pivot Table
3.  Sum
4. Subtotal
1. Subtotal