Web hosting asp - 356 CHAPTER 24 IN DEPTH: CALC For
356 CHAPTER 24 IN DEPTH: CALC For more formatting options, right-click the individual cell and select Format Cells from the menu. This displays the Format Cell dialog box, where you can change the style of the typeface, rotate text, place text at various angles, and so on. The Border tab of the Format Cell dialog box includes options for cell gridlines of varying thicknesses, which will appear when the document is eventually printed out. Figure 24-1. You can automate the entering of data sequences by clicking and dragging. Deleting and Inserting Data and Cells Deleting data is also easy. Just highlight the cell or cells with the data you want to delete, and then press the Delete key. If you want to totally eradicate the cell along with its contents, right- click it and select Delete. This will cause the data to the sides of the cell to move in. You ll be given a choice on where you want the cells to shift from to fill the space: left, right, above, or below. To insert a new cell, right-click where you would like to it to appear and select Insert. Again, you ll be prompted about where you want to shift the surrounding cells in order to make space for the new cell. Working with Formulas Calc includes a large number of formulas. In addition to simple and complex math functions, Calc offers a range of logical functions, as well as statistical and database tools. Certain formulas can also be used to manipulate text strings, such as dates. You can get an idea of the available functions by clicking the Function Wizard button on the Formula bar (which is just below the Formatting toolbar). This will bring up a categorized list of formulas, along with brief outlines of what function the formula performs. If you would like more details, use the help system, which contains comprehensive descriptions of most of the formulas, complete with examples of the correct syntax.