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, 23.06.2019 07:30

Write a program that inserts the digits of an integer into an array in originalorderfollowed by reverse order. first, promptthe user to enter a positive integer(> 0). determine the number of digits of the integer. create a dynamically allocated integer arrayof a size twice the number of digits.now insert the digits in original order which will occupy half of the array. then, insert the digits in reverse order.finally, output thedigits in thearray.use at least two functions to organize your program.

Answers: 3

Answer

Computers and Technology, 23.06.2019 23:40

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the sum function in its formula? -average -autosum -counta -max

Answers: 1

Answer

Computers and Technology, 24.06.2019 10:10

Scanning the road can be thought of as a

Answers: 2

Answer

Computers and Technology, 24.06.2019 17:30

When you type january in a cell, then copy it using the fill handle to the cells below and the data automatically changes to february, march, april, and so on, what is this feature called? auto fill automaticcopy monthfill textfill

Answers: 1

Answer

You know the right answer?

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

Questions