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 15:30

1. ask the user how many questions are in the quiz. 2. ask the user to enter the key (that is, the correct answers). there should be one answer for each question in the quiz, and each answer should be an integer. e.g., 34 7 13 100 81 3 9 10 321 12 might be the key for a 10-question quiz. you will need to store the key in an array. 3. ask the user to enter the answers for the quiz to be graded. there needs to be one answer for each question. note that these answers do not need to be stored; each answer can simply be compared to the key as it is entered. 4. when the user has entered all of the answers to be graded, print the number correct and the percent correct. 5. add a loop so that the user can grade any number of quizzes with a single key. after the results have been printed for each quiz, ask "grade another quiz? (y/n)." note: you only have one array (the key). you are not creating a new key for each set of quiz answers.

Answers: 3

Answer

Computers and Technology, 23.06.2019 20:00

What software programs are used to to create professional publication? a.) graphics programs b.) word processors c.) page layout programs d.) spreadsheet programs

Answers: 2

Answer

Computers and Technology, 24.06.2019 02:00

How are we able to create photographs differently than 100 years ago? explain your answer in relation to your photograph you selected.

Answers: 1

Answer

Computers and Technology, 24.06.2019 03:30

Explain the importance of html in web page designing in 20 sentences..

Answers: 1

Answer

You know the right answer?

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