2012年徐州会计继续教育财务工作中的EXCEL 课后练习(国外英文).docVIP

2012年徐州会计继续教育财务工作中的EXCEL 课后练习(国外英文资料) EXCEL exercises in financial work Judgment question: 1, in EXCEL, you can set the formula in the display cell. [title number: Qhx002194] A, yes B, wrong Your answer: A The correct answer: A 2, on the top of the workbook A, B, C... Etc. letters work table column. [title number: Qhx002182] A, yes B, wrong Your answer: A The correct answer: A 3, the SUMIF function is the number of cells that satisfy the given condition in the calculated region. [title number: Qhx002195] A, yes B, wrong Your answer: A The correct answer: B 4, if you repeatedly repeat a task in Microsoft Excel, you can automate the task with macros. [title number: Qhx002192] A, yes B, wrong Your answer: A The correct answer: A 5. On the left, 1, 2, 3, etc. of the workbook, the numbers represent the column number of the worksheet. [title number: Qhx002181] A, yes B, wrong Your answer: A The correct answer: B Radio examination: 1, the syntax of the DB function is: DB (cost, salvage, life, period, month), and its first argument is: [title number: Qhx002178] A, the original value of assets B, asset value C, depreciation period D or more is wrong Your answer: A The correct answer: A 2, after you create a new workbook, the default first worksheet name is: [title number: Qhx002166] A, Sheetl B, Bookl C, Excel1 D, table 1 Your answer: A The correct answer: A 3, a EXCEL workbook has default () worksheets. [title number: Qhx002162] A, 1 B, 2 C, 3 D, 4 Your answer: A The correct answer: C Topic: the default worksheet for Excel is 3. Users can add worksheets as needed, and the number of worksheets is no longer limited by 256 numbers, and is limited by the amount of memory available to the computer. 4, the syntax of the SLN function is: SLN (cost, salvage, life), and its first argument is: [title number: Qhx002179] A, the original value of assets B, asset value C, depreciation period D or more is wrong Your answer: A The correct answer: A 5, to calculate the number of cells in a