Whether youre adding up your. The following image shows how to create the y-values for this equation in Excel using the range of 1 to 10 for the x-values. To see how altering one of the formula values alters the result change the data in cell C1 from 3 to 6 and press Enter on your keyboard.
Whether youre new to Microsofts popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010 youre sure to be well served by this video tutorial.
We can also create nested IF statements. Similarly for more such tips tricks you can follow our Excel Ninja Training and become an expert in Excel. We can use Excel to help us do this and the screen shot below shows how that is done. Dragging the AutoFill handle is the most common way to apply the same formula to an entire column or row in Excel.