excel操作题（Excel operation questions）.docVIP

excel操作题（Excel operation questions） ======= [1-10] the first page. Please operate the excel document as follows: 1, the title line with center, set the font to Lishu, blue. 2, use function to find the total score, the average fill in the corresponding cells. Please operate the excel document as follows: 1, set the table rows and columns: the title for 30, the remaining 20 high of 12, set the column width. The 2 and second line format: font: font size: 20; script; font color is red; yellow shading. Please operate the excel document as follows: 1, please merge the A1 to F1 cells and set them centered; 2, the title of the third group mid-term examination results table font for black, 20, color is red; 3, in addition to the title, all text word size is set to 10, the color is set blue. Please operate the excel document as follows: 1, please use the automatic summation formula to find the total score of each student; 2, please put the third groups of students total score in descending order. Please operate the excel document as follows: 1, please use the average formula to find the average of each student; 2, the average score is shown in red. Please operate the excel document as follows: 1, you will merge the header cell (A1 to F1) and display it in the center; 2. Please set the heading line height to 30; 3, please cell will be beyond the title of (A2 to F8) and add a border line, the line style is 6 (the following). Please operate the excel document as follows: 1. Please merge the header lines (A1 to F1) into the center; 2, the title of the font is set to 25 red, bold black; 3. Change the Sheet1 of this worksheet to score table. Please operate the excel document as follows: 1, the Sheet1 worksheet cell area A1:L1 merge and center, set the title font is bold, red, bold, font 20. 2, use the function to calculate the highest score of Chinese, mathematics and English and the total score, the results were placed in Sheet1 in I15, J15, K15, L15 cell. 3, use range G2:G12 and