Yuav Ua Li Cas Hloov Hauv Google Cov Ntawv ntawm PC lossis Mac: 7 Kauj Ruam

Cov txheej txheem:

Yuav Ua Li Cas Hloov Hauv Google Cov Ntawv ntawm PC lossis Mac: 7 Kauj Ruam
Yuav Ua Li Cas Hloov Hauv Google Cov Ntawv ntawm PC lossis Mac: 7 Kauj Ruam

Video: Yuav Ua Li Cas Hloov Hauv Google Cov Ntawv ntawm PC lossis Mac: 7 Kauj Ruam

Video: Yuav Ua Li Cas Hloov Hauv Google Cov Ntawv ntawm PC lossis Mac: 7 Kauj Ruam
Video: Lig Pob tsuas xyooj nkauj tawm tshiab 2022-2023 2024, Tej zaum
Anonim

Qhov wikiHow qhia koj li cas rub cov ntaub ntawv lej los ntawm xovtooj ntawm Google Sheets spreadsheet, thiab hloov nws mus rau txhua tus lej ntawm cov lej, siv lub desktop internet browser.

Cov kauj ruam

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 1
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 1

Kauj Ruam 1. Qhib Google Ntawv hauv koj lub browser internet

Ntaus sheet.google.com rau hauv koj tus browser qhov chaw nyob bar, thiab ntaus ↵ Enter lossis ⏎ Return ntawm koj cov keyboard.

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 2
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 2

Kauj Ruam 2. Nyem rau kab ntawv uas koj xav kho

Nrhiav daim ntawv nthuav qhia koj xav saib hauv cov npe ntawm koj cov ntaub ntawv khaws tseg, thiab qhib nws.

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 3
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 3

Kauj Ruam 3. Nyem rau ntawm tes tsis muaj dab tsi hauv daim ntawv nthuav qhia

Koj tuaj yeem siv ib lub xovtooj uas tsis muaj dab tsi los ntxig rau cov lej sib npaug rau koj cov ntaub ntawv.

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 4
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 4

Kauj Ruam 4. Hom = ROUNDUP (cell, decimals) mus rau hauv lub cell khoob

Cov mis no tso cai rau koj rub cov ntaub ntawv zauv los ntawm lwm lub xovtooj, thiab hloov nws mus rau ib qho ntawm cov lej zauv.

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 5
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 5

Kauj Ruam 5. Hloov cov cell hauv cov qauv nrog cov cell uas koj xav kom hloov pauv

Rho tawm "cell" hauv cov qauv, thiab ntaus tus lej ntawm lub xovtooj uas koj xav kom ua ke.

Piv txwv li, yog tias koj xav sau cov ntaub ntawv hauv cell A2, hloov "cell" nrog "A2" hauv cov qauv

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 6
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 6

Kauj Ruam 6. Hloov cov zauv zauv nrog cov lej ntawm cov lej uas koj xav tau

Rho tawm "decimals" hauv tus lej, thiab ntaus cov zauv zauv uas koj xav tau los ua ke.

Piv txwv li, yog tias koj xav hloov cov ntaub ntawv hauv xov tooj ntawm tes A2 mus rau ob qhov chaw zauv, koj cov mis yuav zoo li = ROUNDUP (A2, 2)

Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 7
Hloov pauv ntawm Google Cov Ntawv ntawm PC lossis Mac Kauj Ruam 7

Kauj Ruam 7. Ntaus ↵ Enter los yog ⏎ Rov qab los ntawm koj cov keyboard.

Qhov no yuav rub cov lej cov ntaub ntawv los ntawm lub xovtooj ntawm tes, thiab hloov nws mus txog tus lej ntawm cov zauv hauv cov qauv.

Pom zoo: