《office 办公软件》试题一（Office software test a）.docVIP

《office 办公软件》试题一（Office software test a） Office software test a A fill in the blank. 1, select the menu command, you can insert a new worksheet; select the menu command, you can delete the active worksheet. 2, find the data usually select the menu command menu command; usually choose to replace the data. 3, the work table is the main tool for Excel storage and processing; a workbook can contain a table. 4, a work table consists of rows and columns. 5, set the character format data, the font specified character, font specified character. Two, select the 1, in the cell Excel worksheet in the input formula, should first input (number). A, B, C, D, = 2, in Excel 2000, in print transcripts of students, the grade with striking patterns (such as red, etc.) when dealing with a lot of students performance, using the most convenient command (). A, B, C, find the conditional formatting data, location selection of D 3, in Excel, A1 cell to set the digital format as an integer, when the input is 33.51, shown as () A, 33.51 B, 33 C, 34 D, ERROR 4, to close the workbook, but do not want to exit the Excel, you can click (). A, file drop-down menu in the off command B, file drop-down menu in the exit command C, close the Excel window button * D, a window drop-down menu in the hidden command 5, Excel 97, have one cell in the numerical two decimal places, the following (not implemented). A, select the effective data menu B, select the cell right click, select the format cells C, select the toolbar button to increase the number of decimal places or reduce the number of decimal places D, select the menu format, and then select the cell... In 6, Excel in file name lookup, instead of any single character (available). A, B, C, *?! D,% 7, in Excel, the user to enter a date in the work table, (a) does not comply with the date format. A,20-02-2000B, 02-OCT-2000 C, 2000/10/01 D, 2000-10-01 In 8, Excel print page 97, add header and footer is (). A, executive [file] [page setup menu], select [