Page 37 - Ms Excel Note and Workbook
P. 37

MICROSOFT EXCEL NOTE AND WORKBOOK


               4  WORKING WITH CELLS AND SHEETS




               Understanding cells



               Every  worksheet  is  made  up  of  thousands  of  rectangles,  which  are  called cells.  A  cell  is
               the intersection of a row and a column—in other words, where a row and column meet.


               Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell

               has its own name—or cell address—based on its column and row. In the example below, the selected
               cell intersects column C and row 5, so the cell address is C5.





                                                                                      TIP
                                                                              Note that the cell address
                                                                              also appears in the Name
                                                                              box in the top-left corner,
                                                                              and that a cell's column
                                                                              and row headings are
                                                                              highlighted when the cell is
                                                                              selected.






               You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather
               than  a  single  cell  address,  you  will  refer  to  a  cell  range  using  the  cell  addresses  of

               the first and last cells in the cell range, separated by a colon. For example, a cell range that included
               cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges
               below:


               •    Cell range A1:A8
























                                                                                               28 | P a g e
   32   33   34   35   36   37   38   39   40   41   42