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

计算机应用基础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