

The default alignment for text data is left justified.Īs you saw in the previous activity, text will flow over from one cell to the next as long as the subsequent cells are empty. When you want to enter text in a cell click on the cell in which you want to enter the text and type. Numbers specified as text values cannot be used to perform arithmetic operations. If a single apostrophe is typed in front of a set of digits (e.g., '1234), Calc will treat the numbers as ordinary text. The default alignment for numeric data is right justified, such that numbers in columns are decimal-aligned. If a set of pure digits, that is any combination of 0,1,2,3,4,5,6,7,8, or 9, are typed in a cell, Calc treats the data as numeric arithmetic operations may therefore be carried out on such data. So now that you've experienced 'data entry', let's explore the content or data that can be entered into cells.ĭata entered into cells may be of three types - numeric, text or date. And with any luck, you've been successful. To that end, we've encouraged you to enter data in spreadsheet cells as you learned about other functionality (inserting, deleting.). Sometimes the best learning comes from just doing something and thinking about it later. Selection | Inserting | Deleting | Widths and heights | Entering data | Changing contents | Copy, move, delete | Shifting cells | Sorting data | Speeding data entry | Find and replace | Practice |
