contestada

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.

Respuesta :

MrRoyal

Formulas in Microsoft Office Excel are illustrated using functions. Some of these functions are predefined, while others are user defined

(a) The sum of the first five numbers

Assume the column is column A; so, the first 5 numbers in the column would be in cells A1 to A5

The syntax of an IF function in Microsoft Office Excel is:

= IF([condition],[value if true],[value if false]).

So, the required formula is:

=IF((A1+A2+A3+A4+A5)<0,"Negative","Not Negative")

(b) Business related task

An example of a common business-related task that benefits from the use of cross-sheet referencing is ACCOUNTING AND BUDGETING

(c) Negative values

The required formula is:

=IF(B5<0,"Negative","Not Negative")

Read more about Excel formulas at:

https://brainly.com/question/14174528

Otras preguntas