Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 45 - logicode 2609 C6
P. 45

    1.  Tick ( ) the correct option.
                        a.   Choose among the following, which chart type is used to display data in the form of long rectangular
                          rods?

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

                        b.  Find out the component of a chart that describes the main purpose and content.

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

                        c.  Name the tab you select for changing the type of an existing chart in Excel.
                            (i)  Insert                                       (ii)  Design

                           (iii)  Format                                      (iv)  Chart Design
                        d.  What is the first step in creating a chart in Excel?

                            (i)  Click on the Insert tab                      (ii)   Select the data range

                           (iii)  Choose the desired chart                    (iv)   Click on the Chart Design tab
                        e.  Tell the name of the chart, which is shaped like a circle divided into slices.

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

                        f.  What function in Excel is used to calculate the total of a given set of values?
                            (i)  AVERAGE()                                    (ii)  SUM()

                           (iii)  IF()                                        (iv)   MAX()

                        g.  Which of the following is used to check a condition and take action based on the results in Excel?
                            (i)  SUM()                                        (ii)  AVERAGE()

                           (iii)  IF()                                        (iv)  COUNT()
                        h.  What feature in Excel allows you to arrange data in increasing or decreasing order?

                            (i)  Filtering                                    (ii)   Sorting
                           (iii)  Conditional Formatting                      (iv)   Data Validation

                        i.   To filter data in Excel, which command do you use?

                            (i)  Sort & Filter                                (ii)   Data Validation
                           (iii)  Pivot Table                                 (iv)   Conditional Formatting

                                                                                        Advanced Features of Excel 2021   43

| 40 41 42 43 44 45 46 47 48 49 50 |