nit excle 题目（Nit 题目 EXCLE）.docVIP

nit excle 题目（Nit 题目 EXCLE） Unit 1 edits the worksheet content Task one Open the .Xls (1) Excel in the material file and complete the work sheet according to the requirement. 1., in the numbered column, using sequence filling methods, respectively, XS001-XS008 and QH001-QH005 two groups of data input; 2. enter LU Hong contact phone, text type data 3. enter Li Yan E-mail address limengm@; 4. insert two blank lines at the top of the table, merging the A1:H1 cells into the center; 5. in the merged cells, enter the title text, employee address book, and set the font for boldface, font 20, bold; 6. insert an empty column on the left side of the table; 7. rename the worksheet Sheet1 to address book; 8. save the file in the folder. The file is called employee address book.Xls. Task two Open the Excel (2).Xls in the material file, and input and sort out the basic information of the company staff. 1. fill the IC card number, and the data value is from 0038150 to 0038169; According to the 2. exercises (2) a specimen of.Jpg, a company registered in the date column to fill in the corresponding data of date type; 3. rename the worksheet Sheet1 to registry; 4. combine the table header with the four sector cells, centered and centered vertically; 5. save the file, which is called employee registration form.Xls. Task three Open the Excel (3).Xls in the material file and complete the editing and operation of the worksheet as requested. 1. exercises a reference sample (3) specimen of.Jpg, fill in the start city column data; 2. exercises a reference sample (3).Jpg, using copy proofs fill discount column data; 3. exercises a reference sample (3) sample.Jpg, fill out the discount ticket column data, and set to two decimal places; 4. exercises a reference sample (3) sample.Jpg, fill out the booking hotline telephone number; 5. insert an empty column on the left side of the table; 6. rename the worksheet Sheet1 to discounted ticket, delete the worksheet Sheet2 and Sheet3; 7.