Page 259 - Trackpad 402_Class-X_Final
P. 259

B.  Long answer type questions.

               1.  List down the issues that you may face at the time of saving a shared document.
               2.  What is the need of creating Hyperlinks?
               3.  Give the steps to sort the data using a Macro.
               4.  Give the steps to link to an External Data source.
               5.  How do you access the code window of a macro?
               6.  From where cell reference can be taken?
               7.  Write the names of the options of the Goal Seek dialog box. Give example of each.
               8.  What do you mean by Data Analysis? Why is it important? Write the names of the tools used in Data Analysis.

                                                                                       21 st   #Communication
            C.   Competency-based/Application-based questions:                       Century
                                                                                       Skills  #Leadership & Responsibility
               1.  Amit wants to combine and find the average of marks obtained by his five friends in the previous three periodic tests. The
                  data is stored in various sheets of a workbook. Which tool is best suited for him? Write the steps also to simplify his work.
               2.  Sunil wants to do the same set of tasks to make his project in Maths, Science and Social Science at the end of Term I. The
                  tasks are repeated formatting or applying a similar formula in a similar range of data. Suggest him a suitable tool for that.
                  Give the steps to simply the job.
               3.  Rohit scored 25 out of 30 in English and 22 out of 30 in math. He wants to calculate the score in IT to achieve 80 percent in
                  aggregate. Suggest to him the appropriate what-if analysis tool to get the desired result. Provide the steps for implementing
                  it in a spreadsheet to achieve the aforementioned percentage.
               4.  Krish and Kritika have done a survey of age-wise literacy rates of their locality as a school project, which they have created
                  in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access
                  the same Spreadsheet to speed up their work. Also give the steps to make a shared document.
               5.  Rohan wants to buy a birthday gift for his friend only using his pocket money. He gets Rs. 500 per month. He plans to spend
                  200 and save 300 so that he can buy a book for his friend. When he went to the market he found that the book is for Rs.
                  275. Name the what-if analysis tool that he will use to find the money which now he can afford to spend.
               6.  Raj has created a worksheet where he has added all the information of his employees. He wants every employee to go
                  through the worksheet and update their address and phone number, if required.
                  a.  Which feature of the spreadsheet should they use to see the changes made by his employees?
                  b.  Give the steps to use the above feature in spreadsheet.
                  c.  If he needs to add comments for the changes made then give the steps to do so.
                  d.  What are the steps if he wishes to make the changes permanent?
               7.  Sneha wants to use OpenOffice Calc for calculation and data analysis of her targets given to her by her boss in the company.
                  She is actually new to the software and needs some help in using some of its features. Help her out by giving the steps for
                  the following tasks:
                  a.  How can she add more sheets to the same worksheets?
                  b.  She wants to rename the existing worksheets.
                  c.  Delete the unwanted sheets.
                  d.  Adding a hyperlink to connect to the company's web address.


                                            Previous Years' Questions


               1.                function takes data from a series of worksheets or workbooks and summaries it into a single worksheet
                  that you can update easily.                                                                  [2022]
                  a. Summation                                      b. Data Consolidation
                  c. Data Format                                    d. Data Chart
               2.  If you are continually working with the same range, then you may give a name to the range using    option
                  under Data Menu.                                                                             [2022]
                  a. Define data                                    b. Define range
                  c. Define reference                               d. Define address



                                                                                 Electronic Spreadsheet (Advanced)  259
   254   255   256   257   258   259   260   261   262   263   264