Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - 2620_Birla Open Mind C-6
P. 35

    Timeline

                                Excel provides a lot of facilities to modify and process data.

                                You can specify a column width of 0 to 255 characters and a row height of 0 to 409 points.

                                The default column width is 8.43 characters and the default row height is 15 points.

                                Combining two or more cells is known as merging.

                                Splitting cells means to separate the cells that were previously merged.
                                You can format a number of elements such as text, numbers, colouring, applying themes, styles,
                              borders and colors, and table styles.
                                AutoFill feature automatically fills a series of data in your worksheet.

                     A.     Choose the correct option.

                            1.  Which of the following formatting elements is/are included in the Home tab?
                                     a.  Wrap Text                                  b.  Merge Cells

                                     c.  Cell styles                                d.  All of these

                            2.  Which of the following options can we rename by right-clicking on the sheet tab?
                                     a.  Workbook                                   b.  Cell

                                     c.  Worksheet                                  d.  Column

                            3.  You can specify a column width of 0 to              characters.
                                     a.  255                                        b.  256

                                     c.  409                                        d.  None of these
                            4.  Which action of mouse can be used to modify the content of a cell?

                                     a.  Right-click                                b.  Double-click

                                     c.  Click                                      d.  We can not edit cell content
                            5.  Which of the following commands is used for wrapping text in a cell?

                                     a.  Wrap Text                                  b.  Text Wrap

                                     c.  Cell style                                 d.  Wrapping

                     B.     Tick ( ) the correct statements and cross ( ) the wrong ones.

                            1.  We cannot select more than one cell at a time in an Excel worksheet.

                            2.  We can format cells that have numbers.

                            3.  We cannot merge two or more cells.

                            4.  AutoFill allows user to automatically fill a number or text series.

                                                                                                    #More on Excel 2019  33

| 30 31 32 33 34 35 36 37 38 39 40 |