Information stored in the cells of a spreadsheet can also be displayed in a variety of graphs. Excel will open up with a blank spreadsheet or workbook. This empty workbook will have several blank sheets already available for use. C. Entering Data and Formulas 1. To enter some text in a cell, move to that cell and type in the text.
Text is automatically left-justified.
That is, you only have to type in a formula once to do a particular task on a series of cells, e.g. find their average. The cell with the equation can be copied and pasted into a whole column and the appropriate cells will be used relative to the cell into which the formula was copied so that each cell is the average of its own row. Now move to the first location of the remainder of the column or row into which you want to paste this data or formula. Hold down the mouse button while moving down the column or through the row so as to select the recipient cells. The procedure for saving a workbook is identical to saving a file in any of the Microsoft application programs.