excel2000试题集（国外英文资料）.doc

excel2000试题集（国外英文资料） EXCEL2000 simulation test If you have both worksheets and charts in your workbook, Excel will () when you click save from the file menu. A: save only the worksheet B: save the worksheets and charts in two files C: keep the worksheets and charts in a file D: just save the diagram Set area A1: the number of cells in the A8 cells is 1, A9 is a blank cell, A10 is a string, and the function AVERAGE (A1: A10) is the result and the formula (1). ) the results are the same. A: = 8/10 B: = 8/9 C: = 8/8 D: = 9/10 In A1: A3 data is 1, 2, 3, and in B1: B4 data is 4, 5, 6, 7, and if you enter a string in A4, the following statistics function (s) The results will change. A: = SUM (A1: B4) B: = MAX (A1: B4) C: = MIN (A1: B4) D: = COUNTA (A1: B4) 4. When only need copies of the current cell formula to another cell without the need to copy the cell format, should be performed in the edit menu ( ) command, and then execute the () command in the edit menu after selecting the target unit. A: copy B: cut C: paste D: selective paste In EXCEL, the selected database area should not include the name of the database in the database () operation. A: screening B: sorting C: statistics D: sort The COUNT function COUNT counts the number of () in the cell area A: data type number B: text character C: data and text character D: none of the above The following function is not a statistical function () A: SUM B: AVERAGE C: COUNTA D: DATE Which of the following is not a financial function () A: DDB B: FV C: PMT D: AND Edit the clean command under the menu, not clear () A: format B: content C: cell D: notes To enter the correct method of one in eight of the score in a cell. A: 0 space 1/8 B: space 1/8 C: 1/8 D: none of the above 2, fill in the blanks (2 points, 20 points) If the number is entered in the cell, the number is automatically aligned. When the array formula is entered in the selected cell, press the () key. The operation of the worksheet includes movement, (), (), increa