Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 46 - logicode 2609 C6
P. 46

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

                                      Shift, Line, X, Gridlines, Legend, Sort A to Z, IF, Custom Sort, Filter

                         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.
                         f.  The _____________ command is used to display only the rows of data that meet certain criteria.

                         g.   The _____________ function in Excel checks a condition and returns different values based on wheth-
                            er the condition is true or false.
                         h.   To add another column to sort data within a sorted column, you can use the _____________ option
                            in Excel.

                         i.  To sort data in ascending order, you would select the option _____________ in the Sort & Filter menu.

                      3.  Write T for true and F for false.
                         a.  The SUM() function is used to calculate the average of a given set of values.

                         b.  Excel allows us to see the important data and hide the rest data temporarily.

                         c.  Sorting data in Excel cannot be done in descending order.

                         d.  Custom sorting allows you to sort data based on multiple columns.
                      4.  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?      ____________
                         e.   What is the term for the rectangular area that contains the actual chart and
                            includes the plotted data?                                                      ____________

                         f.  What command do you use to change the background of a chart in Excel?          ____________

                         g.  What is the physical arrangement of data in ascending or descending
                            order is called?                                                                ____________

                         h.  Which feature helps you view only specific data in Excel?                      ____________
                         i.  What type of formatting in Excel changes cell appearance based on conditions?   ____________

                         j.  Which tab in Excel contains the Insert Function command?                       ____________

                       44   Premium Edition-VI

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