计算机应用基础excel（Fundamentals of computer applications Excel）.doc

计算机应用基础excel（Fundamentals of computer applications Excel） Excle 2003 electronic form system The first problem with the formula, the average insert function for sum = average and if value condition function, select menu file to set the cell data format 1. open the test file directory EXCEL-6.xls 2. calculation of roe, net assets yield = net profit / total net assets 3. roe to retain three decimal percentage forms (such as: 32. 310%) Operation steps: The rate of return on net assets of B5 cell type =B4/B3 filling handle left to choose the right corner of the B5 onto the E5 Choose roe menu format, data format, the percentage of cells with 3 Open the current test file directory using excel-1.xls formula to calculate each item of total total column number of the original format and other data in the same format Insert the SUM sum function Select the original format data, choose format, click brush brush the total number of columns Open the current directory file excel-7.xls test were used to calculate the total score of function, average score Insert the SUM sum function Insert the average function for the average (not to count the total score) 1. open the current directory file excel-71.xls test; 2. using the function to calculate the value of the prize, for the 40 formula is a full load, full load of bonus for 800 yuan, 600 yuan bonus for lack of workload 3. by using the formula to calculate the value of real wages, the formula is real wages for the basic salary plus bonus, minus the housing fund and insurance 4. disk name The first data point bonus D4- insert function - choose if function - value_if_true 800 value_if_false 600 H4=40 logical_test =IF (H4 to determine the display (Note: H4 is the first case workload data) - click D4 appears in the lower right corner + fill handle down D19 (note D19 bonus data last one) - points pay the first G4=C4+D4-E4-F4 (C4 D4 E4 F4 basic salary bonus housing fund premium data first) Note (if the condition is the Chinese wo