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: Microsoft® Excel

Poslovni excel
Microsoft® Excel is a spreadsheet computer program (so-called spreadsheet program) from Microsoft. It is one of the most common programs of its kind for personal needs as well as business use.

Kako uporediti dve tabele u Excelu

How to compare two tables in Excel

Saturday May 6th, 2023 admin Calculation, Microsoft® Excel, Advanced Excel

Sorry, this entry is only available in Srpski.

Continue reading

(Srpski) Kako sprovesti procenu rizika u Excelu

Tuesday February 14th, 2023 admin Calculation, Advanced Excel

Sorry, this entry is only available in Srpski.

Continue reading
Dashboard - početničke greške

Excel Dashboards Tutorial & Templates

Thursday December 1st, 2022 admin Dashboard - command desk, Calculation, Microsoft® Excel

EXCEL (DASHBOARD) CONTROL PANEL INSTRUCTIONS AND SAMPLE FILES The Excel (Dashboard) control panel allows you to see all important parameters

Continue reading
Editovanje PDF datoteke

EDITING PDF FILES

Saturday November 19th, 2022 admin Excel

Editing PDF files involves changing text, images, arranging content, deleting and extracting pages, converting to Word, Excel or another format. The

Continue reading

LOADING/DRAG DATA FROM CSV TO EXCEL

Monday November 14th, 2022 admin Excel

Loading/drag data from CSV to Excel file is the same as TXT format wizard when we use delimiter to separate

Continue reading
Power Query

Why Do We Need Power Query? – History of Power Query

Monday October 31st, 2022 admin Power Excel,

History of Power Query in Excel Versions:  2010, 2013, 2016, 2019, 2021, 365, for Mac  and for  web Until 2010, there was a clear

Continue reading
COUNTIF funkcija u Excelu

How to use the COUNTIF function in Excel

Sunday August 28th, 2022 admin Excel

Excel COUNTIF formula Appears from version: 5.0 One of the most important versions of Excel is version 5.0 from 1994, when, in

Continue reading
KOJA JE RAZLIKA IZMEĐU SORT I SORTBY FUNKCIJE U EXCEL-U

What is the difference between SORT and SORTBY function in Excel

Thursday June 30th, 2022 admin Microsoft® Excel, Advanced Excel

As of version 2021, new SORT and SORTBY functions have been added in Excel that sort the data in the

Continue reading
Kako napraviti novu funkciju upotrebom lambda

How to create new function in Excel with LAMBDA

Thursday June 23rd, 2022 admin Microsoft® Excel, Advanced Excel

Creating a function in Excel using the LAMBDA function, allows the user to create their own function without knowledge of

Continue reading
Nivelacija cena u excelu

Price leveling in Excel

Tuesday June 21st, 2022 admin Calculation, Microsoft® Excel, Advanced Excel

Price leveling is a procedure by which the price of a stock of goods in a wholesale (warehouse) or retail

Continue reading

Posts pagination

«Previous Posts 1 2 3 4 5 6 … 10 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

Funkcija SUBTOTAL će dati sledeći rezultat?

2 / 10

Funkcija MAX daje sledeći rezultat?

3 / 10

Funkcija AVERAGE daje sledeći rezultat?

4 / 10

Funkcija ROUND će dati sledeći rezultat?

5 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A1-B2

6 / 10

Dijagram prikazan na slici je poznat pod nazivom:

7 / 10

Funkcija SUM će dati sledeći rezultat?

8 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A2*B1

9 / 10

Funkcija COUNT će dati sledeći rezultat?

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