Computers and Technology

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

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 03:20, owoeli
Which of these is a benefit of social networking? oa. hiding your true identity from friendsob. avoiding talking to people in personoc. spending time with friends instead of studyingod. connecting with new people
Answers: 2
image
Computers and Technology, 22.06.2019 08:40, batman48000
1. the program must provide following functions to extract some statistics. note that the data_list parameter specified in these functions may be the same for all functions or different for different functions—that is your choice. a skeleton file is provided on mirmir. a) open_file()prompts the user to enter a year number for the data file. the program will check whether the year is between 1990 and 2015 (both inclusive). if year number is valid, the program will try to open data file with file name ‘year. txt’, where is the year. appropriate error message should be shown if the data file cannot be opened or if the year number is invalid. this function will loop until it receives proper input and successfully opens the file. it returns a file pointer and year. i. hint: use string concatenation to construct the file name b) read_file(fp)has one parameter, a file pointer read. this function returns a list of your choosing containing data you need for other parts of this project. c) find_average(data_list) takes a list of data (of some organization of your choosing) and returns the average salary. the function does not print anything. hints: i. this is not the average of the last column of data. it is not mathematically valid to find an average by finding the average of averages—for example, in this case there are many more in the lowest category than in the highest category. ii. how many wage earners are considered in finding the average (denominator)
Answers: 1
image
Computers and Technology, 23.06.2019 15:00, ryleerose255
Idon’t understand the double8 coding problem. it is java
Answers: 1
image
Computers and Technology, 23.06.2019 20:30, batmandillon21
1. for which of the following are you not required to signal beforehand? a. changing lanes b. speeding up c. stopping
Answers: 2
Do you know the correct answer?
1. Deschideti un registru nou in aplicatia Microsoft Excel. 2. Salvati registrul cu numele Formule...

Questions in other subjects:

Konu
Mathematics, 07.05.2021 14:00