Wilcox | search
Click here to view Wilcox news from 60+ newspapers.
Bookmark or Share- XML for the uninitiated - Microsoft SupportMarkup is the process of using codes called tags (or sometimes tokens) to define the structure, the visual appearance, and — in the case of XML — the meaning of any data. The HTML code for this article is a good example of computer markup at work.
- T.TEST function - Microsoft SupportReturns the probability associated with a Student's t-Test. Use T.TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean. T.TEST (array1,array2,tails,type) The T.TEST function syntax has the following arguments: Array1 Required. The first data set. Array2 Required.
- Guidelines and examples of array formulas - Microsoft SupportDownload an example workbook with all the array formula examples in this article. Parts of this article were based on a series of Excel Power User columns written by Colin Wilcox, and adapted from chapters 14 and 15 of Excel 2002 Formulas, a book written by John Walkenbach, a former Excel MVP. Need more help?
- Use AND and OR to test a combination of conditionsWhen you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's an example:
- Insert or delete rows and columns - Microsoft SupportInsert and delete rows and columns to organize your worksheet better. Note: Microsoft Excel has the following column and row limits: 16,384 columns wide by 1,048,576 rows tall. Select any cell within the column, then go to Home > Insert > Insert Sheet Columns or Delete Sheet Columns.
More
