Zadaca5.ods

  • Uploaded by: Irena Zrno
  • 0
  • 0
  • December 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Zadaca5.ods as PDF for free.

More details

  • Words: 119
  • Pages: 2
Tabela1 Knjiga Word Excel Access C++ Corel ECDL Napomene

Sniženje knjiga STARA CIJENA(KM) SNIŽENJE 12.00% 105 10.00% 86 17.00% 98 45.00% 75 30.00% 50 60.00% 130 Ukupan iznos sniženja Najveći iznos sniženja

Iznos sniženja u ćeliji D3=B3*C3

IZNOS SNIŽENJA(KM) 12.6 8.6 16.66 33.75 15 78 164.61 78

Najmanji iznos sniženja 8.6

Nova cijena(KM) u ćeliji E3=B3-D3

Prosječni iznos sniženja 27.435

Ukupno knjiga u ponudi u ćeliji D13=COUNTA( A3:A8)

Ukupno knjiga u ponudi na sniženju 6

Sniženje knjiga 140

Cijena knjiga u KM

120 100 80

STARA CIJENA(KM) NOVA CIJENA(KM)

60 40 20 0 Word

Excel

Access

C++

Nazivi knjiga

Stranica 1

Corel

ECDL

Tabela1 NOVA CIJENA(KM) 92.4 77.4 81.34 41.25 35 52

STARA CIJENA(KM) NOVA CIJENA(KM)

CDL

Stranica 2

More Documents from "Irena Zrno"

Zadacainf.ods
December 2019 8
Zadaca5.ods
December 2019 18
June 2020 23
June 2020 14