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 buc*Pret/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
Computers and Technology, 23.06.2019 00:30
Quic which one of the following is the most accurate definition of technology? a electronic tools that improve functionality b electronic tools that provide entertainment or practical value c any type of tool that serves a practical function d any type of tool that enhances communication
Answers: 1
Computers and Technology, 24.06.2019 11:30
Convert 11001110(acdd notation) into decimal
Answers: 2
Computers and Technology, 24.06.2019 20:20
Write python code that prompts the user to enter his or her favorite color and assigns the user’s input to a variable named color.
Answers: 1
Computers and Technology, 24.06.2019 23:30
What is the opening page of a website called? a. web page b. landing page c. homepage d. opening page
Answers: 1
1. Deschideti un registru nou in aplicatia Microsoft Excel.
2. Salvati registrul cu numele Formule...
Computers and Technology, 07.01.2021 03:50
Social Studies, 07.01.2021 03:50
Mathematics, 07.01.2021 03:50
Mathematics, 07.01.2021 03:50
English, 07.01.2021 03:50
Mathematics, 07.01.2021 03:50
English, 07.01.2021 03:50
Mathematics, 07.01.2021 03:50
Mathematics, 07.01.2021 03:50
Mathematics, 07.01.2021 03:50