Answer:
Explanation:
Considering the listed options, the criteria used in conditional formatting are Less than, Equal to and Greater than
To make use of conditional formatting, follow the highlighted steps
1. Highlight cells that you want to format
2. Goto Home tab -> Styles -> then select Conditional Format
3. Select Highlight Cells Rules
4. Select the format type (this is where you get to pick either of greater than, equal to less than, etc.)
5. Enter the format value and how it is to be formatted
6. Press OK
Answer:
D. Preferred stockholders are allocated their dividends before dividends are allocated to common shareholders.
Explanation:
Before declaring dividend on common shares, it is always necessary for the company to pay dividends on preferred shares and dividends are declared when there are sufficient profits.
Answer:
$46.51
Explanation:
The weighted arithmetic mean can be defined as:

Where n is the number of shares and P is the share price, then:

Based on this, the weighted arithmetic mean price per share is $46.51
Answer:
Their combined future value will be 8,141.59.
Explanation:
Each deposit is invested at 12%, but for a different amount of years. So, the best thing would be to separate the three, calculate their value at the end of the third year for separated, and then obtain the grand total by adding up the results.
- First deposit = 1,200. It is invested for three years. The value at the end of year 3 is 1,200*(1.12)^3 = 1,685.91
- Second deposit = 2,200. It is invested for two years. The value at the end of year 3 is 2,200*(1.12)^2 = 2,759.68
- Third deposit = 3,300. It is invested for one years. The value at the end of year 3 is 3,300*(1.12) = 3,696.00
- The sum of the three deposits is 8,141.59.
The answer is: Pareto chart
Pareto chart is the combination of line and bar graphs. This type of chart is usually used to present data with frequency of nonoccurence and unite measurement at the same time.(frequency of accidents and number of factors that cause the accidents. )
Other than that, Pareto chart is also commonly used in quality control or searching the highest cause of defects.