In a spreadsheet, you would use the "''" symbol (apostrophe) when you want to indicate that the following entry should be treated as text, regardless of its format. This is particularly useful for preventing automatic formatting, such as when entering numbers that start with zeros (e.g., phone numbers or ZIP codes). It ensures that the data is displayed exactly as you input it without any alterations.
The plus symbol: +
a comma
On a spreadsheet you use the * symbol rather than x as used normally in mathematics.
You would use a - to subtract a number on a spreadsheet
In a spreadsheet, you use the SUM function to automatically add a set of numbers together. The symbol for this function is "SUM," and it is typically written as =SUM(range), where "range" represents the cells you want to add. For example, =SUM(A1:A10) adds all the numbers in cells A1 through A10.
The equal sign(; ( = )
The most common use is in a formula that includes subtraction.
Generally it would still be called a spreadsheet, but it could be called a What-if spreadsheet.
An integrated program
You use a worksheet when you want to have only a single spreadsheet. You will use a workbook when you have multiple worksheets.
In a spreadsheet, you would use the plus sign (+) to add two numbers together. For example, if you wanted to add the values in cells A1 and B1, you would enter the formula =A1 + B1 in another cell. This will calculate the sum of the two numbers and display the result.
One is a spreadsheet program made by Lotus the other is a spreadsheet program made by Microsoft. The main difference is the way in which formulas are entered - in Excel they are preceded by the = symbol and in 1-2-3 they are preceded by the + symbol.