Microsoft Excel spreadsheets are composed of small blocks called cells. Each cell in a spreadsheet can contain a formula, data or a blank value. Formulas use commands like “SUM” and “COUNTA” to consolidate information or to make calculations and return a value. If your spreadsheet is set up for manual calculations, you must press F9 each time you want to recalculate the formulas. To have the spreadsheet update automatically in real time, you can set it to “Automatic.” Writer Bio
