Page 33 - Plus V4 with Adobe class 6
P. 33

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 two cells that were previously merged.
                       You can format a number of elements such as text, numbers, colouring, and table styles.
                       AutoFill feature automatically fills a series of data in your worksheet.






                   Choose the correct option.

                   1.  Which of the following formatting elements are included in the Home tab?

                            a.  Text wrap                                  b.  Merging cells

                            c.  Cell style                                 d.  All of the above

                   2.  Which of the following option 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 edit 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


                   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  31
   28   29   30   31   32   33   34   35   36   37   38