电子试算表

Excel„„Excel„„„Excel1.spreadsheetcolumnrowcell2.1960RichardMattessichVisiCalcVisibleCalculator1978DanBricklinmRobertFrankstonBasic1979VisiCalcVisiCalc1982MitchKaporLotusLotus1-2-3Lotus1-2-31985LotusVisiCalcVisiCalcLotus1-2-311985ExcelExcel1989Windows3.0ExcelPCExcelLotus1-2-3Lotus1995IBMExcelExcelExcel6.0Excel7.0Excel97Excel2000Excel2002Excel2002OfficeXPExcel20023.ExcelExcelMicrosoftExcelExcelworksheetExcelworkbookxlsExcel2Excel/Excel//MicrosoftExcelxls*.xls4.ExcelAIV256165536//////ExcelC1C13Ctrl:A1C3A1:C3EnterTabExcel4/21421//001/31/34C15=A1+B1=Excel=A1B1A1B1C15.C1=A1+B1C1C2=A1+B1=A2+B2//C1$C1=$A$1+$B$1A1B1$A1A$1C1=A$1+B1C2=A$1+B1=A$1+B25C1!Sheet2A1Sheet2!A16.ExcelA11A16//A1E12,4,8,16,327Excel//7.Excel8////8.EnterMicrosoftExcel9/MicrosoftExcelMicrosoftExcel109.ExcelExcel11F2/SUMB2:E2A2:E2A2:E212SUMF2=SUM(B2:E2)F234910.F213//14Excel///()()11.G2=F2/4AVERAGEB17=AVERAGE(B2:B16)15//ROUND6060/6016//176012.18RANKRANKRANK(number,ref,order)numberreforderorder0order0H2=RANK(F2,$F$2:$F$16,0)15331610310111213RANKRANK/19/202113.HLOOKUPSheet290908080707060600HLOOKUPHLOOKUP(lookup_value,table_array,row_index_num,range_lookup)lookup_valuetable_arrayrow_index_numrange_lookupTRUErange_lookupFALSEHLOOKUP22I2=HLOOKUP(G2,Sheet2!$A$2:$E$3,2)G2HLOOKUPSheet2$A$2:$E$387.380214.908090COUNTIFCOUNTIF(range,criteria)rangecriteriaB20=COUNTIF(B2:B16,=70)-COUNTIF(B2:B16,=80)B2:B1670807079COUNTIF2315.242526Y272816.(1)(2)Excel(3)/(4)(5)FREQUENCYMicrosoftExcelFREQUENCYFREQUENCYCOUNTIF(6)///(7)MicrosoftExcel(8)(9)(10)ExcelPowerPointExcel