Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 48 - logicode 2609 C6
P. 48

    b.   Ramesh wants to show how two different variables, such as advertising spend and sales revenue,
                            are related to each other. Which type of chart is most suitable for this purpose?

                         c.   Anjali has data on the monthly temperature and rainfall for her city over the past year. She wants to
                            analyse the relationship between temperature and rainfall to see if there is any correlation between
                            the two. Which type of chart should she use, and why?
                         d.   Manoj is a teacher who wants to track the progress of his students' scores in multiple subjects over
                            the entire academic year. He has data for each subject for every month. Which type of chart would
                            best help him identify trends and patterns in student performance over time, and why?
                         e.   A student is trying to read the values of a line chart easily. The chart has horizontal and vertical lines
                            in the background. What are these lines called and how do they help?

                         f.   Sara has recorded the scores of her classmates in a test and wants to highlight the scores that are
                            above 90. Which Excel feature can she use to achieve this?
                         g.   Raj needs to create a dataset with names and scores of students. Use the IF() function to label each
                            student as “Pass” if their score is 60 or above, and “Fail” if below.

                         h.   Sonal has a student mark list sorted by Roll No., but she now wants it sorted by Name without dis-
                            turbing the Roll No. order. Which Excel feature should she use and how?
                         i.    Amit applied filters on his sales data to see certain products but now wants to see all the data again.
                            What steps should he follow in Excel to remove the filters?

                         j.    Riya has a list of students’ marks in Excel. She wants to highlight all scores above 80 with a special
                            color. How can she use Conditional Formatting to do this?

                                                                                                  21 st
                         LAB ACTIVITY                                                           Century   #Technology Literacy
                                                                                                 Skills
                          Visit your computer lab and perform the following actions:
                          ▶  Open MS Excel and perform the following tasks:
                               Enter the following data in Excel:

                          ▶  Now, select the data and click on the Insert tab to create the following charts:
                                 Histogram                               Frequency polygon

                                 Pie chart                               Column chart
                              Move and resize the charts to make them fit accordingly.

                                After the charts have been created, change the background of the charts by using the Format tab
                          and add any picture or texture.

                       46   Premium Edition-VI

| 43 44 45 46 47 48 49 50 51 52 53 |