excel习题（Excel习题）.docVIP

excel习题（Excel习题） EXCEL exercises [I Volumes] 1 quit Excel 2000 and use the combination key (A) A.Alt+F4 B.Ctrl+F4 C.Alt+F5 D.Ctrl+F5 Number of worksheets in 2Excel 2000 Workbook (D) A.1, B.128, C.3, D.1~255 3 in Excel 2000, the selection of a cell area with the keyboard is the first step to select the cell in the upper left corner of the cell area, and then the D A hold down the Ctrl key and press the down and right cursor keys until the cells in the lower right corner of the cell area B hold down the Ctrl key and press the down and right cursor keys until the cells in the lower right corner of the cell area C hold down the Ctrl key and press the left and right cursor keys until the cells in the lower right corner of the cell area No more than D 4Excel 2000 the maximum number of characters entered in each cell is (C) A.8 B.256, C.32000 D.640K The textual data for 5Excel include (D) A Chinese characters, phrases and spaces, B numbers, C, other input characters, D or more 6 in Excel, enter the date of the day, press groups and keys (B) A.Shift+; B.Ctrl+; C.Shift+:D.Ctrl+Shift 7 in Excel, enter the current time, press groups and keys (C) A.Ctrl+; B.Shift+; C.Ctrl+Shift+; D.Ctrl+Shift+; 8 by default, the number of worksheets for the new job sheet of Excel is (A) A.3, B.1, C.64, D.255 9 in Excel, the correct step to select multiple continuous worksheets is (A) A, B, C, D 10 in Excel, the worksheet split is divided into (B) A horizontal split and vertical split B horizontal split and vertical split and horizontal and vertical simultaneous split C horizontal and vertical split at the same time, D is not above 11 in Excel, the worksheet window freezes, including (D) A horizontal freeze B vertical freeze C horizontal and vertical freeze over D at the same time 12 in Excel97, the steps to create a formula are (B) Type = in the edit bar and press Enter Type the formula and select the cells that need to establish formulas A, C, B, D In 13Excel, the absolute reference to the cel