Question: how to create a formula in excel spreadsheet?
Answer: On the worksheet, click the cell in which you want to enter the formula. Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation. For our example, type =1+1. Notes: ...  Press Enter (Windows) or Return (Mac).