CCNC/CCNC Module 4/Working with and in cells

{| id="mp-upper" style="margin:5px 0px 0px 0px; background:none;"
 * class="MainPageBG" style="width:5%; border:10px solid #FBEBF5; -moz-border-radius: 8px;background:#f5fffa; vertical-align:top; color:#000;" |

Section Overview
Now that we have familiarised ourselves with all the elements that comprise the spreadsheet, we are ready to lay the ground work for actually using the tool. As you must have realised by this time, everything that we do in the spreadsheet takes place inside of the cell. The cell is the smallest unit of the spreadsheet and it is when we put cells together that we get rows and columns. So even when we are talking about rows and columns, essentially, we are talking about a series of cells organised in a particular way in a single worksheet or the several worksheets that comprise the spreadsheet. Having said that, we need to emphasize that it is more than just the cell itself that we are interested in when we work with spreadsheets; there is no point in simply having a whole spreadsheet of empty cells. In this section, we will be focusing on cells with content, otherwise known as data. Specifically, we will be paying attention to the various operations we can perform with cells depending on what we want to do with the content they contain

The following sub-sections are covered in this tutorial:
 * Selection in a worksheet
 * Inserting within a worksheet
 * Deleting rows and columns in a worksheet
 * Modifying column widths and row heights
 * Entering data in cells
 * Making changes to the contents of cells
 * Shifting cells
 * Using the Search and Replace Command
 * Sorting data