A.CPI/IP B.PCT/IP C.PTC/IP D.TCP/IP 8.The transportation protocol of E-mailis( A.SMTP B.TELNET C.HTTP D.FTP 9.The structure of a table created by Microsoft Access can be modified by( A.Insert B.Delete C.Update D.None ofthem 10.For a 24-bit color vide(resolution:640*480)with the frame rate of 25,if it is not compressed,what is the required memory space for a two-minute length?( A.2764.8MB B.21093.75MB C.351.56MB D.2636.72MB 1 2 3 4 5 7 9 10 Table 1 Design:[20*4=80 points] The design part includes Excel,webpage design,flash animation and Access database.Required files can be found in the folder named "2012 CSexam",which is a subfolder in the "shared folder"on your desktop.Please copy this folder to your local hard disk.Exams are expected to be completed according to the requirements and all newly generated files should be saved in a folder named as"your surname_your studentiD"(e.g.Sommer_110923).This folder should be submitted when the exam isfinished. 1.Excel [20 points] Open the source file"test_data.xls"in the"Excel2012"folder,complete the following operations and save the final Excel file in yourfolder"surname_yourstudentID 1.1 Use conditional formattingto setcells of"Age",when the age value is between 40 and 55,setcorresponding cells'background as"Green fill with dark greentext",see figure 1. 1.2 Inserta newfield named as"Avg_salary"at"cell,fill the average salaryvalue in the cell of"2",see figure1 1.3 Inserta new field named as"Salary_level"at"G1"cell,if the salary is bigger than or equalto the average salary, setthe cell value as"High",otherwise setit as"Low",see figure 1. 1.4 Choose3fields(i.e.Name,Salary,Bonus)and insert a2-D"Line with markers"chart,seefigure1.A. CPI/IP B. PCT/IP C. PTC/IP D. TCP/IP 8. The transportation protocol of E-mail is ( ) A. SMTP B. TELNET C. HTTP D. FTP 9. The structure of a table created by Microsoft Access can be modified by ( ) A. Insert B. Delete C. Update D. None of them 10. For a 24-bit color video (resolution: 640*480) with the frame rate of 25, if it is not compressed, what is the required memory space for a two-minute length? ( ) A. 2764.8MB B. 21093.75MB C. 351.56MB D. 2636.72 MB 1 2 3 4 5 6 7 8 9 10 Table 1 Design: [20*4=80 points] The design part includes Excel, webpage design, flash animation and Access database. Required files can be found in the folder named “2012_CSexam”, which is a subfolder in the “shared folder” on your desktop. Please copy this folder to your local hard disk. Exams are expected to be completed according to the requirements and all newly generated files should be saved in a folder named as “your surname_your studentID” (e.g. Sommer_110923). This folder should be submitted when the exam is finished. 1. Excel[20 points] Open the source file “test_data.xls” in the “Excel2012” folder, complete the following operations and save the final Excel file in yourfolder “surname_your studentID”. 1.1 Use conditional formatting to set cells of “Age”, when the age value is between 40 and 55, set corresponding cells’ background as “Green fill with dark green text”, see figure 1. 1.2 Insert a new field named as “Avg_salary”at ‘‘i1’’ cell, fill the average salary value in the cell of “i2”, see figure 1. 1.3 Insert a new field named as “Salary_level” at ‘‘G1’’ cell, if the salary is bigger than or equalto the average salary, set the cell value as “High”, otherwise set it as “Low”, see figure 1. 1.4 Choose 3 fields (i.e. Name, Salary, Bonus) and insert a 2-D “Line with markers” chart, see figure 1