A spreadsheet can be viewed as an electronic equivalent of an accounting worksheet made up of rows and columns. By default, they are right aligned in a cell. Text is any set of characters that Excel does not interpret as a value and therefore cannot do calculations on, such as Total Sales, 555-1212, etc. Formulas create relationships between numeric values in other specified cells.
Formulas result in values or numbers based on the values of the cells referenced in the formula.
The formula paste function menu option is a good way to enter these properly. Problem-Solving Steps using Spreadsheets Because a spreadsheet is such a powerful tool with the capability to hold millions of numbers and formulas in different cells, taking time up front to design your spreadsheet and then test its accuracy after completion are critical. The basic steps below serve as guidelines for creating spreadsheets. Then enter numeric values. Next enter the formulas.