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 themThe Excel2003 menu commands are gray and the command is invalid + Excel2003 tool buttons always workWhen the excel 2003 menu commands are gray, you can use the corresponding tool button answer2. In excel 2003, _____ is available in the activity cell+ input textInput graphics+ setting borders+ set the super link answer3. In the "cell format" dialog box in excel 2003, you can set the _____ of the selected cells+ alignment+ font+ background+ merge or splitIn Excel2003, the type of data input to the active cell is _____ + characterNote type+ numeric+ date,5. The following list of items belonging to the excel 2003 address is referred to as _____The A59 f+ C $5+ $B56. In the excel 2003 worksheet, the row height can be changed to_____+ use the "line/line" command in the "format" menuUse the "line" command in the "insert" menu+ by dragging the mouseSet font size7. 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 incorrectThe diagram needs to be regenerated to changeThe diagram will automatically change accordingly+ you can change the chart by clicking the refresh command in the view menuThe system will give an error message8. The method to remove a single line of content in excel 2003 has _____+ select line number and press Del keyClick the "clear content" TAB on the pop-up menuDrag with the mouseUse the "clear/all" command in the edit menu9. 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 keyThe "select" command under the edit menu10. The function of the record sheet is ___+ query recordModify or delete+ create a new recordOutput the query result to another tableThe following statement about the established graph is ___A + graph is a special type of worksheetThe data in the chart is also editableThe + diagram can be copied and deletedThe items in the chart are integrated and cannot be edited separatelyThe three elements of Excel are ___+ worksheet+ workbook+ cellareaIf you select a contiguous area, the following method is _____Add the mouse to the leftDrag to the right with the mouseAdd the mouse to the diagonalUse the SHIFT key and the cursor keys14. The current cell is F4, and the input formula for F4 is "= SUM (A4: E4)" means ___Sum the values of the A4 and the E4 cellsAdd the values of A4, B4, C4, D4, and E4 cellsPlus the sum of the values in all the cells on the left of the F4cellSum of the values of all the cells on the left of F4 and F4The alignment in the cell format is ___+ levels+ vertical+ text directionThe leftThe return value of the following functions is equal to 100 with ___ The SUM (10, 10)+ PRODUCT (10, 10)ROUND (143.24, 1)+ MAX (20,30,80,100)The following statements are true _____A workbook can create up to 255 worksheetsA workbook can build up to three worksheets+ the name of the worksheet USES up to 15 Chinese charactersA maximum of 320,000 characters can be entered in a cell18. To select all areas, the following error is ___CTRL + AAccording to the selection button+ SHIFT + A+ edit/selectThe "clean" command in the "edit" menu in Excel can be ___+ clear the entire contents of the cell+ clears the text or formula inside the cell+ to clear the comments in the cell+ clears the format of cellsThe status bar in Excel is used for ___+ displays current working status+ display keyboard mode+ display trial arithmetic informationDisplay edit content21. There are many built-in digital formats in Excel, and the following number format is correct when the "56789" is entered When setting the normal format, it can be displayed as "56789".When you set the number format of a thousand delimiters, it can be displayed as "56,789".+ set the numerical format of the thousand delimiters, which can be displayed as "56,789.00".+ setting the currency format with a thousand separators, it can be displayed as "$56,789.00"22. The classification summary of Excel includes ___The mean +A maximum ++ count+ sumIn Excel, you can use it when the shape of the mouse is hollow + drag to select certain cellsSelect a worksheetSelect a menu item or icon button+ select a cell to enter data24. If you want to define Sheet1, Sheet2, Sheet3, and Sheet3 worksheets (consecutive) as worksheet groups, the following operation method is correctClick on the Sheet1 TAB, press the Ctrl key, click the Sheet2 TAB, and click the Sheet3 TABClick on the Sheet1 TAB, click the Sheet2 TAB, and click the Sheet3 TABClick on the Sheet1 TAB, press the Ctrl key, and click the Sheet3 TABClick the Sheet1 TAB, press the Shift key, and click the Sheet3 TAB To insert a new column between the d-column and E columns, the first operation to do is _____Click the D column+ click on the E column numberClick either cell in the D column+ click either cell in column ETo undo a recently executed command, which of the following methods is available for ___Click the undo button on the commonly used toolbar+ Ctrl + ZCtrl + Y+ execute menu command editor/undoThe following is the formula for the formulaThe formula must start with the equal sign "="A + formula can be a cell reference, a function, a constant, and any combination of the operatorsIn the cell, the column label must be given directly, and the line number can be calculatedThe unit of reference, can be a number, can be a formula28. In Excel, if you want to set an active cell, you can use the following ___ methods+ execute the "locate" command in the edit menuExecute the options command in the tools menu+ use the cursor key to move the active cell to the cell of the activity cell+ click the mouse directly to set the cell of the activity cell The following _____ is available in Excel+ can automatically save workbook file+ band password to save workbook file+ save the workbook file with a new name+ can save workbook file by setting up backup to save the modified content30. The effective operation of a workbook in multiple workbooks to be opened is ___+ click the corresponding workbook name below the window menu+ click anywhere in the corresponding workbook in the tile workbook Click the workbook button on the task barClick the corresponding file name below the menu itemIn the Excel operation, when the shape of the mouse is left finger, you can use it to answer the answer: BCSelect some cellsSelect a worksheetSelect a menu item or icon buttonSelect a cell to enter the data32. If you change the contents of a cell in the worksheet, you will find that the cell you are changing is not the cell you need, and the original contents of the cell will be restoredPress the ESC key +Press the return keyPress the TAB key+ click "x" in the edit boxThe following statement is incorrect to be ___A + accounting format is a currency format+ the accounting format is different from the monetary symbol usedin currency formatThe accounting format aligns all the currency symbols in the cell to the left, aligning the Numbers to the rightA + currency format aligns all currency symbols in the cell to the left, aligning the Numbers to the right34. In the following statements about the Excel worksheet, workbook, etc., the correct ones are ___A workbook can contain up to 255 worksheets+ a new workbook contains three worksheets by defaultA worksheet can contain 65536 by 256 cells+ a cell can be stored in text, Numbers, dates, times, and formulas The following ___ is a function of ExcelAbility to automatically save workbook files on a regular basis + band password to save workbook file+ save workbook file with a new name+ can create backup files when saving workbook files to save the modified content36. In Excel, not all command execution can be revoked, and the following ___ operation cannot be undone once executedInsert worksheet+ copy worksheetDelete worksheetMove the activity cell37. The following information about entering data into Excel cells is correctThe input text is directly input from the combination of Numbers and Chinese and Chinese textThe input text is simply a double quotation mark when it is made up of the NumbersWhen you enter a score, you must first enter 0, and then enter the score with half of the corner spaceEnter points with an interval of one and a half Spaces between integers and fractionsThe style in Excel refers to a combination of data formats that can include the answer of format types like ___ : BCDdigital+ font+ alignment+ designThe following selection of cells is correct+ you can select multiple columns or rows by dragging the mouse + click on the line number to select the entire row cellIf you want to select several adjacent rows or columns,Select the first or first column, then hold down the Ctrl key to select the last row or columnExcel can't select several discrete cells at the same time40. Enter a value of 3000 in the Excel cell, and the expression equal to it is+ 300000%+ = 3000/130 + e + 2+ 3000After selecting the cell in the Excel worksheet, delete the contents of the cell+ < BackSpace > keyThe < Ctrl + X > key combinationThe delete command+ clear command42. In the Excel worksheet, available data formats are available+ text+ numerical+ dategraphicsIt is true that the following diagrams are made up of the partsThe data mark is the bar, area, dot, sector, or other similar symbol in the chart, which comes from the single data point or value of thework form elementDepending on the type of chart, data markers can represent values, data series names, percentages, etcThe + data series is also called classification, which is a set of related data points on a graph, taken from a list of work tables or rows The drawing area is in a two - dimensional graph, which is theregion of the axis (not including all data series).In a three-dimensional cylindrical graph of multiple data series,the method of solving this problem can be solved by blocking thecylinder in front of the cylinderSelect another chart type+ set a series of identifiers to be transparent+ change the perspective of the chart+ all the methods are correct45. Which of the following can open the [add trendline] dialog boxto add a trend line?Double-click the data series lineRight-click on the data series line and select [add trend line] commands from the pop-up menu+ left click the data series line, select [add trend line] command in [chart] menuAll of the above is correct46. The claim that the form is sorted is incorrectOnly numeric types can be used as the basis for sortingOnly date types can be used as a basis for sortingPlus strokes and pinyin cannot be used as a basis for sortingThe sort rules have ascending and descendingThe following information about user-defined collation in Excel is correctThe user can enter the order of the item to be defined+ users can only customize the sort of partial textThe user is simply selecting the sort order option to define the item in the [sort option] dialog box, not fully user-defined Users can pair the Arabic Numbers (1, 2, 3...). Do custom sort。