Cov txheej txheem:

Dab tsi yog ob lub tswv yim cov ntaub ntawv?
Dab tsi yog ob lub tswv yim cov ntaub ntawv?

Video: Dab tsi yog ob lub tswv yim cov ntaub ntawv?

Video: Dab tsi yog ob lub tswv yim cov ntaub ntawv?
Video: Hmong New Song 2020-2021 Xyoob Quav Yeeb Nquab Tsab 2024, Kaum ib hlis
Anonim

Xav paub ntxiv. Thaum koj tsim ib ob - input rooj , koj qhia nkag cell hauv kab Tswv yim Cell thiab Kem Tswv yim Cell boxes nyob rau hauv Rooj dialog box. Hauv Microsoft Office Excel 2007, lub Rooj dialog box hu ua Cov ntaub ntawv dialog box.

Ib sab ntawm no, dab tsi yog ob lub rooj sib txawv ntawm cov ntaub ntawv?

A ob - cov ntaub ntawv sib txawv siv tus qauv uas muaj ob cov npe ntawm cov nqi nkag. Cov qauv yuav tsum xa mus rau ob sib txawv input cells. Hauv ib lub xovtooj ntawm daim ntawv ua haujlwm, nkag mus rau cov qauv uas hais txog qhov ob input cell.

Tsis tas li ntawd, qhov sib txawv ntawm ib thiab ob lub rooj sib txawv ntawm cov ntaub ntawv yog dab tsi? A ib - cov ntaub ntawv sib txawv yog a cov ntaub ntawv nrog ib leeg kab los yog kab ntawm input qhov tseem ceeb thiab ntau yam tshwm sim. A ob - cov ntaub ntawv sib txawv yog a cov ntaub ntawv nrog ob input nqi thiab a ib leeg tshwm sim.

Ib yam li ntawd, koj ua li cas thiaj tsim tau 2 cov ntaub ntawv tawm tswv yim?

Txhawm rau tsim ib lub rooj yooj yim ob lub tswv yim, ua raws li cov kauj ruam no:

  1. Tsim ib phau ntawv ua haujlwm tshiab.
  2. Hauv hlwb B15:B19, ntaus cov ntaub ntawv hauv qab no: Cell.
  3. Hauv cell C14: G14, ntaus cov ntaub ntawv hauv qab no: Cell.
  4. Hauv cell B14, ntaus cov qauv hauv qab no: = A14 * 2 + A15.
  5. Xaiv B14: G19.
  6. Hauv cov ntawv qhia zaub mov, nyem Table.
  7. Nyob rau hauv kab input Cell box, ntaus A15.
  8. Nyem OK.

Yuav ua li cas koj tsim ob lub rooj sib txawv cov ntaub ntawv hauv Excel 2016?

Yuav Ua Li Cas Tsim Ob Lub Rooj Sib Tham Cov Ntaub Ntawv hauv Excel 2016

  1. Xaiv lub xov tooj ntawm tes B7: H24.
  2. Nyem Cov ntaub ntawv → Yuav ua li cas-Yog Kev Ntsuam Xyuas → Cov Ntaub Ntawv ntawm Ribbon.
  3. Nyem ntawm tes B4 kom nkag mus rau qhov chaw nyob ntawm tes, $B$4, hauv kab ntawv nkag hauv kab ntawv.
  4. Nyem rau ntawm kab ntawv hauv kab ntawv hauv kab ntawv thiab tom qab ntawd nyem lub xov tooj B3 kom nkag mus rau qhov chaw nyob ntawm tes, $B$3, hauv lub thawv ntawv no.

Pom zoo: