利用excel表格搞定生物芯片数据

《利用excel表格搞定生物芯片数据》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Cellconventions1.Cellsarereferredtobytheircolumnletterandrownumber(ex:A2).2.Aseriesofcellsarereferredtobyshowingthestartingandendingcells,separatedbyacolon(ex:A2:A100).3.Whencellsarecopiedandpasted,thecolumnandrowareshiftedtoadjusttothepositionofthenewcell.Forexample,iftheformula"=B5"iscopiedandpast

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

3、.Youmayusetheprefix"$"beforethecolumnand/ortherow.5.Refertocell(s)inanotherworksheetbyprefixingthecellswiththesheetnameplus"!".Ex:"=data!B4"referstocellB4onaworksheetnamed"data".Forthisreasonit'sveryhelpfultonameworksheetswithshortbutinformativenames.6.Refertocell(s)inanotherfilebyprefixingthecellsw

4、iththefileinsquarebracketsandthesheetnameplus"!".Ex:"=[anotherFile.xls]data!B4"referstocellB4offile"anotherFile.xls"onaworksheetnamed"data".Copyingandpastingcells1.Copyingandpastingcellsusuallyhastheexpectedresult.Ifnot,checkyouruseof"$"(tofixalocation).2.Whencopyingandpastingdatageneratedbyaformula

5、,itmaybebest(topreventre-calculationsofdata)topastetheactualvalue,ratherthantheunderlyingformula.Todothis,copythecell(s)asusualbutthenselect"PasteSpecial>Values".Usingfunctions1.Excelcontainsareasonablerangeoffunctionswhichcanbeusedbyinoneofatleasttwoways:oTypetheformula(precededby"=")intheboxnextto

6、"fx"nearthetopofthewindow,alongwithalloftherequiredarguments(assumingyouknowwhattheseare).oSelect"Insert>Function"andthenchoosethefunctionyouwish.Selectacategorytogetapartialorcompletelistofallfunctions.Aboxentitled"FunctionArguments"willpopup,andyoucanfillintheemptyboxes.2.Atanytime,enteringthefunc

7、tionnameintothehelpboxorselecting"Helponthisfunction"usuallyprovidesabriefexplanationofthefunctionandsomeexamples.3.Ifyoumakeamistakewithafunction,youmightgetasuggestiontocorrectit.Ifyouagreetothecorr