Page 201 - Computer - 10(A&B)

4. What is the use of macro recorder in Calc?

5. Why is Goal Seek valuable in a spreadsheet application?
6. How can you add comment to a cell in Calc?
7. What is the location of Goal Seek feature in Calc sheet?
8. What is the use of file sharing?

E. Long answer type questions.

1. What is macro recorder? How will you create a macro to sort the columns?
2. How will you create a macro as function?

Experiential Learning
D
DIY in the LabIY in the Lab Experiential Learning
v Open a workbook and prepare a time table of your class. Now, share the workbook with your friends and
allow changes by them on the worksheet. Now, add one more subject ‘Information Technology’ by some
other user on the shared workbook and observe the changes carefully.
v Create a simple case of evaluation of rate of interest given by a bank based on principal, time (in number of
years), and interest calculated. Assume that the interest is simple interest. Use Goal Seek feature to display
a pre-defined interest amount.
v Consider a company that wants to buy raw materials for their organisation’s needs. Due to the scarcity of
funds, the company wants to understand how much cost will happen for different possibilities of buying.

Product Name Cost No. of units Cost of total units
Product 1 1,000 20

Product 2 1,200 13
Product 3 1,400 15

Fun Time Critical Analysis
Fun Time
Critical Analysis

v Arjun’s monthly sales amounts for the first half of the year as shown in the sheet. If he reaches a
` 200,000 mid-year average, he will receive a 5% bonus. Use Goal Seek to find how much he needs to
sell in June in order to make the ` 200,000 average.

83