excel测试题1(Excel quiz 1)

excel测试题1（Excel quiz 1）excel测试题1(Excel quiz 1)

The following _____ is wrong

+ Excel menu commands have corresponding tool buttons corresponding to them

The Excel2003 menu commands are gray and the command is invalid + Excel2003 tool buttons always work

When the excel 2003 menu commands are gray, you can use the corresponding tool button answer

2. In excel 2003, _____ is available in the activity cell

+ input text

Input graphics

+ setting borders

+ set the super link answer

3. In the "cell format" dialog box in excel 2003, you can set the _____ of the selected cells

+ alignment

+ font

+ background

+ merge or split

In Excel2003, the type of data input to the active cell is _____ + character

Note type

+ numeric

+ date,

5. The following list of items belonging to the excel 2003 address is referred to as _____

The A5

9 f

+ C $5

+ $B5

6. In the excel 2003 worksheet, the row height can be changed to

_____

+ use the "line/line" command in the "format" menu

Use the "line" command in the "insert" menu

+ by dragging the mouse

Set font size

7. For excel 2003, you can select a certain data area to establish a graph. When the data in this data area changes, the following statement is incorrect

The diagram needs to be regenerated to change

The diagram will automatically change accordingly

+ you can change the chart by clicking the refresh command in the view menu

The system will give an error message

8. The method to remove a single line of content in excel 2003 has _____

+ select line number and press Del key

Click the "clear content" TAB on the pop-up menu

Drag with the mouse

Use the "clear/all" command in the edit menu

9. The method of selecting cells in excel 2003 has _____

+ enter the cell name directly in the cell name box in the upper left corner of the window

+ mouse click

+ cursor movement key

The "select" command under the edit menu

10. The function of the record sheet is ___

+ query record

Modify or delete

+ create a new record

Output the query result to another table

The following statement about the established graph is ___

A + graph is a special type of worksheet

The data in the chart is also editable

The + diagram can be copied and deleted

The items in the chart are integrated and cannot be edited separately

The three elements of Excel are ___

+ worksheet

+ workbook