際際滷

際際滷Share a Scribd company logo
Formatiranje tabele
Komanda
Format/Cells
Pod pojmom formatiranje tabele podrazumevamo pode邸avanje
njenog izgleda-vrste i veliine slova,poravnanja,veliine elija,njihove
boje ,okvira....
 Za razliku od ostalih programa u Excel-u se formatiranje vezuje za
eliju, bez obzira na to da li je prazna ili sadr転i neke podatke.
 To znai da jednom zadato formatiranje elije ne mo転emo poni邸titi
prostim brisanjem njenog sadr転aja,ve za to moramo upotrebiti
posebnu komandu (Edit/Clear/Formats)
Komanda Format/Cells
(mogue je aktivirati desnim klikom tastera na mi邸u kada je oznaena
elija kojoj 転elimo definisati format)
Prva od kartica (Number) omoguava nam da sami izaberemo
kako e sadr転aj elije biti tumaen i prikazan,umesto da tu odluku
ostavimo Excel-u
U levom delu kartice nalazi se spisak koji sadr転i sve vrste podataka
koje nam u Excel-u stoje na raspolaganju,dok desni deo kartice
sadr転i dodatne opcije za pode邸avanje njegovog prikaza
 GENERAL je podrazumevana opcija i znai da e Excel poku邸ati da
sam prepozna kojoj kategoriji pripada uneti podatak
 NUMBER znai da e uneti podaci biti prikazani kao brojevi sa
fiksnim brojem decimala
Ako radimo sa velikim brojevima,opcijom Use 1000 Separator
mozemo izvrsiti grupisanje po 3 cifre
Mozemo izabrati da negativni brojevi budu obelezeni crvenom
bojom i da naglasimo da ispred njih stoji minus
 CURRENCY (valuta) i ACCOUNTING (knjigovodstveno) se koriste
za prikaz novanih vrednosti
U oba sluaja mo転emo izabrati broj decimalnih mesta i oznaku
valute.(Razlika je u tome 邸to ako odaberemo kategoriju Currency,
mo転emo odabrati i nain prikaza negativnih brojeva,dok u sluaju
kategorije Accounting, Excel negativne brojeve prikazuje na nain
pode邸en u Control panel-u
 DATE (datum) i TIME (vreme)se delimino preklapaju i
omoguavaju nam da datum i vreme prika転emo na dosta razliitih
naina
 PERCENTAGE znai da e brojevi biti prikazani kao procenti
(1=100%),a jedino mo転emo odabrati koliko decimalnih mesta 転elimo
da prika転emo
 FRACTION slu転i za predstavljanje brojeva u vidu razlomaka
Mo転emo zadati da imenilac ima 1,2 ili 3 cifre ili da nam bude
prikazana pribli転na vrednost tako da imenilac bude 2,4,8,16,10 ili
100
 SCIENTIFIC (eksponencijalni format) se koristi kao prikaz jako
velikih i jako malih brojeva
(1,125E+06 se ita kao 1,125 puta 106 tj milion sto dvadeset pet
hiljada ili 0,0003 kao 3E-04 tri puta 10-4)
 TEXT znai da Excel ne treba ni da poku邸ava da prepozna unetu
vrednost ve da je prika転e tano kako je uneta.
Ako unos sadr転aja elije zaponemo apostrofom, Excel e njen
sadr転aj uvek tretirati kao text.
 SPECIAL sadr転i formatiranja vezana za amerike po邸tanske i
matine brojeve
 CUSTOM nam omoguava da defini邸emo neki specifian format za
prikaz brojeva (npr. temperatura 16属C)
Uraditi tabelu za ve転bu
Preice za pode邸avanje izgleda brojeva na Formating toolbaru
Currency
Perecent
Fixed
Add decimal places
Reduce decimal places
Zadaci za ve転bu
1 Resenje

More Related Content

Featured (20)

2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing
Search Engine Journal
Storytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design ProcessStorytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design Process
Chiara Aliotta
Artificial Intelligence, Data and Competition SCHREPEL June 2024 OECD dis...
Artificial Intelligence, Data and Competition  SCHREPEL  June 2024 OECD dis...Artificial Intelligence, Data and Competition  SCHREPEL  June 2024 OECD dis...
Artificial Intelligence, Data and Competition SCHREPEL June 2024 OECD dis...
OECD Directorate for Financial and Enterprise Affairs
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
SocialHRCamp
2024 State of Marketing Report by Hubspot
2024 State of Marketing Report  by Hubspot2024 State of Marketing Report  by Hubspot
2024 State of Marketing Report by Hubspot
Marius Sescu
Everything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPTEverything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPT
Expeed Software
Product Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage EngineeringsProduct Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage Engineerings
Pixeldarts
How Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental HealthHow Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental Health
ThinkNow
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdfAI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
marketingartwork
Skeleton Culture Code
Skeleton Culture CodeSkeleton Culture Code
Skeleton Culture Code
Skeleton Technologies
PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024
Neil Kimberley
Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)
contently
How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024
Albert Qian
Social Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie InsightsSocial Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie Insights
Kurio // The Social Media Age(ncy)
Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024
Search Engine Journal
5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary
SpeakerHub
ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd
Clark Boyd
Getting into the tech field. what next
Getting into the tech field. what next Getting into the tech field. what next
Getting into the tech field. what next
Tessa Mero
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search IntentGoogle's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Lily Ray
How to have difficult conversations
How to have difficult conversations How to have difficult conversations
How to have difficult conversations
Rajiv Jayarajah, MAppComm, ACC
2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing
Search Engine Journal
Storytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design ProcessStorytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design Process
Chiara Aliotta
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
SocialHRCamp
2024 State of Marketing Report by Hubspot
2024 State of Marketing Report  by Hubspot2024 State of Marketing Report  by Hubspot
2024 State of Marketing Report by Hubspot
Marius Sescu
Everything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPTEverything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPT
Expeed Software
Product Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage EngineeringsProduct Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage Engineerings
Pixeldarts
How Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental HealthHow Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental Health
ThinkNow
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdfAI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
marketingartwork
PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024
Neil Kimberley
Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)
contently
How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024
Albert Qian
Social Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie InsightsSocial Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie Insights
Kurio // The Social Media Age(ncy)
Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024
Search Engine Journal
5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary
SpeakerHub
ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd
Clark Boyd
Getting into the tech field. what next
Getting into the tech field. what next Getting into the tech field. what next
Getting into the tech field. what next
Tessa Mero
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search IntentGoogle's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Lily Ray

excel_2_formatiranje_celije2-cas.ppt

  • 2. Pod pojmom formatiranje tabele podrazumevamo pode邸avanje njenog izgleda-vrste i veliine slova,poravnanja,veliine elija,njihove boje ,okvira.... Za razliku od ostalih programa u Excel-u se formatiranje vezuje za eliju, bez obzira na to da li je prazna ili sadr転i neke podatke. To znai da jednom zadato formatiranje elije ne mo転emo poni邸titi prostim brisanjem njenog sadr転aja,ve za to moramo upotrebiti posebnu komandu (Edit/Clear/Formats) Komanda Format/Cells (mogue je aktivirati desnim klikom tastera na mi邸u kada je oznaena elija kojoj 転elimo definisati format)
  • 3. Prva od kartica (Number) omoguava nam da sami izaberemo kako e sadr転aj elije biti tumaen i prikazan,umesto da tu odluku ostavimo Excel-u U levom delu kartice nalazi se spisak koji sadr転i sve vrste podataka koje nam u Excel-u stoje na raspolaganju,dok desni deo kartice sadr転i dodatne opcije za pode邸avanje njegovog prikaza
  • 4. GENERAL je podrazumevana opcija i znai da e Excel poku邸ati da sam prepozna kojoj kategoriji pripada uneti podatak NUMBER znai da e uneti podaci biti prikazani kao brojevi sa fiksnim brojem decimala Ako radimo sa velikim brojevima,opcijom Use 1000 Separator mozemo izvrsiti grupisanje po 3 cifre Mozemo izabrati da negativni brojevi budu obelezeni crvenom bojom i da naglasimo da ispred njih stoji minus CURRENCY (valuta) i ACCOUNTING (knjigovodstveno) se koriste za prikaz novanih vrednosti U oba sluaja mo転emo izabrati broj decimalnih mesta i oznaku valute.(Razlika je u tome 邸to ako odaberemo kategoriju Currency, mo転emo odabrati i nain prikaza negativnih brojeva,dok u sluaju kategorije Accounting, Excel negativne brojeve prikazuje na nain pode邸en u Control panel-u
  • 5. DATE (datum) i TIME (vreme)se delimino preklapaju i omoguavaju nam da datum i vreme prika転emo na dosta razliitih naina PERCENTAGE znai da e brojevi biti prikazani kao procenti (1=100%),a jedino mo転emo odabrati koliko decimalnih mesta 転elimo da prika転emo FRACTION slu転i za predstavljanje brojeva u vidu razlomaka Mo転emo zadati da imenilac ima 1,2 ili 3 cifre ili da nam bude prikazana pribli転na vrednost tako da imenilac bude 2,4,8,16,10 ili 100 SCIENTIFIC (eksponencijalni format) se koristi kao prikaz jako velikih i jako malih brojeva (1,125E+06 se ita kao 1,125 puta 106 tj milion sto dvadeset pet hiljada ili 0,0003 kao 3E-04 tri puta 10-4) TEXT znai da Excel ne treba ni da poku邸ava da prepozna unetu vrednost ve da je prika転e tano kako je uneta. Ako unos sadr転aja elije zaponemo apostrofom, Excel e njen sadr転aj uvek tretirati kao text.
  • 6. SPECIAL sadr転i formatiranja vezana za amerike po邸tanske i matine brojeve CUSTOM nam omoguava da defini邸emo neki specifian format za prikaz brojeva (npr. temperatura 16属C) Uraditi tabelu za ve転bu
  • 7. Preice za pode邸avanje izgleda brojeva na Formating toolbaru Currency Perecent Fixed Add decimal places Reduce decimal places