Salena Has Created a Chart to Show the Sale of Products

question 35

True/False

Salena has created a chart to show the sale of products of her firm in different cities during different years.The chart has only one series with all the columns of the same color.The Year and Location fields are both in the Rows area.Now,she wants to create columns with different colors,for which she will have to move one of the fields into the Column area in the PivotTable Field List.To do so,Salena can follow the following series of clicks/ entries/ selections to do so: Pivot Chart > Pivot Chart Field window > Drag the Year field from the Axis box (Categories)to the Legend (Series)box.This will create a series for each city,and show the city's columns in a different color.

---

Definitions:

Investment Alternatives

Various options available to investors for putting their money, including stocks, bonds, real estate, or commodities.

Fixed Returns

Refers to the predetermined earnings from an investment, typically associated with bonds or other fixed-income investments, which provide regular interest payments.

Variable Returns

Variable returns refer to earnings from an investment that are not fixed and can vary greatly over time, often seen in stocks, bonds, and mutual funds due to market conditions.

Insurance Companies

Businesses that provide coverage, in the form of compensation resulting from loss, damages, injury, treatment or hardship in exchange for premium payments.