![quick analysis tool in excel spread sheet quick analysis tool in excel spread sheet](https://cdn.ablebits.com/_img-blog/excel-sparklines/insert-sparkline-excel2013.png)
You can store a huge amount of data in a table. When you've entered numbers in your sheet, you can add them up to use a fast way that is AutoSum.ĪutoSum adds up the numbers and shows the result in the cell you selected. Here is a sample worksheet with some fraction number. To write fraction number select "fraction". Select the cells that have numbers you want to format.To distinguish between different types of numbers, add a format, like currency, percentages, or dates. Note : To stay on the active cell Press Ctrl+Enter. To execute the above formula Press Enter.
#QUICK ANALYSIS TOOL IN EXCEL SPREAD SHEET PLUS#
Type a combination of numbers and calculation operators, like the plus sign (+) for addition, the minus sign (-) for subtraction, the asterisk (*) for multiplication, or the forward slash (/) for the division.That tells Excel that this cell will contain a formula. Move the mouse in a cell and type an equal sign (=).
![quick analysis tool in excel spread sheet quick analysis tool in excel spread sheet](https://www.lifewire.com/thmb/A470JoDIMDF-p8Xc4OTFbY50hjA=/1920x1200/filters:no_upscale():max_bytes(150000):strip_icc()/spreadsheet-apps-android-1-5bf088aa46e0fb00512fd9e4.jpg)
Here are some simple formulas to add, subtract, multiply or divide your numbers.
![quick analysis tool in excel spread sheet quick analysis tool in excel spread sheet](https://www.dummies.com/wp-content/uploads/495059.image1.jpg)
In the following workbook address of 1 is cell B2, 2 is cell B3, and 3 is cell B4.Īdding numbers is just one of the things you can do, but Excel can do other arithmetical formulas too. Note : Cells are referenced by their location in the row and column on the sheet.