Skip to content

Calculation in essence of everything!

Go ahead! Improve your data processing skills!

  • Srpski
  • English
  • Calculation
    • Cost calculation form in Excel – CoGS
    • Price leveling in Excel
    • How to Create an Inventory List in Excel
    • DOWNLOADING DAILY BANK STATEMENTS
  • Microsoft® Excel
    • Excel
      • Tips for excel
    • Advanced Excel
      • Tips for excel
    • Power Excel
      • PowerPivot
      • #40 (no title)
      • PowerBI
      • VBA Macro II
      • Dashboard – command desk
  • excel tests for job
    • Provera znanja Excel-a
  • Google Sheets®
  • WEB admin
    • SEO – search engine optimization
    • Plugin for wordpress
    • Installations
  • Newsletter
  • Suggestions
  • Language: English
    • Srpski Srpski
    • English English

Category: Excel

(Srpski)

Poslovni excel
Poslovni excel ima osnovni nivo namenjen onima koji su početnici, kako bi prešni na savladavanje srednjeg nivoa rada sa excel aplikacijom.

(Srpski) Proverite vaše znanje rada u ekselu

Sunday June 20th, 2021 admin Excel

Sorry, this entry is only available in Srpski.

Continue reading
freeze panels

Freeze columns and rows

Wednesday October 23rd, 2019 admin Excel

Column names are almost always found in the upper cells, so if the table is large, and we are at

Continue reading

Excel Automatic calculation

Wednesday March 21st, 2018 admin Excel

Calculate now On the Formulas toolbar, there are options for setting the calculation method. Here we can also indicate the

Continue reading

Slicers

Monday February 19th, 2018 admin Excel

Slicers Slicers make filtering data in PivotTables even easier. Slicers are basically just filters, but they’re easier and faster to

Continue reading

Variables in Excel

Saturday January 27th, 2018 admin Tips for excel, Tips for excel

By introducing a variable name that replaces one to n cells of the table, Microsoft has made it possible, when

Continue reading

Problem with Excel and how to solve!

Sunday December 17th, 2017 admin Advanced Excel, Excel

Each version of Excel gets new functionality, but you can have a problem with Excel. In order to avoid application

Continue reading

SUCCESS Diagrams in Excel or ZEBRA BI

Sunday November 26th, 2017 admin Dashboard - command desk, Advanced Excel, Excel, Power Excel, Tips for excel

SUCCESS Diagrams are the fourth generation of graphical data display in the excel. Although simplicity and minimalism in the presentation

Continue reading

(Srpski) Excel funkcija EXACT

Wednesday October 25th, 2017 admin Advanced Excel, Excel, Tips for excel, Tips for excel

EXACT function The Excel EXACT function returns TRUE or FALSE as a result after comparing two strings. It has been

Continue reading

Advanced Filter

Monday October 16th, 2017 admin Advanced Excel, Excel, Tips for excel, Tips for excel

Advanced filter allows you to extract (display) only those data that meet some criteria. Filter and Advanced filter are basic

Continue reading

Excel function DATEDIF

Tuesday September 26th, 2017 admin Excel, Tips for excel

Excel function DATEDIF Calculates the number of days, months or years between two dates. Warning: The DATEDIF function may calculate

Continue reading

Posts pagination

«Previous Posts 1 … 3 4 5 6 7 Next Posts»

SVE OBJAVLJENO NA SAJTU

Prijavite se za obaveštenja

  • Revolucija u Računovodstvu: Kako Veštačka Inteligencija Postaje Čuvar Vaših Excel Tabela
  • AI i Platni Spisak: Revolucija u Prognoziranju Troškova ili Pretnja za Računovođe?
  • AI Revolucija u Računovodstvu: Kako Pametna Kalkulacija Zaliha i Obrtnog Kapitala Menja Poslovanje
  • Excel na Steroidima: Kako AI Menja Predviđanje Prihoda za Računovođe
  • Kalkulacija Budućnosti: Kako veštačka inteligencija menja računovodstvenu profesiju
  • AI Revolucija u Excelu: Da li je Posao Računovođe Ugrožen ili Pred Zlatnim Dobom?
  • Copilot u Knjigama: Kako Veštačka Inteligencija Menja Posao Računovođe
  • AI u Računovodstvu: Kraj Jedne Ere ili Zora Novih Mogućnosti?
  • Veštačka Inteligencija i Upravljanje Portfoliom: Kako AI Menja Investicionu Analizu u Excelu
  • Veštačka Inteligencija u Računovodstvu 2026: Kraj Profesije ili Početak Nove Ere?

0%
9 votes, 4.8 avg
2271

Za rešavanje testa imate 10 minutes vremena.

Hvala.


Created on June 20, 2021

Testiranje osnovnog znanja EXCEL-a

Sada imate priliku da odgovorima na jednostavnu anketu, utvrdite da li imate osnovno znanje i da li za taj nivo znanja vam je potrebna obuka.

1 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A$1/B1

2 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A2*B1

3 / 10

Funkcija COUNT će dati sledeći rezultat?

4 / 10

Funkcija AVERAGE daje sledeći rezultat?

5 / 10

Funkcija MAX daje sledeći rezultat?

6 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A1-B2

7 / 10

Funkcija SUBTOTAL će dati sledeći rezultat?

8 / 10

Funkcija ROUND će dati sledeći rezultat?

9 / 10

Ako je:                A1=5                 B1=5

Koji se rezultat dobija?

C1=$A$1+B1

10 / 10

Funkcija COUNTA vraća rezultat?

Popunite prazna polja

Your score is

The average score is 33%

LinkedIn Facebook VKontakte
0%

Ocenite ovaj test.

© 2016 - 2026 Kalkulacija.com