管帐继承教导EXCEL试题四(国外英文资料).docVIP

会计继续教育EXCEL试题四(国外英文资料) The application of EXCEL in financial work (the fourth set of questions) Part 1: single item choice (2.00, total 15, total 30) Question 1: in the following categories, not cash flow generated by investment activities is (D). A. recoup the cash received from the investment B. obtain the cash received from the investment proceeds The net cash received by the subsidiary and other business units D. absorb the cash received by the investment A. b. b. c. c. d. Problem 2: in the following items, the incorrect name is (C). A. The correlation ratio is the ratio of financial statements in the same period and the relevant figures in the accounting data The ratio of the structure to the total value of a project in a financial statement The dynamic ratio is the ratio of financial statements to the two values of a project in the accounting data D. the analysis of the first phase of each issue is compared to the previous one A. b. b. c. c. d. Problem 3: the following statement about the value of money in Excel is incorrect (B). A: the final value of A compound interest is the sum of the profits at A certain point in the future at A certain interest rate, and the final value of the compound is calculated using the FV function B. the present value of compound interest is the value of a period of money in the future. The present value of compound interest can be calculated using the PV function C. To calculate the final value of an ordinary annuity, use the PV function provided in Excel D. The present value of ordinary annuities is calculated using the PV function provided in Excel A. b. b. c. c. d. Problem 4: the end of the Excel file is (B). A. the doc B.. XLS C.. PPT D..pdf A. b. b. c. c. d. Question 5: someone to bank loans of 100000 yuan to buy a house, in the next five years, at the end of each year to return to the bank is 23400 yuan, asked what the annual interest rate is a bank loan? The annual interest rate in this problem is solved by (A). A. what f