利用EXCEL表格搞定生物芯片数据.doc

《利用EXCEL表格搞定生物芯片数据.doc》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、Cellconventions1.Cellsarereferredtobytheircolumnletterandrownumber(ex:A2).2.Aseriesofcellsarereferredtobyshowingthestartingandendingcells,separatedbyacolon(ex:A2:A100).3.Whencellsarecopiedandpasted,thecolumnandrowareshiftedtoadjusttothepositionofthenewcell.Forexample,ifthef

2、ormula"=B5"iscopiedandpastedonecelltotheright,theformulainthenewcellwillchangeto"=C5".4.Ifyouwishtomaintaintheposition(s)ofcell(s)inaformula,usetheprefix"$"tocreateanabsolutelinktocellsthatwon'tchangewithcopyinganpasting.Forexample,iftheformula"=$B$5"iscopiedandpastedonecel

3、ltotheright,theformulainthenewcellwillstillbe"=$B$5".Youmayusetheprefix"$"beforethecolumnand/ortherow.5.Refertocell(s)inanotherworksheetbyprefixingthecellswiththesheetnameplus"!".Ex:"=data!B4"referstocellB4onaworksheetnamed"data".Forthisreasonit'sveryhelpfultonameworksheets

4、withshortbutinformativenames.6.Refertocell(s)inanotherfilebyprefixingthecellswiththefileinsquarebracketsandthesheetnameplus"!".Ex:"=[anotherFile.xls]data!B4"referstocellB4offile"anotherFile.xls"onaworksheetnamed"data".Copyingandpastingcells1.Copyingandpastingcellsusuallyhas

5、theexpectedresult.Ifnot,checkyouruseof"$"(tofixalocation).2.Whencopyingandpastingdatageneratedbyaformula,itmaybebest(topreventre-calculationsofdata)topastetheactualvalue,ratherthantheunderlyingformula.Todothis,copythecell(s)asusualbutthenselect"PasteSpecial>Values".Usingfun

6、ctions1.Excelcontainsareasonablerangeoffunctionswhichcanbeusedbyinoneofatleasttwoways:oTypetheformula(precededby"=")intheboxnextto"fx"nearthetopofthewindow,alongwithalloftherequiredarguments(assumingyouknowwhattheseare).oSelect"Insert>Function"andthenchoosethefunctionyouwis

7、h.Selectacategorytogetapartialorcompletelistofallfunctions.Aboxentitled"FunctionArguments"willpopup,andyoucanfillintheemptyboxes.2.Atanytime,enteringthefunctionnameintothehelpboxorselecting"Helponthisfunction"usuallyprovidesabriefexplanationofthefunctionandsomeexamples.3.If

8、youmakeamistakewithafunction,youmightgetasuggestiontocorrectit.Ifyouagreetothecorr