???? ???????: 2551525 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

?????? ??? ???? ????? ????? ????? ?????? ?????? ????????? ?????? ???? ???? ????? ??? ????? ??? ??????? ?? ????? ?????? ?? ???? Excel ?? ????? ??????? ?? ???????á??? ????? ?????? ?? Microsoft Excel 2010 ?Microsoft Excel Services 2010 ?Microsoft Excel Online 2010.

???????? ??? ???? ??? ????? ????? ??? ?????? ???? ??? ??????? ????? ????? ???? ???? ?????? (???????? ??????????? ?????????? ?????????? ?????????? ??????????? ??????????? - ????????? ?????????? ????????? ????????). ????? ?? ??? ???? ????? #NAME? ??? ????? ??? ???? Microsoft Excel 2007 ???????? ????? ?? ??? ?????? ???????? ?? Excel 2010. ???? ??? ???? ?? Excel 2010 ?? Excel Services 2010 ?? Excel Online ???? ????? ??? ????? ???? ?? ??????? ????? ?? Excel? ???? ??? ?????? ????????.

???? ??????? ???????? ???? ???? Microsoft ????? ??? ?????? ???? ??? ??????? ????? ????? ??? ??????? ???????? ?????? ?????? Excel 2007. ??????? ????? ?????? ??? ????? ????? 2007? ?? ?????? Microsoft Office 2010 Service Pack 1.

????

???? ??? ?????? VLOOKUP ?????????? ????? BUSCARV ?? Excel 2007. ??? ????? ?? ???? ?? ????? ????? ???????? ?? Excel 2010 ??? CONSULTAV. ??? ??? ?????? BUSCARV ????? ?? CONSULTAV ?? Excel 2010 ??? SP1? ??????? ??? #NAME?.

?????? ????? ??? ??????? ???? ??? ??????? ?? ??????? ???????? ?? Excel 2010:
  1. ?? ?????? ???? Excel ????.
  2. ???? 1 ?? ?????? A1? ?? ???? 2 ?? ?????? A2.
  3. ???? a ?? ?????? B1? ?? ???? b ?? ?????? B2.
  4. ???? 1 ?? ?????? D1? ?? ?? ?????? D2? ???? =BUSCARV(D1,A1:B2,2).
?? ???? ??? ????? Service Pack 1? ?????? ????? #┐NOMBRE? ??? ????? =BUSCARV(D1,A1:B2,2) ?? Excel 2010. ?????? ??????? ???? ??? ??????? ?? ????? Excel 2010 ??? ?????? ???? SP1 ?? =CONSULTAV(D1,A1:B2,2).

??? ????? ?? ???? ??? ????? Service Pack 1? ?????? ????? #┐NOMBRE? ??? ????? =CONSULTAV(D1,A1:B2,2) ?? Excel 2010. ?????? ??????? ???? ??? ??????? ?? ????? Excel 2010 ???? ???? SP1 ?? =BUSCARV(D1,A1:B2,2).




??????? ????

??? ????? Service Pack 1? ???? ???? ???????? ???? ?? ??????? ?? ??????? ????? ?? Excel ??? ?? ??? ?????? Excel 2010 ??? ?????? ???? SP1 ???? ????? ?????? ????????? ????????. ?? ???? ????? ????? ?????? ??? ???? ??????? ????????.

?????? Office 2010 SP1 ???????? ?? ?????? ????? "????? ????? Microsoft" ???????:

2460049 - ??? Office 2010 SP1


??????? ?????? ????????? ???? ????? ?? ????? ?? ?????? "????? ????? Microsoft" ??? ?? ?????? ????? ?????? ?????? ??:

2460043 - ??? Office 2010 Language Pack SP1
2460073 - ??? Office Online SP1
2460056 - ??? Office Servers 2010 Language Pack SP1
2460044 - ??? Office Language Interface Pack 2010 SP1
2460045 - ??? SharePoint Server 2010 SP1
2460047 - ??? Project Server 2010 SP1

????? ?????? ???????

???? ????? ?????? ?????? ??????? ???? ?? ??????? ?????? Service Pack 1.

????????
???? ?????? ?????? ???? ???? ????? ???????? ???? ?? ??????? ?? Service Pack 1:

?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
IFERRORCHYBHODNIFERROR
LEFTVLEVOZLEVA
NOTNEN═NE
RIGHTVPRAVOZPRAVA
TEXTTEXTHODNOTA.NA.TEXT


??????????
???? ?????? ?????? ???? ???? ????? ?????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
AVERAGEGENNEMSNITMIDDEL
AVERAGEIFGENNEMSNIT.HVISMIDDEL.HVIS
AVERAGEIFSGENNEMSNIT.HVISSMIDDEL.HVISER
COUNTIFSTĂL.HVISSTĂL.HVISER
CUBEKPIMEMBERKUBEKPIMEDLEMKUBE.KPI.MEDLEM
CUBEMEMBERPROPERTYKUBEMEDLEMSEGENSKABKUBEMEDLEM.EGENSKAB
CUBERANKEDMEMBERKUBERANGERETMEDLEMKUBERANGERET.MEDLEM
CUBESETKUBE.ANGIVKUBESĂT
CUBESETCOUNTKUBE.ANGIV.ANTALKUBESĂT.ANTAL
DAVERAGEDGENNEMSNITDMIDDEL
DOLLARVALUTAKR
FLOORGULVAFRUND.GULV
GCDFĂLLES.DIVISORSTěRSTE.FĂLLES.DIVISOR
HYPERLINKLINKHYPERLINK
IFERRORHVISFEJLHVIS.FEJL
INTHELHELTAL
ISERRER.FEER.FJL
LOOKUPOPSLAGSL┼.OP
MODETILSTANDHYPPIGST
NNTAL
OCT2DECOCT.TIL.DECOKT.TIL.DEC
RECEIVEDMODTAGETMODTAGET.VED.UDLěB
RIGHTBHěJRE_BHěJREB
SUMIFSSUM.HVISSSUM.HVISER

???? ?????? ?????? ???? ???? ??????? ?????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
RESET.TOOLBARNULSTIL.VĂRKTěJSLINJEGENDAN.VĂRKTěJSLINJE
TEXT.BOXTEKSTFELTTEKSTBOKS

?????????
???? ?????? ?????? ???? ???? ????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
CHOOSEKIESKIEZEN
CLEANSCHOONWISSEN.CONTROL
DAVERAGEDGEMIDDELDEDBGEMIDDELDE
DAYS360D360DAGEN360
DCOUNTDAANTALDBAANTAL
DGETDHAALDBLEZEN
DOLLARVALUTAEURO
DSTDEVDSTDEVDBSTDEV
DSUMDSOMDBSOM
FINDVINDEN.ALLESVIND.ALLES
LOOKUPOPZOEKENZOEKEN
LOWERKLEINELETTKLEINE.LETTERS
MIDMIDDENDEEL
NPVHNWNHW
PMTAFLOSSINGBET
PROPERBEGINKAPBEGINLETTERS
REPLACEVERVANGVERVANGEN
ROUNDAFRONDINGAFRONDEN
SLNRAALIN.AFSCHR
SQRTVWORTELWORTEL
UPPERHOOFDLETTHOOFDLETTERS
VALUEGETALWAARDE
VDBVAPVDB

???? ?????? ?????? ???? ???? ??????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
BREAKEINDEONDERBREKEN
FORVOORVAN
GOTOGANAARGA.NAAR
GROUPGROEPGROEPEREN
NOTEOPMERKINGNOTITIE
RESTARTOPNIEUWOPNIEUW.STARTEN

?????????
???? ?????? ?????? ???? ???? ????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
FINDRICERTROVA
MINUTEMINUTIMINUTO
SECONDSECONDISECONDO


?????????
???? ?????? ?????? ???? ???? ????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
CHARTEGNTEGNKODE
CLEANRYDDRENSK
IPMTRANNUITETRAVDRAG
ISPMTER.ANNUITETER.AVDRAG
MAXMAKSSTěRST
PMTANNUITETAVDRAG

???? ?????? ?????? ???? ???? ??????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
NEXTNEXTNESTE

??????????
???? ?????? ?????? ???? ???? ????? ?????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
FIXEDFIXOFIXA
NANDN├O.DISP
USDOLLARMOEDA2MOEDA.EUA

?????????? - ????????
???? ?????? ?????? ???? ???? ????? ?????????? - ???????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
COLUMNCOLUNACOL
FACTFATOFATORIAL
FIXEDFIXODEF.N┌M.DEC
FREQUENCYFREQU╩NCIAFREQ▄╩NCIA
MINM═NM═NIMO
PRODUCTPRODUTOMULT
RECEIVEDRECEBIDORECEBER
SEARCHPESQUISARLOCALIZAR
SERIESSUMSOMAS╔RIESOMASEQ▄╩NCIA
STDEVDESVPAD.NDESVPAD
TRUNCTRUNCTRUNCAR
VARVARESTVAR

???? ?????? ?????? ???? ???? ??????? ?????????? - ???????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
DATE.STRINGCADEIA.DATADATA.S╔RIE
ENABLE.COMMANDHABILITAR.COMANDOATIVAR.COMANDO
ENABLE.TOOLHABILITAR.FERRAMENTAATIVAR.FERRAMENTA
EXECUTEEXECUTAREXECUTE
FCLOSEARQ.FECHARARQN.FECHAR
GET.WORKSPACEINFO.ESPAăO.TRABALHOINFO.┴REA.TRABALHO
LINKSLINKSV═NCULOS
NUMBER.STRINGCADEIA.N┌MEROSEQ▄╩NCIA.N┌MERO
REGISTERREGISTRARREGISTRO
RESUMECONINTUARREINIC

?????????
???? ?????? ?????? ???? ???? ????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
CHARCARCARACTER
CONVERTCONVERTCONVERTIR
DATEVALUEVALFECHAFECHANUMERO
DAYS360D═AS360DIAS360
DCOUNTBDCUENTABDCONTAR
HLOOKUPCONSULTAHBUSCARH
IFERRORSIERRORSI.ERROR
MIDMEDEXTRAE
MODRESTORESIDUO
MODEMODOMODA
NANDNOD
SQRTRCUADRAIZ
TBILLEQLETRA.DE.TES.EQV.A.BONOLETRA.DE.TEST.EQV.A.BONO
TIMETIEMPONSHORA
TIMEVALUEVALHORAHORANUMERO
TRIMRECORTARESPACIOS
VLOOKUPCONSULTAVBUSCARV

???? ?????? ?????? ???? ???? ??????? ????????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
GOTOIRIR.A
NEXTSIGUIENTESALIR.BUCLE
RETURNDEVOLVERVOLVER

????????
???? ?????? ?????? ???? ???? ????? ???????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
CLEANRENSAST─DA
DAYS360D360DAGAR360
DDBDFAVDEGAVSKR
FALSEFALSKFALSKT
HLOOKUPHTSÍKLETAKOLUMN
HOURTIMTIMME
ISNA─RET─RSAKNAD
ISNUMBER─RNUM─RTAL
ISTHAIDIGIT?RTHAISIFFRAISTHAIDIGIT
LEFTV─NSTERPILV─NSTER
LOWERSM┼GEMENER
MIDMITTEXTEXT
MODEL─GETYPV─RDE
NIN
NAETSAKNAS
NPVNVLFNETNUV─RDE
PMTAVBETBETALNING
PVNVNUV─RDE
RATEPRSR─NTA
RIGHTHÍGERPILHÍGER
SLNLNALINAVSKR
SYD┼ATP┼RSAVSKR
TRIMST─DARENSA
TRUESANNSANT
UPPERSTORAVERSALER
VLOOKUPVTSÍKLETARAD

???????
???? ?????? ?????? ???? ???? ????? ??????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
SUMTOPLAMTOPLA

???? ?????? ?????? ???? ???? ??????? ??????? ???? ?? ??????? ?? Service Pack 1:
?? ??? ??????????? ??? ??????
???? ??????? 2010 ???????????Excel 2010Excel 2010 SP1
GET.movIEAL.FILMGET.movIE
MOVIE.COMMANDFILM.KOMUTMOVIE.COMMAND






?????? ??? ????? ?? ????? "????? ??????" ?? ??????? ??????? ?? ???? ????? ????? ?????? ?? Microsoft. ??? ????? ????????? ??????? ??? ????????? ???????? ???????. ??????? ????????? ?? ????? ??? ???????? ??? ????? ?????? ??????? ??? ??? ??? ??????? ???????? ??? ??? ???????? ?? ?? ??? ???? ????? ????. ???? ???? ????????? ?????? ?????????? ??????.

???????

???? ???????: 2551525 - ????? ??? ??????: 17/?????á???????/1435 - ??????: 3.1
????? ???
  • Microsoft Excel 2010
????? ??????:á
KB2551525

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com