Computers and Technology, 06.12.2021 18:30 krystalhurst97

1. Deschideti un registru nou in aplicatia Microsoft Excel. 2. Salvati registrul cu numele Formule. xlsx.
3. Modificati orientarea paginii in vedere si setati dimensiunea marginilor foii
astfel : sus si jos sa fie de 2cm , dreapta sa fie de 2.5 cm, stanga de 1.5 cm, iar
antetul si subsolul de 2 cm.
4. Introduceti in antet:

Societate comerciala “Dunarea”
Tulcea

5. Incepand cu celula A5 introduceti tabelului alaturat:
Nr crt Produs Nr
buc
Pret
/buc
lei

Pret fara
TVA
lei

TVA
15%
Pret
vanzare

1 Cutie icre de cod 10 9
2 Cutie icre de
pastrav

20 23

3 Cutie pasta de
icre

15 8

4 Punga cu guvizi 17 30
5 Caserola cu
sturion

8 45

6. Formatati capul tabelului (primul rand al tabelului) astfel: Calibri, 14,
ingrosat, centrat.
7. Calculati “pret fara TVA” folosind formula =Nr bucPret/buc
Pentru acesta in celula E6 tastati semnul „=” semn ce specifica ca urmeaza un
calcul si introduceti formula . Aceasta va avea ca efect obtinerea rezultatului in
celula dorita.
8. Calculati in celula F6 valoarea “TVA” procedand in modul prezentat anterior,
(nu uitati de semnul „=”). Formula in cazul nostru va fi: F6 = E6 15%

9. Calculati “pret vanzare” cu formula: G6 = E6 + F6
11.Redenumiti prima foaia de calcul “Preturi peste”.
12 Incarcati si trimiteti fisierul excel ca tema.
Hai repede dau 25 de puncte si coroana ma jur

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 11:00

Ihave an iphone 8plus should i get another phone like samsung note 9 or s9 ? ?

Answers: 2

Answer

Computers and Technology, 23.06.2019 01:20

Me with this program in c++ ! computers represent color by combining sub-colors red, green, and blue (rgb). each sub-color's value can range from 0 to 255. thus (255, 0, 0) is bright red. (130, 0, 130) is a medium purple. (0, 0, 0) is black, (255, 255, 255) is white, and (40, 40, 40) is a dark gray. (130, 50, 130) is a faded purple, due to the (50, 50, 50) gray part. (in other word, equal amounts of red, green, blue yield gray).given values for red, green, and blue, remove the gray part. ex: if the input is 130 50 130, the output is: 80 0 80. thus, find the smallest value, and then subtract it from all three values, thus removing the gray.

Answers: 3

Answer

Computers and Technology, 23.06.2019 10:30

Would a ps4 wired controller work on an xbox one

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:20

What is wi-fi infrastructure? a metropolitan area network that uses radio signals to transmit and receive data a communications technology aimed at providing high-speed wireless data over metropolitan area networks a means by which portable devices can connect wirelessly to a local area network, using access points that send and receive data via radio waves includes the inner workings of a wi-fi service or utility, including the signal transmitters, towers, or poles and additional equipment required to send out a wi-fi signal

Answers: 2

Answer

You know the right answer?

1. Deschideti un registru nou in aplicatia Microsoft Excel. 2. Salvati registrul cu numele Formule...

Questions