Excel's logical functions test whether a statement or data is true or false, before enabling the program to carry out an action based on the result. They are useful for analyzing data, automating ...

Please note: This item is from our archives and was published in 2002. It is provided for historical reference. The content may be out of date and links may no longer function. Q. One of the really ...

Learn how to apply AutoFill to Data Series in Microsoft Excel. AutoFill fills cells with data that follows a sequence or is based on data in other cells.

You can automatically fill increment cells in Excel using the Autofill function as follows: Pick a column and enter the numerical values in the first 2 cells.

For example, using the data range shown below, you might enter a SUM() function that sums B3:E3 in cell F3. Then, you’d use the fill handle to copy that formula to F4:F6.

You might think that your work is done, but actually, Excel is sitting and waiting for you to do more with those tables, ...

You can save time by creating an AutoFill series in Excel 2003 as follows: Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab.

When typing text into a cell, Excel will show autocomplete text once a sufficient number of characters are typed. That number of characters depends on how many words of similar beginning spelling ...