![]() ![]() Formulas and Functions-It’s important that Excel knows you’re entering a formula or it will treat what you enter like text.Dates and Times-Although dates and times may be considered alphanumeric, there are occasions where you might want to perform calculations on the values, so it is important to identify the data correctly to Excel.Examples of numeric text are phone numbers or Social Security numbers. Text-Alphabetic or numeric data that is not used for calculation purposes.Numbers-Numeric data that can be used for calculation purposes.Data in Excel can fall into one of four categories. You tell Excel what kind of data is in a cell by how you type it into the cell or by how you format the cell. It’s important to differentiate types of data because Excel treats each differently. Quickly copy data using the fill handle.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |