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.