The CHOOSE function in Microsoft Excel is a Lookup and Reference function, and its purpose is to choose a value from a list of values. Learn how to use it.

S low lookup formulas can kill productivity when working with large datasets. To cope with that, I've tested Excel's optimal ...

Microsoft Excel 2010 has 400 functions in 11 categories. Categories for both spreadsheet programs include Date and Time, Text, Statistical, Financial and Engineering.

In the Function Arguments dialog box, enter the bottom (lowest) number of your range and a top (highest) number of your range, then click OK. Copy the formula from B3 down through B14, then press ...