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.

Objavite svoj Power BI Izveštaj

Tuesday September 5th, 2017 admin Power Excel, PowerBI

Objavite svoj Power BI Izveštaj lako i jedostavo. Izveštaju mogu pristupiti samo oni korisnici koje odredite i vi kao kreator.

Continue reading

Multi Table into One Table

Monday August 21st, 2017 admin Power Excel, VBA Macro II

Merging multiple tables of the same format that are in the space of one working table. If someone is interested

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

Numbers in thousand (k) or in million (M)

Friday May 5th, 2017 admin Advanced Excel, Excel, Tips for excel, Tips for excel

The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is

Continue reading

Copy Visible Cells Only

Wednesday February 1st, 2017 admin Excel, Tips for excel

By default, Excel copies both visible and hidden cells. However, it is possible to copy visible cells only. In this

Continue reading

Protected View in Excel

Thursday January 12th, 2017 admin Excel, Tips for excel

Excel precaution to protect your computer from potential viruses, all files are protected through the opening show. By using Protected

Continue reading

Figure as Number

Saturday December 31st, 2016 admin Excel, Tips for excel

Not a few times in the table we have a numbers with which we can not do any mathematical operation

Continue reading

AutoFit Column Width

Friday December 30th, 2016 admin Excel, Tips for excel

In cases where the content is not displayed in a cell, simply select the column, row or entire table and

Continue reading

Shifting text to columns

Thursday December 29th, 2016 admin Excel, Tips for excel

When we have the contents of a set of data in a single table cell as the following figure: i We need

Continue reading

Posts pagination

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

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=$A1-B2

2 / 10

Funkcija SUBTOTAL će dati sledeći rezultat?

3 / 10

Ako je:                A1=3                 B1=3

Koji se rezultat dobija?

C1=$A$1/B1

4 / 10

Funkcija AVERAGE daje sledeći rezultat?

5 / 10

Funkcija COUNT će dati sledeći rezultat?

6 / 10

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

7 / 10

Funkcija COUNTA vraća rezultat?

8 / 10

Funkcija MAX daje sledeći rezultat?

9 / 10

Funkcija DATE(12,12,12) daje datum?

10 / 10

Ako je:                A1=5                 B1=5

Koji se rezultat dobija?

C1=$A$1+B1

Popunite prazna polja

Your score is

The average score is 33%

LinkedIn Facebook VKontakte
0%

Ocenite ovaj test.

© 2016 - 2026 Kalkulacija.com