How-To Geek on MSN

You need to know the difference between a range and an array in Excel

Excel processes the range (A1:A10) by converting it into an array in memory. This array is what Excel works with to calculate the sum. The distinction is subtle but important: while the range is the ...
TechRepublic

Anatomy of an Excel formula: Using functions to perform calculations

Anatomy of an Excel formula: Using functions to perform calculations Your email has been sent If you’re fairly new to Microsoft Excel, you’ve probably learned to enter data into cells to provide ...