Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

TINV(probability,degrees_freedom) [Category: Statistical]]

Returns the t-value of the Student’s t-distribution as a function of the probability

and the degrees of freedom.

TODAY( ) [Category: Date & Time]

Returns the serial number of the current date. The serial number is the date-

time code used by Microsoft Excel for date and time calculations. Guru Tip: This

is often better than the more popular =NOW() function, particularly if you are

calculating the number of days between today and another date. With =NOW(),

your date difference calculation will reﬂ ect decimal portions of a day as the

workday elapses. With =TODAY(), the number of days will remain constant until

midnight.

TRANSPOSE(array) [Category: Lookup & Reference]

Returns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE

must be entered as an array formula in a range that has the same number of rows

and columns, respectively, as array has columns and rows. Use TRANSPOSE

to shift the vertical and horizontal orientation of an array on a worksheet. For

example, some functions, such as LINEST, return horizontal arrays. LINEST

returns a horizontal array of the slope and Y-intercept for a line. Guru Tip: In the

image below, select blank cells A3:A7. Type =TRANSPOSE(A1:E1) and press

Ctrl+Shift+Enter. To turn the vertical array back to horizontal, select ﬁ ve blank

cells A12:E12. Type =TRANSPOSE(A3:A7) and press Ctrl+Shift+Enter. Note

that you do not type the curly braces shown in the formula. Excel adds those

when you press Ctrl+Shift+Enter to signify that this is an array formula.

TREND(known_y’s,known_x’s,new_x’s,const) [Category: Statistical]]

Returns values along a linear trend. Fits a straight line (using the method of

least squares) to the arrays known_y’s and known_x’s. Returns the y-values

along that line for the array of new_x’s that you specify. Guru Tip: I usually use

LINEST and then enter a range of formulas multiplying the slope and adding the

constant. Instead, you could use TREND.

TRIM(text) [Category: Text]

Removes all spaces from text except for single spaces between words. Use

TRIM on text that you have received from another application that may have