One of these was written by a former Visi Calc programmer, Mitch Kapor.His version, Lotus 1-2-3, would go on to be an even greater success than Visi Calc, in no small part due to the fact that it ran on, and was tuned for, the new IBM PC.
Should data be entered down columns, or across rows?
Should intermediate values be stored within the sheet, or on a separate one? After a few months of studying existing real-world examples, it became clear that the data, views of that data, and the formulas that acted on that data were very separate concepts.
Download the Excel fixtures and league table generator.
You type a formula in a cell, then you press ENTER. To fix this error and get back the values (or results) just press CTRL ` again.
One of their initial tasks was to see if they could simplify the task of setting up a spreadsheet.
Completed spreadsheets were easy to use, but many users found it difficult to imagine what the sheet needed to look like in order to get started creating it.Joined by Bob Frankston, the two created the first spreadsheet, Visi Calc, and released it on the Apple II computer in 1979.When Ben Rosen of Morgan Stanley saw the program, he wrote that "Visi Calc might be the software tail that wagged the computer industry dog." Visi Calc was an enormous success, so much so that a huge number of clones appeared.When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”. (Alternatively you can press F2 and then Enter after setting format to General). Using a chalkboard made it easier to fix errors, and allowed the sheet to be shared with a class.