Page 49 - 2619_PlusGPT V2.1_C-8
P. 49

c.  Chart area includes all objects and elements in a chart.                       ____________

                    d.  You cannot sort more than one columns at a time in a selected range of cells.    ____________
                    e.  We cannot create Bar chart in Excel.                                           ____________

                 4.  Short answer type questions.

                    a.  What are gridlines?
                         _________________________________________________________________________________

                    b.  Define legend.

                         _________________________________________________________________________________
                    c.  What is Bar chart?

                         _________________________________________________________________________________

                    d.  What is Area chart?
                         _________________________________________________________________________________

                    e.  How do you remove filters?

                         _________________________________________________________________________________
                         _________________________________________________________________________________


                 5.  Long answer type questions.
                    a.  What are the differences between line chart and XY scatter chart?

                         _________________________________________________________________________________
                         _________________________________________________________________________________

                         _________________________________________________________________________________

                    b.  Explain any 5 components of a chart.
                         _________________________________________________________________________________

                         _________________________________________________________________________________
                         _________________________________________________________________________________

                    c.  Write the steps to change the chart type.

                         _________________________________________________________________________________
                         _________________________________________________________________________________

                         _________________________________________________________________________________

                    d.  What is the difference between sorting data and filtering data?
                         _________________________________________________________________________________

                         _________________________________________________________________________________
                         _________________________________________________________________________________




                                                                  Google Sheets (Advanced- Sorting, Filtering & Charts)  47
   44   45   46   47   48   49   50   51   52   53   54