Numbers中文教程

(/sign_in)(/users/vo7poY)scomper(/users/vo7poY)2014.09.1917:05*17482218902124NumbersNumbersExcelNumbersNumbersExcelNumbersNumbersOLENumbersNumbers30NumbersNumbersExcelNumbersNumbersExcelNumbers+32337231627!(/sign_up)#(/sign_in)$(/)(/collections)(/apps)!%NumbersiWorkNumbersB3B3B46B4:B6,$B$2B2B21::$B$21::1::$B$2NumbersExcelNumbersExcelNumbersNumbersExcelExcelNumbersNumbersExcelExcelNumbersNumbersNumbers1-5returnreturnshift+returnoption1000KB1000MBExcelNumbersExcelNumbers1234...1357...NumbersAppleNumbersExcel()NumbersWindowsExcelNumbers(/sign_in)¥+(/sign_in)(/users/vo7poY)scomper(/users/vo7poY)2014.09.2315:55*17482218902124NumbersPagesPagesKeynoteNumbersiWorkNumbersNumbersPagesiWorkNumbersPagesNumbersPagesNumbersNumbersNumbersIF+27682327110!(/sign_up)#(/sign_in)$(/)(/collections)(/apps)!%MIDMODIFnumbersMIDcommand+CMODMODreturnMODMID2MODIFExcelNumbersNumbersSUMIF(,,)SUMIFSUMIFCOUNTIF(,)SUMPRODUCT(,…)LOOKUPLOOKUPNumbers()ANDORANDORNumbersNumbersNumbersNumbers-(/sign_in)¥+♥10(*(/sign_in)(/users/vo7poY)scomper(/users/vo7poY)2014.09.2417:11*17482218902124NumbersNumbers=++35858325417!(/sign_up)#(/sign_in)$(/)(/collections)(/apps)!%=-01+3+3–3–1*3*3/3/3%20%^3^2=A1=B1A1B1A1B1=A1=B1=A1=B1A1B1&North&windNorthwindNumbersDATEDIFY&⌘C⌘V⇧⌘V$B2$B2C2+C3B2$$B$2B2:B71::B2:B7COUNTIF(,)COUNTIFCOUNTIF(::D1:D6,)COUNTIF-COUNTIFMID(,,)MIDMID&MID(,7,4)&-&MID(,11,2)&-&MID(,13,2)MID-186+4+2+2+2+1+1YEAR()YEAR/YEARNOW()TODAYMONTHTIMEYEAR(NOW())−MID(,7,4)YEAR-IF(,TRUE,FALSE)IFTRUEFALSETRUEFALSEIF(MOD(MID(,17,1),2)=1,,)IF-IFMODIF012IF0IFLOOKUP(,,)LOOKUP($A$1,::B1:M1,::B4:M4)LOOKUP-LOOKUP--LOOKUPLOOKUPLOOKUPSUMIF(,,)SUMIFNumbersSUMIFSUMIF(,TRUE,D2:D13)SUMIF-1SUMIFSUMIFNumbersSUMIF(,A2,$)SUMIF-2~ExcelNumbersNumbers()(/sign_in)¥+(/sign_in)(/users/vo7poY)scomper(/users/vo7poY)2014.09.2517:59*17482218902124NumbersNumbersNumbersCommand-NumbersNumbers--[phone]!(/sign_up)#(/sign_in)$(/)(/collections)(/apps)!%NumbersXXExcelExcel-NumbersNumbersExcelExcelNumbersNumbers-option+returncontrol+return⇧⌥⌘V,0--0100%9iPadNumbersNumbersforiOSMaciPadMaciPadiPadNumbersNumbersforiOSiOS8YosemiteiPhone5iCloudHandoffMacNumbersiPadHandoffMaciPadDockHandoffAppleSafariPagesNumbersKeynoteHandoffHandoffiPadMacMaciPadMaciPadiPadMaciPad(/sign_in)+