Current location - Education and Training Encyclopedia - Educational institution - Problems of information technology operation in junior high school
Problems of information technology operation in junior high school
After starting Excel, please follow the following requirements: 1. Open the file "z: \ xls" 2. Merge area "A 1:O 1 "3. Change the fill color of the cell "A 1:O 1" to "yellow" 4. Change the cell "A 1:O 1". Change the vertical alignment to Center 5. Enter the summation function "= sum (B4: M4)" in the cell "O4" 6. Change the data type of cell "O4" to "Numeric", accurate to two decimal places. After starting Excel, the operation is as follows: 1. Open the file "Z:\EXCEL operation. xls" 2。 Merge area "A 1:I 1" 3. Change the font size of the cell "A 1:I 1" to:. Sort the data: 5. Filter the data according to the following requirements: (1) screen out the students in Class 6, Grade 1; 6. Insert the worksheet into the current workbook, so that the total number of worksheets is "2". Click the first cell I3 under Actual Score, and then click the Sort in Descending button on the toolbar. 5. Click any cell in the second row, click Filter in the Data menu on the menu bar to select Auto Filter, and then click the B2 cell drop-down option 6 1 level. 6. Click the Insert menu "Worksheet" on the menu bar to start Word, as follows: 1. Open the document "z:" litchi honey. doc "2。 Change the font size of paragraph 1 to 3. Center the alignment of paragraph 1 4. Indent the first line of paragraph 2 by "2.0" characters 5. Change the color of paragraph 2 to "green" 6. Insert the title "litchi honey" 7. Put the page. The left is "3.00 cm" and the right is "3.00 cm". After starting FrontPage, follow the following requirements: 1. Open the file located at "z: \ index3.htm" 2. Set the address of the page background picture to "z: \ background.gif" 3. Insert a picture into a web page, a picture. The display text is "contact us" and the link address is "mailto:hongqi@2 1cn.com". After starting Excel, follow the following requirements: 1. Open the file "Z:\ Attachment EXCEL2. XLS》2。 Enter the sum function "= sum (D4: J4)" in cell K4. Enter the sum function "= sum (D5: J5)" in cell K5. Enter the sum function "= sum (D6: J6) "5. 6. Enter the sum function "= sum (D8: J8)" 7. Enter the sum function "= sum (D9: J9)" 8. Generate a chart with "D3:J9" as the data source, with the chart type of "Cluster Column Chart" and the chart title of ". Observe the following requirements: 1. Click the New button to create an empty workbook. Make the total number of currently open workbooks 12. Enter the text in the cell "A 1": "interim result statistics" 3. Enter the text in cell "A2": "Name" 4. Enter the text in cell "B2": "Chinese" 5. Enter the text in cell C2: Math, Inner Border, Line Style No.7 on the left and Line Color Automatic. 9. Change the horizontal alignment of cell "A2:E2" to "center" and the vertical alignment to "bottom".