subject

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.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 12:30
An atom's diameter is about 0.1 nanometer (1×10-9m), and a human hair is about 1×10-3m. how many times greater is a human hair than an atom's diameter? sorry pushed wronf button but this is math
Answers: 3
question
Computers and Technology, 22.06.2019 18:10
Assume that to_the_power_of is a function that expects two int parameters and returns the value of the first parameter raised to the power of the second parameter. write a statement that calls to_the_power_of to compute the value of cube_side raised to the power of 3 and that associates this value with cube_volume.
Answers: 1
question
Computers and Technology, 23.06.2019 01:40
You have a linux system that has a 1000gb hard disk drive, which has a 90gb partition containing an ext4 filesystem mounted to the / directory and a 4gb swap partition. currently, this linux system is only used by a few users for storing small files; however, the department manager wants to upgrade this system and use it to run a database application that will be used by 100 users. the database application and the associated data will take up over 200gb of hard disk space. in addition, these 100 users will store their personal files on the hard disk of the system. each user must have a maximum of 5gb of storage space. the department manager has made it very clear that this system must not exhibit any downtime as a result of hard disk errors. how much hard disk space will you require, and what partitions would you need to ensure that the system will perform as needed? where would these partitions be mounted? what quotas would you implement? what commands would you need to run and what entries to /etc/fstab would you need to create? justify your answers.
Answers: 3
question
Computers and Technology, 23.06.2019 13:50
Explain how email technologies enable the exchange of messages between users. find out the typical parts of an email address and explain each part.
Answers: 1
You know the right answer?
1. Write a formula that would return a TRUE result if the sum of the first five numbers in a column...
Questions
question
Chemistry, 06.11.2020 23:20
question
History, 06.11.2020 23:20
question
Chemistry, 06.11.2020 23:20
question
Spanish, 06.11.2020 23:20
question
Spanish, 06.11.2020 23:20
Questions on the website: 13722359