56-大学计算机基础操作题（56- university computer basic operation question）.docVIP

56-大学计算机基础操作题（56- university computer basic operation question） University computer basic operation question 1, produced by PowerPoint company introduced the requirements of each slide, slide the upper right corner of the company logo (logo picture file comp.jpg already exists), how do I do one set? Give the main operation steps. Answer: (1), start PowerPoint, create a new presentation, select the appropriate template layout and design, built the first slide, also need to slide, the implementation of the insert menu under new slide add a new slide; (2), the implementation of the view -- mother -- slide master into the master view, then the implementation of the insert -- picture -- from the file - find the logo picture file comp.jpg, click insert button, drag into the company logo on the right in the picture angle, close master view, after the completion of all new slide right corner company logo picture. 2. Suppose you have the worksheet shown in the table below. You are required to count the total sum and the average score and sort them in descending order. Describe the operation procedure. A B C D E F H G One No. Full name Computer basis College Chinese College English Advanced mathematics The total score Average Two Twenty million forty thousand two hundred and one Zhang was Eighty-nine Sixty-nine Sixty-eight Sixty-seven Three Twenty million forty thousand two hundred and two Etc. Eighty-seven Eighty-four Ninety-three Eighty-nine Four Twenty million forty thousand two hundred and three Ted Ninety-eight Eighty Eighty-seven Eighty-four Five Twenty million forty thousand two hundred and four Zhao Jing Eighty-one Ninety-four Eighty-six Eighty-eight Answer: (1) start Excel, open the workbook document that contains the schema work, and select the worksheet containing the chart table data as the current worksheet; (2), selected H2 cell, click the button and toolbar on the system automatically selected for regional and C2:F2, click the edit bar on the left side of the i