2011年继续教育财务工作中的EXCEL考题和答案 徐州版本（国外英文资料）.doc

2011年继续教育财务工作中的EXCEL考题和答案 徐州版本（国外英文资料） EXCEL in financial work True or false: 1, the input array should be input in the selected area and press Shift + Ctrl + Alt. [qid: Qhx002184] A, the B, wrong In EXCEL, the system defaults to a workbook containing three worksheets. [qid: Qhx002180] A, the B, wrong By using EXCEL to protect the worksheet, some cells can be entered or modified, while others cant. [qid: Qhx002188] A, the B, wrong If you are constantly repeating a task in Microsoft Excel, you can perform the task automatically using macros. [qid: Qhx002192] A, the B, wrong In EXCEL, you can set the border of the cell, but not the bottom line of the cell. [qid: Qhx002185] A, the B, wrong Single topic selection: If B1: B3 cells are 1, 2, 3, the value of the formula SUM (B1: B3, 5) is: [issue number: Qhx002163] A, 11 B, 5, C, 6, D, 8 2, the name of the first worksheet by default after a new workbook is entitled: [issue number: Qhx002166] A, Sheetl B, Bookl C, Excel1 D, table 1 The first parameter of the DB function is: DB (cost, salvage, life, period, month), the first parameter is: [issue number: Qhx002178] A, the original value of the assets B, assets, the salvage value C, depreciation fixed number of year D, thats not true When using the straight-line method of depreciation, the () function in EXCEL is used for calculation. [qid: Qhx002173] A, the DB B, DDB C, SLN Neither of these functions apply Location is the function of the menu bar (). [qid: Qhx002175] A, the data B, format C, tools, D, edit, Multiple choice: In EXCEL, you can use the undo button in the commonly used toolbar to restore operations: [issue number: Qhx002155] to see the answer A, insert the cell B, delete cells C, insert the worksheet D, delete the worksheet 2, if is calculated in C1 cell A1 and B1 cells and copies cell C1 to D1, still want to D1 A1 and B1 cells and calculation, then C1 cell should input: [qid: Qhx002150] to check the answer A, A1 + B1 B, $A1 + $B1 C, A, $1 + $1 B D, $A $1 + $B $1