Page 62 - Viva ICSE Computer Studies 7 : E-book
P. 62

Active Cell

                    Active cell indicates that the current cell is active. When you click on a cell, a thick border
                    appears around it which diff erentiates it from the rest of the cells.

                    Range

                    A range is a group of continuous cells which forms                 Learn More
                    the shape of a rectangle. The range can be as small
                                                                                  Rows are numbered from top to bottom
                    as a single cell or as big as an entire worksheet. It is
                                                                                  as 1, 2, 3, ... Columns are labelled from
                    specifi ed with the starting cell address followed by         left to right as A, B, C, D, ....
                    the ending cell address, separated by a colon (:). For
                    example B5 : F5 indicates a range starting from B5 and ending at F5.

                    Name Box

                    Name box is located on the left side of the window. It displays the location of the cell points.

                    Formula Bar

                    Formula bar is located to the right side of the Name box. It shows the entered characters and
                    formulae.

                    Column Headings

                    Column headings are the letters marked along the top border of the worksheet. Each letter
                    represents a column.
                    Row Headings


                    Row headings are the numbers marked along the left border of the worksheet. Each number
                    represents a row.
                    File Tab

                    File  tab contains many functions. It allows us to create new workbook, open an existing
                    workbook, save a workbook, print a workbook and various other tasks.

                    Ribbon

                    The panel at the top of an Excel document is called the Ribbon. It has 7 tabs on it. They are
                    Home, Insert, Page Layout, Formulas, Data, Review and View.

                    Each tab is divided into groups. The groups are logical collections of features designed to
                    perform specifi c functions to develop or edit spreadsheets. The most used features of groups
                    are displayed on the Ribbon. To view additional features within each group, click on the arrow
                        at the bottom right corner of the group.

                    Status Bar

                    Status bar is located at the bottom of the window. It displays information about the current
                    selection.



                     50
   57   58   59   60   61   62   63   64   65   66   67