First, multiple choice questions
1. Open Excel2003 and press _ _ _ _ to quickly open the Files list. ◇Alt+F◇Tab+F◇Ctrl+F◇Shift+F
Answer a
2. In Excel2003, a workbook can contain _ _ _ _ sheets: ◇254◇255◇256◇65536.
Answer b
3.Excel2003 is a tool mainly used in _ _ _ _. ◇ Drawing ◇ Surfing the Internet ◇ Showing slides ◇ Drawing tables.
Answer d
4. In Excel2003, a worksheet is a table composed of rows and columns. What's the difference between them? Numbers and numbers, numbers and letters and letters and letters and numbers.
Answer b
5. Click the Excel command under the Program list to run Excel2003. At this point, there are _ _ _ _ work tabs. ◇4◇3◇2◇ 1
Answer b
6. Which of the following tabs does not belong to the New Workbook dialog box? ◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇◇967
Answer c
7. There are several statements about "creating a new workbook", among which the correct ones are: the new workbook will overwrite the original workbook; The new workbook will appear after the original workbook is closed; Two workbooks can appear at the same time; The new workbook can use shift+n.
Answer c
8. In Excel2003, the following statement is correct: ◇ It can only be saved in the drive according to the directory ◇ It can only be saved in the folder ◇ It can be saved in the drive root directory and folder at the same time ◇ It cannot be saved in the drive root directory and folder at the same time.
Answer c
9. Select the Open option in the File menu to open multiple Excel files at the same time, and only one Excel file can be opened at a time. You can open Excel worksheets and Excel charts.
Answer a
10. In Excel2003, if you use the Rename command in the Format menu, the following statement is correct: ◇ Only change the name ◇ Only change the content ◇ Change both the name and the content ◇ Neither the name nor the content.
Answer a
1 1. Right-click the shortcut menu that appears in the cell, which of the following commands does not belong to it: ◇ Insert ◇ Delete ◇ Delete the worksheet ◇ Copy.
Answer c
12. in Excel2003, each column is represented by the letter "A-Z", which means that there are at most _ _ _ _ _ columns ◇ 10◇26◇52◇ several columns.
Answer d
13. In Excel2003, the formula bar in the edit bar displays: ◇ deleted data ◇ current cell data ◇ copied data ◇ not displayed.
Answer b
14. To rename the worksheet, you can use the following methods: ◇ Click the table tab ◇ Double-click the table tab ◇F5◇ Use the scroll button in the lower left corner of the window.
Answer b
15. In the cell of Excel2003 workbook, you can enter ◇ characters ◇ Chinese ◇ numbers ◇ or more.
Answer d
16. Which option of the Cell Format dialog box can be used to change the mathematical format? ◇ Align ◇ Text ◇ Numbers ◇ Font
Answer c
17. To select an entire column in the worksheet, click the row heading, click the column heading, click the Select All button, and click the cell.
Answer b
18. Which of the following options does not belong to the contents of the math label in the Cell Format dialog box? ◇ Font◇ Currency◇ Date◇ Score
Answer a
On 19. Excel2003, which menu does the operation of adding borders and colors start from? View Insert Format Tool
Answer c
20. In Excel2003, the contents of cells will be displayed as _ _ _ _ _. Edit Bar Title Bar Toolbar Menu Bar
Answer a
At 2 1. Excel2003, add border and color operation. In the cell format dialog box and border label, the selected colors belong to the border: complementary color, protective color, fill color and contrast color.
Answer c
22. The following statement about "deleting the worksheet" is correct: it is not allowed to delete the worksheet; it can be restored after deleting the worksheet; it cannot be restored after deleting the worksheet; none of the above statements are correct.
Answer c
23. In Excel 2003, the correct operation to change the row height and column width of the data area is
Answer c
24. In Excel 2003, which of the following commands will pop up a dialog box? ◇ Cut ◇ Copy ◇ Paste ◇ Paste Special.
Answer d
25. There are five data to be summarized. We only use the mouse to select these five data, but there are no blank cells. What happens after clicking the sum button? The sum saved in the fifth data unit and the first blank unit after the data unit has not changed.
Answer b
26. If the currently active cell is in B2, and then select the Freeze Pane command, it will be frozen: first row, first column, first row, second column, second row, first column, second row, second column.
Answer a
27. The symbol "tick" in the edit bar means: ◇ Confirm input ◇ Cancel input ◇ Edit formula ◇ Edit text.
Answer a
28. The following items correctly describe the filtering function in Excel 12003: ◇ Sorting worksheet data as required ◇ Hiding qualified data ◇ Displaying only data that meet the set conditions; Hiding others ◇ Classifying worksheet data as required.
Answer c
29. In Excel 12003, what are the sorting methods of "main keywords" in the sorting dialog box? Increasing and decreasing decreasing and unchangeable decreasing and unchangeable increasing, decreasing and unchangeable.
Answer a
30. In Excel 12003, when you enter text in a cell, the default alignment method is ◇ left alignment ◇ right alignment ◇ center alignment ◇ both ends alignment.
Answer a
3 1. If the user needs to print one or more worksheets in the workbook, what key can he hold down and then select the worksheet to print? ◇SHIFT◇AIT◇CTRI◇TAB
Answer c
32. In the process of page setup, how to select the content of certain areas? ◇ Click the worksheet tab in the page setup dialog box, click the red arrow in the print preview, then use the mouse to select the area, press enter, drag the mouse directly on the interface, click the worksheet tab in the page setup dialog box, click the red arrow in the print preview, and then use the mouse to select the area.
Answer c
33. Which of the following options can be used to specify the printing direction of worksheet pages as landscape? Enter the page tab in the page setup dialog box, select the horizontal radio box under the direction selection box to enter the print preview option under the file menu, select the horizontal radio box under the direction selection box to enter the worksheet tab in the page setup dialog box, and select the horizontal radio box under the direction selection box.
Answer a
34. There are data in columns 0, 1, 2, 3... 15 * * 16. After clicking Auto Filter, a drop-down arrow will appear. If we select "Top Ten" in the drop-down arrow, there are: 16 data left.
Answer a
35. In Excel 12003, the words "increasing" and "decreasing" in the sorting dialog box mean: the size of data, the sorting order, the number of cells and the above are incorrect.
Answer b
36. When you enter a number in a cell, sometimes the cell is displayed as "# # # #". At this time, because of: data entry error; data digits are too long, it cannot be displayed completely; ◇EXCEL error; system crash.
Answer b
37. If there is a red triangle in the upper right corner of the cell, it means: ◇ data input error ◇ attach a note ◇ insert a graphic ◇ emphasize.
Answer b
38. In Excel 12003, the contents of the first two adjacent cells are 3 and 6 respectively, and the following sequences are ◇9, 12, 15,18 ... ◇12, and.
Answer a
39. If a column is inserted into the worksheet, it is usually inserted below the current column: left, right and bottom.
Answer a
40. If you choose A5 to B7 and C7 to E9, the expressions in EXCEL2003 are: ◇ A5: B7C7: E9 ◇ A5: B7: E9 ◇ A5: E9 ◇ A5: B7: C7: E9.
Answer b
At 4 1. Excel 12003, which of the following functions is used to sum some numbers: ◇SUM?
Answer ◇ average ◇ maximum ◇IP.
Answer a
42. Suppose a cell contains a formula for calculating the difference between the expected sales volume and the actual sales volume. If the actual sales volume exceeds the expected sales volume, a green background color is added to the cell, and if the actual sales volume does not reach the expected sales volume, a red background color is added to the cell. At this time, statements can be applied: ◇ cell format ◇ conditional format ◇IF function ◇IF…THEN.
Answer b
43. Before creating a chart, you must pay attention to the following points: you can choose data at will; The selected data area must be a continuous rectangular area; The selected data area must be a rectangular area; The selected data area can be any shape.
Answer c
44. Generally speaking, the column headings of EXCEL2003 are: ◇ 1, 2, 3…◇A, B, C…◇ A, B, C …? ,П,Ш…
Answer b
45. If the number of decimal places set in the cell is 2, when you enter 12345, it will display: ◇1234500 ◇123.45 ◇/kloc-0.
Answer d
46. In EXCEL2003, the extension of the workbook file is ◇xlw◇xlt◇xls◇xlc.
Answer c
47. Before classifying and summarizing the database, you must: ◇ Don't sort the database ◇ Use the data record table ◇ Sort the classified fields of the database ◇ Set filter conditions.
Answer c
48. When printing in EXCEL2003, in order to print out the row number and column label of the worksheet, it is necessary to set: ◇ page ◇ margin ◇ header/page angle ◇ worksheet in the page settings.
Answer d
49. Copy the formula SUM of cell E 1 (A 1: D 1) to cell E2, and the formula of E2 is ◇ sum (A1:D1) ◇ sum (b1).
Answer c
50. In EXCEL2003, if you want to paginate the worksheet, with 1- 15 as one page and 16-30 as another page, you should select the cell: ◇ b15 ?before adding a page break.
Answer b
Second, multiple choice questions
5 1. In EXCEL2003, you can perform the following operations: data management, chart making, table management and wordart insertion.
Answer ABCD
52.B2: H308 in the worksheet "Sales" contains all sales data. What methods can be used to calculate the total sales in the worksheet "Summary"? ◇ In the worksheet "Summary", enter "= Sales! B2:h308 "▽ In the worksheet "Summary", enter "=SUM (Sales! B2: h308) "In the worksheet" Sales ",select the B2:H308 area and enter" Sales "in the name box; In the worksheet "Summary", enter "= Sales" ▽ In the worksheet "Sales", select B2:H308 area and enter "Sales" in the name box; In the worksheet summary, enter =SUM(sales).
Answer BD
53. In EXCEL2003, you can find the workbook according to: ◇ file name ◇ file location ◇ author ◇ other summary information.
Answer ABCD
54. The difference between the "Clear" command in the "Delete" and "Edit" menus is that ◇ "Delete" deletes the contents of a cell; ◇ Delete can only delete the contents of cells; ◇ Clear command can delete the contents of cells; The clear command can only delete the contents of cells.
Answer BC
55. What are the functions of the list function of Excel 2003? ◇ Easy to add and summarize data in data table ◇ Publish data to SharePoint portal ◇ Establish links with data in portal to facilitate data sharing and collaboration ◇ is an enhanced simulation operation table.
Answer ABC
59. In order to protect the workbook, Excel 2003 has taken the following measures: ◇ Set the opening permission ◇ Set the saving permission ◇ Set the reading permission ◇ Set the modifying permission.
Answer the advertisement
57. To average the four numbers in cells A 1 to A4, you can use the following formula or function: ◇ sum (A1:A4)/4 ◇ (A1+A2: A4)/4 ◇ (A/kloc).
Answer communication
58. With regard to absolute quotation and relative references, the following statement is correct: ◇ When copying a formula, the cell absolute quotation will not change; When copying a formula, the cell relative references will change; When copying a formula, the cell relative references will not change.
Answer communication
59. How to use the option button form control? ◇ The option button form control can be linked to a cell. ◇ The data displayed in the linked cell is related to the order in which the option button was created, and it is displayed in the form of 1, 2,3 ..., which can be used to determine which radio button is selected. ◇ By default, the newly created option button is linked to the previous option button in the same cell. ◇ If you want to create a new one.
Answer ABCD
60. Please select the steps that cannot start Excel2003 correctly. Click the "My Computer" button on the desktop, and then select the "Programs" option. Select the Microsoft Excel2003 option in the Program menu to display the Microsoft Excel2003 work screen. Select the "Microsoft Office" option in the "Program" menu to display the Microsoft Excel2003 work screen.
Answer communication
6 1. The following statement is correct: ◇ The shortcut key for creating a new workbook is "Ctrl+N" ▽ "New" command ◇ You can also use "Alt+N" in the file menu to create a new workbook ◇ Press Alt+O and then press the "N" key.
Answer AB
62. In view options, you can set whether to display grid lines, sheet labels, scroll bars and line numbers and columns.
Answer ABCD
63. Click a cell in Excel2003 to delete its contents, but keep the auxiliary cells. What operations can be used? Press the delete key? Use the delete command? Use the delete cell command? Use the copy command.
Answer AB
64. The following statements about icon tables and embedded tables are correct: icon tables only have icons, while embedded charts are included in data worksheets; Embedded tables only have icons, and chart tables are included in the data worksheet; Chart table and embedded chart can be converted to each other; Chart table and embedded chart cannot be converted to each other.
Answer communication
65. In Excel2003, which of the following commands ◇ Copy command ◇ Delete cell command ◇ Delete cell command ◇ will appear in the shortcut menu?
Answer ACD
66. In Excel2003, the following statements about "DELETE" and "delete worksheet" are correct: ◇delete is to delete the contents of the worksheet ◇ "Delete worksheet" is to delete the worksheet and its contents ◇ ◇ Delete key is equivalent to delete command ◇ ◇DETETE key is equivalent to delete worksheet command.
Answer ABC
67. What are the correct uses of macros? ◇ If an Excel document contains macros, you may be prompted that macros are disabled when opening the document. You can set the macro security to low, and then reopen the document so that the macro can be recorded in VBA code. Therefore, if you don't understand VBA development, you won't be able to record macros, but macros can record operation steps. When you run the macro, you can re-execute the recorded operation. You can assign a command button form control to a macro so that you can click the button to execute the macro.
Answer ACD
68. What functions can be achieved if Excel tables are published on the web page? You can publish data tables and charts to web pages. You can add interactive functions for users to filter data in web pages. You can add interactive functions for users to manipulate pivot tables in web pages. You can publish a single worksheet or an entire workbook to a web page.
Answer ABCD
69. In Excel 2003, how to enter regular data in cells? ◇ Click to select a cell and enter data.
Answer the advertisement
70. Which of the following shortcut keys is used correctly? ◇Ctrl+A: Select the whole worksheet ◇Ctrl+Shift+ Drag a cell: Copy the cell and paste it to the target location ◇ Ctrl+; : Insert today's date ◇F4: Set the absolute or relative reference mode.
Answer BCD
7 1. There are 12 worksheets in the same workbook. How to create an attendance record table with the same format and title in each worksheet, but without data? ◇ First, make an attendance record table on 1 worksheet, then copy it to other tables, and paste the column width with selective paste ◇ First, make an attendance record table on 1 worksheet, and establish cross-table references in the corresponding cells of other tables to make it equal to the corresponding cells of the first table ◇ Right-click the worksheet tab and select "Select all worksheets". Then make an attendance record in the current table ◇ First, make an attendance record on the 1 worksheet, then right-click the worksheet tab, select all worksheets, select the attendance table area, and select Fill in the edit menu to go to the same worksheet.
Answer ACD
72. The column headings of the expense list include date, department, name, reimbursement amount, etc. What method can be used to calculate the reimbursement amount by department? ◇ Advanced filtering ◇ Classification summary ◇ Calculation with SUMIF or DSUM function ◇ Calculation with PivotTable.
Answer BCD
73. Which of the following is correct about the usage of filling data? Cell data is "Department1"; Cell data is "Department 2, Department 3 ..."; Cell data is "Department1"; Cell data is "one"; Cell data is "two, three, four".
Answer communication
74.Excel 2003 has added many INTERNET/intranet functions, including: linking to other OFFICE documents; linking to the WEB◇; saving in HTML format; creating hyperlinks.
Answer ABCD
75. Column B records the expiration date of the labor contract, and it is hoped that a prompt will be displayed in the adjacent cell of column C: "Expired soon" will be displayed within 30 days before the expiration date, and "Expired" will be displayed after the expiration. How to write the function of C2 cells? ◇= IF(B2 & lt； TODAY()+30, "expiring soon", "expired") ◇ = if (B2
Answer CD
76. In Excel2003, what methods are commonly used to copy data? Hold down the left mouse button and drag to the destination, then release the mouse. Select the copy option under the edit menu. Right-click the selected cell and select the copy option from the shortcut menu that appears.
Answer ABCD
77. Users are only allowed to fill in data in designated areas, and other areas cannot be destroyed, and worksheets cannot be deleted. What should I do? ◇ Set "Allow users to edit the range" ▽ Protect the worksheet ◇ Protect the workbook ◇ Add a password to open the file.
Answer ABC
78. When creating a worksheet in Excel2003, which of the following can't delete the F column of the worksheet? ◇ "Click the column number F and select Delete under the File menu.
◇ Click the column number F and select the Delete button under the Edit menu ◇ Click the column number F and select the Cut button on the toolbar.
◇ Click the column number F and select "All" under "Clear" under "Edit" menu.
Answer ACD
79. The following statement is correct: the delete command belongs to the file menu; The edit menu contains a copy command; The exit command belongs to the file menu; There are only four command options in the file menu.
Answer BC
80. In Excel 2003, which of the following operations can be achieved by keeping the values in cells to two decimal places? ◇ "Effective Data" under "Select" and "Data" menu.
◇ "Select a cell, click the right mouse button and select" Cell Format ".
◇； Select the "Increase Decimal Scale" or "Decrease Decimal Scale" button on the toolbar.
Select the menu Format, and then select Cells ... ""
"
Answer BCD
At 8 1. Excel2003, the following statement is true: _ _ _ _. You can only merge right, left, left and right, and up and down.
Answer BCD
82. What are two ways to select several consecutive cells in a row (column): hold down and drag the mouse to select multiple cells at a time; Click the cell that starts with the selected row (column); Hold down the Shift key, and then click the cell at the end of the row (column); You can click to select one of the cells, hold down the Ctrl key, and then click the other cells you want to select.
Answer the advertisement
83.Excel2003 can't convert the worksheet into the following formats required for web pages. ◇HTML format ◇TXT format ◇BAT format ◇EXE format.
Answer BCD
84. After I created the new workbook, I didn't fill in any data. I hope the font size of all worksheets is 10. What should I do if I add a new worksheet in the future? ◇ Modify Tools → Options → Settings in Editing → Change Tools → Options → Standard Font Size Settings under General, reopen Excel◇ → Right-click the worksheet tab, select Select All Worksheets, then select all cells in the current worksheet and set the font size to 65438.
Answer BD
85. The following statements about row height and column width are incorrect: ◇ Their units are centimeters ◇ Their units are millimeters ◇ They are relative values defined by the system and are dimensionless quantities ◇ None of the above statements are correct.
Answer ABD
86. The statement about "Save" and "Save As" commands is correct: Save can be used to save files; Save As command can also be used to save files; Saving will change the name of the file; The Save As command can be saved to a new file again.
Answer ABD