exctm(国外英文资料).docVIP

exctm(国外英文资料) T1 data entry Experimental purpose: 1 、 familiar with the window interface of the EXCEL worksheet; 2, master text, date, text type digital input method; 3. Master the automatic filling of data sequences. Experiment content: Open the D:\excks\ex1.XLS document and complete the following actions to save the original document in the Key folder. 1. According to the chart in worksheet Sheet1, the data in the worksheet is input and modified; 2, in the worksheet SHEET2 below the figure, enter the corresponding content in the diagram. The use of the T2 operator Experimental purpose: Grasp the use of arithmetic operators and string concatenation operators. Experiment content: Open the D:\excks\ysf.XLS document to complete the operation requirements in worksheets Sheet1 and sheet2. Then save the original document in the Key folder. T3 editing and formatting Experimental purpose: 1 、 be familiar with the interface and function of EXCEL worksheet; 2. Master the editing, moving, deleting and editing of the worksheet. 3. Learn how to format, format, copy, and format EXCEL worksheets. Experiment content: Open the D:\excks\exbg1.XLS document, do the following, and then save the original name document in the Key folder. 1. Perform the following actions on the worksheet called the data table: 1) merge the A1:I1 cells in the middle and enter the title 97 student test results. 2) copy the contents of the A2:A10 cell to J2, and then delete the A2:A10 cell area; 3) insert a new column between column H and I. Enter the field name date in the I2 cell and start with the padding from the third line, producing data from 1993-3-1 to 1993-3-8. 4) the first line title characters are set as red, 18, bold, bold and centered. 5) the A and B two column column width settings using the menu command to 6; 1 to 10 rows high to 21, A1:J10 will be set to the level of regional center and vertical center; 6) set the date of birth in the form of XXXX, XX, XX. 7) use the formula to calculate the