not yet saved. If you have saved your changes, it will disappear. Sheets count Page Style Unsaved Changes cell information Selection Mode Zoom Figure . Calc Status bar .
Working with Data When you open a new worksheet, the cell pointer is located in cell A1. So, the cell A1 is known as “Home Cell”. Cell pointer can be moved anywhere in the worksheet using the direction keys. “Tab key” is used to move the cell pointer towards the right side or in the forward direction.
“Shift+Tab” is used to move backward i.e. from right to left in a row. “Enter” key is also used to move the cell pointer. Enter moves the cell pointer to a cell below the current cell i.e.
downwards. Four “ direction keys ” are used to move the cell pointer anywhere in the worksheet. . .
Entering Data: Any data can be typed direc tly in any cell of the worksheet. But, the cell in which you type data should be an active cell. So, move the cell pointer to a particular cell to make it active cell; or click any cell to make it active cell. Then, start typing any data.
When you type data, spreadsheet recognises the type of data entered in cells. Data types: Data are of different types. Data are made up of alphabets, numbers, Date and time is also another data type even though it has numbers and symbols. In general, data types are classified as: Alphabetic data type – consists of alphabets only, Numeric data type – consists only of numbers (whole number or fractional numbers), Alphanumeric data types – consists of a combination of alphabets and numerals, Date data type – consists only of date, Time data type – consists only time.
. . . Entering Numbers: Any numeric data can be entered in a worksheet.
Entered numbers are aligned to the right side within the cell by default. Negative numbers may be entered with a minus sign or within brackets (Refer Figure . ). If you enter any number within the bracket, it will be changed as negative number