计算机基础知识试题2（国外英文资料）.doc

计算机基础知识试题2（国外英文资料） Spreadsheet software EXCEL review and answer A single topic: In Excel, the correct description of delete and clear is () The deletion of the specified area is to remove the data from the area along with the cell from the worksheet. Clear the specified area to clear only the data in the area and the cell itself remains. The content of the delete is not recoverable, and the contents of the purge can be restored. C. Delete and delete all do not move the cell itself, but the delete operation empty the original cell. The cleanup operation changes the contents of the original cell to 0 The D.D EL key functions as a delete command A set of cells is referenced in a formula: (C3: D7, A2, F1), the total number of cells cited by the formula is () A, 4, B, 8, C, 12, D, 16 When you enter the formula in the cell, the first symbol you enter is () A, = B, + C, -d, $ 4, to sort of work table contains a title line, when the sort dialog in the current data list box, select the no header row option button, the header row () A, will participate in the sorting; B, will not participate in the sorting; C, the position is always on the first line; D, always in the penultimate line; 5, Microsoft Excel, when using the wrong parameters or operand types, or when the automatic correction formula function cannot be corrected formula, will produce error values () A. # # #! B: # div / 0! C. # name? D. # VALUE! In Excel, the correct description of filtering is () A. Automatic screening and high screening can then filter the results into other areas. B. The screening conditions must be given in another area before performing the advanced screening. The conditions for automatic screening are only one, and the requirements for advanced screening can be multiple. D. If the selected condition appears in the multicolumn, and there is a relationship between the conditions, a high-level filter must be used. In EXCEL, the function SUM (A1: A4) is equivalent to (). A, SUM (A1 * A4) B, SUM (