Scm 315 midterm - Study guides, Class notes & Summaries

SUM: - Answer-Used when you want to calculate the sum of multiple cells without having to enter the formula manually $ in front of the column reference (the letter) - Answer-Will keep the reference to the column absolute, no matter how you drag it MIN(number1, number2, ...) - Answer-Returns the smallest number in a set of values MAX(number1, number2, ...) - Answer-Returns the largest number in a set of values Ignores logical values and text SUMPRODUCT(array1, array2, array3,...) - A...