1. Write a formula that would return a TRUE result if the sum of the first five numbers in a column of data are negative (for example, if you wanted to quickly know if the column had more expenditures than income). 2. Provide an example of a common business-related task or problem (payroll, inventory management, budgeting, profit-loss statements, etc.) that benefits from the use of cross-sheet referencing.

3. Provide an example of formula (with proper syntax) that would check whether cell B5 has a negative number and return a value of “negative” if it was and “not negative” the value was zero or higher.

What is one of the main problems that can occur when implementing a large number of new systems within an organization?

)a grad student comes up with the following algorithm to sort an array a[1..n] that works by first sorting the first 2/3rds of the array, then sorting the last 2/3rds of the (resulting) array, and finally sorting the first 2/3rds of the new array. 1: function g-sort(a, n) . takes as input an array of n numbers, a[1..n] 2: g-sort-recurse(a, 1, n) 3: end function 4: function g-sort-recurse(a, `, u) 5: if u ⒠` ≤ 0 then 6: return . 1 or fewer elements already sorted 7: else if u ⒠` = 1 then . 2 elements 8: if a[u] < a[`] then . swap values 9: temp ↠a[u] 10: a[u] ↠a[`] 11: a[`] ↠temp 12: end if 13: else . 3 or more elements 14: size ↠u ⒠` + 1 15: twothirds ↠d(2 ◠size)/3e 16: g-sort-recurse(a, `, ` + twothirds ⒠1) 17: g-sort-recurse(a, u ⒠twothirds + 1, u) 18: g-sort-recurse(a, `, ` + twothirds ⒠1) 19: end if 20: end function first (5 pts), prove that the algorithm correctly sorts the numbers in the array (in increasing order). after showing that it correctly sorts 1 and 2 element intervals, you may make the (incorrect) assumption that the number of elements being passed to g-sort-recurse is always a multiple of 3 to simplify the notation (and drop the floors/ceilings).

What are the most likely causes of conflict at the meeting? check all that apply.