Answer:
Calculating the bill total for the week:
The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts. In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50). One you press the "enter" the result is automatically displayed. This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.
Explanation:
In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.
Answer:
There is a violation of Uniform State Law because the agent has made an offer to sell an unregistered non-exempt security in that State
Explanation:
The Uniform State Securities Law is also called blue sky law, and they are put in place at the State level to prevent fraud and to enforce security regulation.
This law was set up to handle investments that do not occur at the federal level. These are out of the purview of the SEC so states handle them.
In the given scenario the agent is trying to make a non exempt security exempt by buying it from the client.
This is an attempt to sell the securities to investors through fraudulent means and it is a violation of Uniform State Law
B. Avoid gossip
Getting along with team means being yourself and not gossiping with others.
C is not the answer because you want to make sure you are aware of complaints.
D is not the answer because when you give gifts, sometimes people can take advantage of you because they know you want to get along with them
A is not the answer because to get along and work together you have to share ideas