USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chekiriniki  ››  Mirayiridzo yechirongwa chekurapa  ›› 

Shandisa chati yekuona

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Apa tadzidza shandura font kuti iite conditional formatting. Uye zvakambochinja cell background kuratidza vatengi vanobhadhara zvakanyanya.

Embed Chart

Zvino ngatiedzei kushandisa chati kuona kukosha mutafura kwakasiyana. Kuti aite izvi, mune module "Varwere" for column "Zvose zvakashandiswa" pachinzvimbo chekushandura ruvara rwesero, ngatiedzei kumisa chati yese. Kuti tiite izvi, tinoenda kumurairo watinotoziva "Conditional Formatting" .

Ndapota verenga kuti nei usingazokwanisi kuverenga mirairo yakafanana uye kushanda pahwindo rinoonekwa.

Simbisa iyo ' Ruvara chiyero ' mutemo uye tinya pane ' Rongedza ' bhatani.

Sarudza iyo yakakosha mhedzisiro inonzi ' Fomati ese maseru zvichienderana nehunhu hwavo kuburikidza nedata panhi .

Paunoshandisa izvi zvakakosha, chati yakazara ichaonekwa muchikamu chakasarudzwa, icho chicharatidza kuti mutengi wega wega akasiya mari mukiriniki yako kupfuura vamwe varwere.

Kurebesa bhawa rechati, ndiko kunyanya kukosha kwemutengi kukiriniki.

Mavara akasiyana echati

Zvinokwanisika kushandura chimiro chechati.

Kwete chete iwe unogona kushandura ruvara rwechati, asi iwe unogona zvakare kugovera rakasiyana ruvara rwehutsika husina kunaka.

Muchiitiko chedu, avo varwere avo kiriniki yakadzorera mari yakawanda kupfuura yavakatora sekubhadhara kwemabasa vacharatidzwa mune rumwe ruvara. Semuenzaniso, izvi zvinogona kunge zviri apo mari yakabhadharwa yekukuvadza yakakura kudarika mutengo wesevhisi pachayo.

Value Rating

Verenga nezve Rongedza tsika .

Ona pazasi mamwe misoro inobatsira:

• Rongedza tsika
• Simbisa Zvinhu Zvinokosha
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana