Page 200 - Computer - 10(A&B)

3. A ___________ is the process of calculating a value by performing what-if analysis on a given set of
values.

Scenario Data table
Goal Seek Data consolidation
4. ___________ is useful when user wants to pull the required information from different locations
without retyping and recalculating.
Autocorrect Auto-analysis Linking Auto-calculate

5. An ___________ hyperlink is a hyperlink that contains the full address of the destination file or of the
website.
relative absolute mixed none of these

6. When we share a workbook, the word ____________ will appear on the title bar beside workbook’s
name.

reviewed share commented shared
7. ________ command automatically add subtotals and grand totals to a list of data.

Grandtotal Subtotal Total Solver
8. ___________ is a tool to test “what-if” questions.
Scenario Solver Macro Average

9. Rohit scored 25 out of 30 in English, and 22 out of 30 in Maths. He wants to calculate the score in IT
he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following
to do so.
Macro Solver Goal Seek Sub Total

B. Fill in the blanks.
1. When you collaborate with others, you may be required to work on the _____________ Calc sheet.

2. A _________ is a set of values that Calc saves and can substitute automatically on your worksheet.
3. Using _____________, multiple people can work on the same workbook at the same time.
4. A user should always _____________ the shared document before changing any value.

C. Very short answer type questions.
1. Define hyperlink.
2. Name the two types of hyperlink.
3. What is a macro?

4. In order to apply SUBTOTAL feature, what other filter has to be applied on the data?
5. What category do Goal Seek, Solver, and Scenarios fall under?

6. On what kind of data can Goal Seek be applied?

D. Short answer type questions.
1. Write a short note on ‘Sharing a Workbook’.
2. Write the steps to share a Calc workbook.

3. What is the advantage of sharing a workbook?

82