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: PowerPivot

THE REAL POWER OF POWER PIVOT TABLES

Monday June 13th, 2022 admin Power Excel, PowerPivot

Power pivot (advanced derived) table includes the process of creating a report table very similar to the Pivot table , whose main

Continue reading
DAX formule u Power Pivot i Power BI

DAX formulas in Power Pivot and Power BI

Monday May 16th, 2022 admin Power Excel, PowerBI, PowerPivot,

DAX (Data Analysis Expressions)  is a language used to create expressions (formulas) to create reporting dimensions used in  PowerPivot  tables. The same terms can

Continue reading

DAX formulas: COUNTROWS & FILTER

Monday January 8th, 2018 admin Power Excel, PowerPivot

Aggregation (data aggregation) is what we implicitly do each time when we drag some sort of dimension into the Pivot

Continue reading

Data Model

Monday July 31st, 2017 admin Power Excel, PowerPivot

Sorry, this entry is only available in Srpski.

Continue reading

Install Power pivot Table

Thursday June 22nd, 2017 admin Power Excel, PowerPivot

Sorry, this entry is only available in Srpski.

Continue reading

SVE OBJAVLJENO NA SAJTU

Prijavite se za obaveštenja

  • Excel online training
  • History of adding Functions into Excel
  • Koje poslove ljudi rade u excelu?
  • How to compare two tables in Excel
  • (Srpski) Kako sprovesti procenu rizika u Excelu
  • Excel Dashboards Tutorial & Templates
  • EDITING PDF FILES
  • DOWNLOADING DAILY BANK STATEMENTS
  • LOADING/DRAG DATA FROM CSV TO EXCEL
  • Drag-load-import from TXT to Excel

0%
9 votes, 4.8 avg
2147

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=$A2*B1

2 / 10

Dijagram prikazan na slici je poznat pod nazivom:

3 / 10

Funkcija ROUND će dati sledeći rezultat?

4 / 10

Funkcija AVERAGE daje sledeći rezultat?

5 / 10

Funkcija SUBTOTAL će dati sledeći rezultat?

6 / 10

Ako je:                A1=5                 B1=5

Koji se rezultat dobija?

C1=$A$1+B1

7 / 10

Funkcija LEN("Beograd",3) daje sledeći rezultat?

8 / 10

Funkcija MAX daje sledeći rezultat?

9 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A$1/B1

10 / 10

Funkcija COUNT će dati sledeći rezultat?

Popunite prazna polja

Your score is

The average score is 33%

LinkedIn Facebook VKontakte
0%

Ocenite ovaj test.

© 2016 - 2026 Kalkulacija.com