Excel has most of the math and trig functions built into it. If you need to use the SIN, COS, TAN functions, they can be typed into any cell.

This tutorial will show you the step-by-step procedur e for how to use AutoFill to fill in common sequences, number patterns, and formulas.

MS Excel tutorial for Formulas and Functions. Mathematical Operations and Basic Functions.

The CountA function in Excel will return the number of entries (actually counts each cell that contains number data OR text data) in the selected range of cells.

The MIN function in Excel will return the smallest (Min) value in the selected range of cells.

The MAX function in Excel will return the largest (max) value in the selected range of cells.

Probably the most popular function in any spreadsheet is the SUM function. The Sum function takes all of the values in each of the specified cells and totals their values.

This tutorials will teach you to use the excel random number generator to get random sample data from a spreadsheet. There are several approaches to this. Here is one way to accomplish this. Let's say that your 50 numbers are in cells A2:A51. Highlight cells B2:B51. Enter the formula =RAND() and hit Ctrl+Enter. This will enter the formula in all 50 cells at once. Copy B2:B51 with Ctrl+c. PasteSpecial the formulas into values by using Edit - PasteSpecial - Values - OK. You have now assigned a random number to each row. You could sort by column B and take the top 5, the bottom 5, whichever you prefer. If for some reason you can not sort the data, you could use column C and enter a Rank function.

he PMT function returns the periodic (in this case monthly) payment for an annuity (in this case a loan). This is the PMT function that was used for the car purchase in the first example. There are a few things that we must know in order for this function to work.

The average function finds the average of the specified data.