Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 41 - 2611_SmartGPT Pro V(5.0) C-5
P. 41

    REVISIT

                       ▶  A spreadsheet is a computer application program for organising, calculating, and sorting data in a
                         tabular form.

                       ▶  Excel 2021 is used for computing numbers, organising, sorting, analysing and sharing data.
                       ▶  Workbook is a collection of worksheets.
                       ▶  We need to select the cell or a range of cells to perform any function on it.

                       ▶  We can edit the text either by replacing or modifying it.
                       ▶  We use the Undo option to reverse any action performed by us.
                       ▶  We can use the Redo command to reverse actions which we may have undone.

                       ▶   We can use the Copy and Paste option to copy data in the worksheet and paste it at the same or
                         another worksheet.
                       ▶   We can use the Cut and Paste option to move data from the worksheet and paste it at another
                         location in same or another worksheet.

                       ▶  We can insert and delete cells, rows or columns.
                       ▶  The feature of entering sequential data in the cells of a worksheet is called Autofill.
                       ▶   We can increase or decrease the Row Height and Column Width of a selected cell or a range of
                         cells with a specific measurement.

                     1.  Tick ( ) the correct option.

                        a.  What is the basic unit of a worksheet in Excel?

                             (i)  Workbook                                      (ii)  Cell
                            (iii)  Row                                          (iv)  Column

                        b.  Which bar shows the content of the active cell?

                             (i)  Status Bar                                    (ii)  Ribbon
                            (iii)  Formula Bar                                  (iv)  Name Box

                        c.  Identify the default alignment of text and numbers in Excel.
                             (i)  left-align, right-align                       (ii)  right-align, left-align

                            (iii)  right-align, center-align                    (iv)  center-align, right-align

                        d.  To select multiple cells that are not next to each other, you should _______________.
                              (i)  Hold Shift and click the cells                (ii)  Hold Ctrl and click the cells

                            (iii)  Double-click each cell                       (iv)  Click each cell individually

                                                                                                           Excel 2021  39

| 36 37 38 39 40 41 42 43 44 45 46 |