What are the main types of chart you can use and what sort of data is each type best at displaying? 2. What are the formats in which you can save a spreadsheet? Why might you want to use these different formats?
3. Why is it important to test a spreadsheet?
4. Explain the difference between relative cell referencing and absolute cell referencing

Suppose that a worker in agland can produce either 10 units of organic grain or 2 units of incense per year, and a worker in zenland can produce either 5 units of organic grain or 15 units of incense per year. there are 20 workers in agland and 10 workers in zenland. currently the two countries do not trade. agland produces and consumes 100 units of grain and 20 units of incense per year. zenland produces and consumes 50 units of grain and no incense per year. if each country made the decision to specialize in producing the good in which it has a comparative advantage, then the combined yearly output of the two countries would increase by a. 30 units of grain and 100 units of incense. b. 30 units of grain and 150 units of incense. c. 50 units of grain and 90 units of incense. d. 50 units of grain and 130 units of ince

Suppose that xtel currently is selling at $40 per share. you buy 500 shares using $15,000 of your own money, borrowing the remainder of the purchase price from your broker. the rate on the margin loan is 8%. a. what is the percentage increase in the net worth of your brokerage account if the price of xtel immediately changes to (a) $44; (b) $40; (c) $36? (leave no cells blank - be certain to enter "0" wherever required. negative values should be indicated by a minus sign. round your answers to 2 decimal places.) b. if the maintenance margin is 25%, how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.) c. how would your answer to requirement 2 would change if you had financed the initial purchase with only $10,000 of your own money? (round your answer to 2 decimal places.) d. what is the rate of return on your margined position (assuming again that you invest $15,000 of your own money) if xtel is selling after one year at (a) $44; (b) $40; (c) $36? (negative values should be indicated by a minus sign. round your answers to 2 decimal places.) e. continue to assume that a year has passed. how low can xtel’s price fall before you get a margin call? (round your answer to 2 decimal places.)

Rossdale co. stock currently sells for $68.91 per share and has a beta of 0.88. the market risk premium is 7.10 percent and the risk-free rate is 2.91 percent annually. the company just paid a dividend of $3.57 per share, which it has pledged to increase at an annual rate of 3.25 percent indefinitely. what is your best estimate of the company's cost of equity?