Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 32 - 2612 Digimind C6
P. 32

    1.  Tick ( ) the correct option.

                         a.  Anaya is preparing a sales report in Excel. She wants to show the comparison of sales using long
                            rectangular rods placed horizontally. Which chart should she use?

                             (i)  Column Chart                              (ii)  Bar Chart
                            (iii)  Line Chart                               (iv)  Pie Chart

                         b.  While creating a chart for her project, Priyanka adds a heading at the top to explain what the chart
                            is about. Which chart component helps describe the main purpose and content of the chart?

                             (i)  Legend                                    (ii)  Data Series
                            (iii)  Title                                    (iv)  Gridlines

                         c.  Rahul has already created a chart in Excel, but now he wants to change it from a column chart to a
                            pie chart. Which tab should he select to change the type of an existing chart?

                             (i)  Insert                                    (ii)  Design
                            (iii)  Format                                   (iv)  Chart Design

                         d.  Meera wants to create a chart in Excel using her marks data. Before choosing any chart type, what
                            should be the first step she must follow?

                             (i)  Select the data range                     (ii)  Click on the Insert tab
                            (iii)  Choose the desired chart                 (iv)  Click on the Chart Design tab

                         e.  Aarav is designing a chart that looks like a circle divided into slices to show different portions of data.
                            Which chart type should he choose?

                             (i)  Area Chart                                (ii)  Doughnut Chart
                            (iii)  Pie Chart                                (iv)  Scatter Chart

                      2.  Fill in the blanks using the words from the help box.

                                                       Shift, Line, X, Gridlines, Legend

                         a.  The ______________ axis is also known as the category axis.
                         b.  A ______________ chart displays continuous data at regular intervals.

                         c.  The ______________ of a chart displays the symbols or colors used in the chart.
                         d.  ______________ can be either horizontal or vertical lines that make it easier to read and understand
                            values in a chart.

                         e.   To resize a chart proportionally, select the chart then press and hold the ______________ key while
                            dragging.

                      3.  Answer in one or two words.
                         a.  What is another name for the Y-axis in a chart?                                 ___________
                         b.  Which type of chart is also known as a frequency polygon?                       ___________
                         c.  Which chart displays the relationship of parts to a whole?                      ___________
                         d.  Which chart type is used to show correlations between two sets of values?       ___________

                       30   Premium Edition-VI

| 27 28 29 30 31 32 33 34 35 36 37 |