计算机3(国外英语资料).docVIP

计算机3(国外英语资料) 1, in a cell to enter the formula or function, the leader must be _=. 2, assume that the formula saved in the cell D3 is =B3+C3, and if you move it to E4, the formula saved in E4 is =B3+C3. 3, assume that the formula saved in the cell D3 is =B3+C3, and if you copy it into E4, the formula saved in E4 is =C4+D4. 4, assume that the formula saved in the cell D3 is =B$3+C$3, and if you copy it into E4, the formula saved in E4 is =C$3+D$3. 5, in Excel, assume that the formula in which a cell is stored is =13*2+7, and when the cell is in the non editing state, the content displayed is 33. 6, in Excel to find a set of values in the maximum function is MAX. 7, in Excel find a set of values in the average function is AVERAGE. 8, in Excel, when sorting data tables, the sort key specified in the sort dialog box is 3. 9, in Excels automatic selection, each title of the selected data table (property name) corresponds to a drop-down menu. 10, in the advanced filter of Excel, the condition of the same row in the conditional region is relationship. 11, in the advanced screening of Excel, conditions or relationships that do not correspond with conditions. 12, in the standard type of the Excel chart, there are 14 kinds of chart types. 13, in the Excel chart, the chart type that reflects the trend of data changes is a line chart. 14, in the Excel chart, the level of X axis is usually used as a classification of shaft _ 15, in creating the Excel chart, the first step is to select the type of chart. 16, in creating the Excel chart, the third step is to select the chart options. 17, in Excel, the toolbar that can select and edit any object in the diagram is the chart toolbar. Internet applications 1, below is the Web address of a units home page, URL, in which the symbol URL is Http://. 2, IE browser browser page, in the address bar to enter web site, you can usually omit the http:// 3, to quickly save the page to your favorite list, press the CTRL+D key 4, search engines ar