What is a Spreadsheets?

A spreadsheet is primarily designed to provide a digital form of the paper-based worksheet. Spreadsheets work through spreadsheet application software. The rows and columns within the spreadsheet contain cells that are filled with data to create unique operations. A typical spreadsheet program can have multiple functions.

Instead of reaching for your calculator, use Microsoft Excel to do the math!

On a worksheet, you can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. You can also use the AutoSum feature to quickly total a series of values without having to enter any of them manually in a formula. Once you have created a formula, you can fill it into adjacent cells — no need to create the same formula over and over again.

When you become familiar with these simple formulas, you may want to learn more about how to create complex formulas and try some of the many functions that are available in Excel.

                                                                                                                                                                             

   How to use simple formulas

All formula entries start with an equal sign (=). For simple formulas, simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use  — the plus sign (+) to add, the minus sign (-) to subtract, the asterisk (*) to multiply, and the forward slash (/) to divide. Then, press ENTER, and Excel instantly calculates and displays the result of the formula.

For example, when you type =12.99+16.99 in cell C5 and press ENTER, Excel calculates the result and displays 29.98 in that cell.( image)