Distribuţia notelor

Notă Examen Nota Număr note Distribuţia grafică a notelor

554 8.25 1 52 llllllllllllllllllllllllllllllllllllllllllllllllllll299 8.75 2 122 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll331 8.25 3 175 lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll190 10.00 4 234 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll531 9.00 5 304 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll271 10.00 6 352 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll549 7.25 7 412 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll715 2.50 8 462 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll104 6.50 9 518 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll589 8.25 10 626 llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll300 1.00708 1.2556 6.50

208 3.0072 2.75

631 5.00137 8.25302 6.25312 6.50632 6.75723 1.50648 8.50415 9.75304 2.25638 3.25659 2.75392 9.00339 10.00402 1.00623 3.00254 9.50305 1.75108 4.50604 3.50718 9.00370 1.25354 5.25

6 6.25

Să se reprezinte grafic (histogramă orizontală) distribuţia notelor utilizând o funcţie de tip text, si nu un obiect grafic

Cod student

506 6.0064 7.0029 1.75

313 2.75184 4.00477 4.00292 2.0059 2.5089 9.50

434 3.75183 9.50645 1.25282 6.5071 4.50

100 1.00315 3.50725 9.00101 6.25451 9.25612 4.50316 2.50317 8.50274 9.75667 6.50617 5.25127 7.5079 3.7577 1.00

156 4.00704 6.50529 3.75296 3.25172 7.0081 5.0057 10.00

457 10.00432 2.00586 3.25541 8.75225 3.25330 9.7544 3.25

144 10.00220 7.25216 9.50324 1.50

135 1.00328 9.50308 8.2542 6.50

644 3.50200 6.50699 3.00129 10.00171 5.25329 2.00173 9.00320 5.50335 9.50192 7.00260 1.00336 4.50379 9.00637 4.50206 9.00341 10.00248 2.75344 8.50345 2.75112 7.50310 1.00367 8.25346 8.75277 1.00152 2.0023 10.00

716 4.75291 2.50411 4.50276 5.75185 7.50608 3.75105 1.25564 5.25236 6.75349 1.00222 2.50186 7.00251 10.00443 2.7598 10.00

500 2.25

334 9.7566 8.50

355 1.00474 7.50360 3.00102 8.25375 2.75568 3.75599 2.00239 6.50470 1.25681 6.25537 1.00668 5.75364 9.00366 4.75662 5.00224 8.0012 5.2524 10.00

559 3.507 3.50

653 10.00624 9.50373 2.50403 7.50376 2.25441 5.25350 2.00593 4.75298 8.00325 10.00720 3.50510 3.00661 3.25143 3.25404 5.00426 10.0046 9.00

378 3.25268 9.0062 1.75

123 9.75672 6.50134 5.50597 9.50

579 8.50497 5.75168 4.50365 3.25383 7.25552 9.00169 4.00620 5.50619 6.7541 1.00

126 10.00710 5.00634 6.00337 9.50229 4.75387 1.00284 6.75111 6.0026 6.25

393 10.00486 6.50242 8.00188 1.00479 2.0054 10.00

395 9.75340 1.25397 1.00165 3.50307 5.00361 5.25400 1.25139 2.00674 2.20633 8.00513 7.50401 8.75406 3.25489 1.0065 10.0049 3.5018 9.50

570 4.5028 1.00

713 1.00678 5.25

87 7.00407 2.75418 6.50269 5.00574 8.00234 7.25490 5.75468 7.75396 10.00408 9.50414 9.50542 4.50430 4.50712 9.0053 4.50

613 4.50622 4.75655 5.0092 4.50

606 9.75603 9.5047 9.50

228 1.25124 9.00416 5.50677 7.50294 4.50118 6.2538 4.50

215 7.75417 1.25419 9.75435 3.00682 4.50688 8.5093 1.00

436 3.0017 9.00

388 6.25180 1.50132 6.00684 1.50238 10.00125 6.50621 6.50626 6.50

213 8.7531 7.5084 9.5094 4.25

343 5.50458 5.25481 4.50642 8.50438 3.25199 10.0070 1.00

485 10.00647 2.00666 2.50550 9.50295 3.50

3 9.75657 3.2515 8.00

210 9.00439 5.50702 3.00459 5.00381 1.00442 7.75694 1.00273 8.00372 10.00445 4.50447 3.7511 7.00

582 8.25422 6.50448 5.00116 2.00

8 10.00692 5.25449 4.50227 5.50707 9.75722 3.75327 9.50687 2.00138 7.50

9 1.00321 1.50

352 7.25197 4.75640 7.5067 9.25

293 3.00359 7.75473 3.50467 7.75553 8.75652 1.00

1 8.50548 3.00174 2.25455 8.00598 6.2551 10.00

460 6.50164 3.25669 2.75141 8.00257 1.50629 1.25602 1.00462 5.75584 4.50463 3.75658 6.00446 4.50303 10.00625 5.75195 3.50456 7.50261 1.00382 3.50600 9.50230 1.00285 10.0061 1.00

571 9.75410 6.50475 5.2580 6.25

121 1.00209 9.25556 1.00157 6.00

680 9.75241 7.50146 9.00133 2.0035 3.00

120 2.75226 3.25207 1.00280 5.75193 2.00265 2.50394 1.0091 9.5030 6.2539 5.25

476 3.75480 4.50181 8.50487 5.00488 10.0045 2.00

427 1.50163 1.50483 1.75235 8.75543 1.25358 1.00109 3.25136 5.00491 6.50544 9.50714 3.00278 4.50279 4.5027 1.00

219 5.7514 9.75

160 6.25494 2.2578 2.00

142 4.75700 10.0013 4.75

698 2.00338 4.50217 6.25

161 6.75253 8.50178 2.00501 5.5052 10.0043 10.00

502 1.50696 3.50503 4.75107 1.00425 8.00362 7.25113 5.75140 5.25386 10.00117 10.00693 1.25115 8.00

5 2.25119 4.7588 1.00

151 1.50203 6.50505 9.50575 7.00665 3.25453 6.00333 1.00641 2.10478 8.0048 1.00

508 1.50509 4.50162 7.25514 7.75266 6.50214 10.00420 9.75515 7.75

2 9.50516 2.00159 3.50187 4.00114 4.75697 8.00519 9.75

518 1.00149 6.50240 9.50288 4.7540 10.00

452 8.25605 5.00521 2.25301 10.00179 10.00577 4.50522 9.0074 1.0068 3.75

353 6.75444 4.50437 4.75484 6.25573 8.75523 7.25525 1.00332 9.50347 9.25469 2.00572 9.75595 5.50205 2.50628 1.25247 10.00391 3.7585 9.00

528 1.25148 2.25431 8.5096 2.00

245 2.50399 2.00706 5.0033 10.00

182 10.00592 8.75685 2.75246 8.50511 9.00651 5.50679 5.00

536 4.50189 6.50368 3.75167 7.50202 3.75464 10.00533 7.75504 9.75262 10.00627 6.5097 10.0032 2.00

654 10.0099 10.00

147 3.50534 9.75539 1.75232 10.00374 10.0036 2.00

703 2.75342 2.50611 7.00286 3.50660 6.00389 5.00709 6.25646 1.00671 2.25689 9.5055 10.00

532 8.25557 6.50673 6.50433 1.00656 1.00170 3.00610 5.00221 4.5083 10.0050 10.00

587 8.50675 5.7563 8.2521 7.75

558 1.00

482 8.00596 3.75721 5.75106 8.00218 6.75103 9.00424 4.5073 2.00

560 1.50428 9.50695 5.25676 4.50283 3.75686 4.50601 1.00717 9.75263 8.50517 9.75423 1.75270 4.50259 7.50561 2.00377 1.50256 10.00461 1.00562 9.75563 7.75130 1.00131 2.00289 1.00607 6.75255 10.00630 5.25243 3.50565 9.50639 4.50690 6.0022 6.00

204 1.7590 1.00

450 7.00212 6.25390 2.00493 8.00614 1.25466 9.00

385 10.00545 3.25567 5.7534 10.00

724 2.00198 3.50128 3.50237 8.75576 3.75535 2.00244 8.75580 7.50566 7.75551 9.00663 1.00581 10.00615 3.0086 9.00

701 1.50583 2.00223 10.00318 1.25585 3.75357 7.00588 9.50495 4.5069 1.50

636 1.75590 3.50398 3.00471 8.00249 2.75591 1.00275 2.75578 4.50158 2.50649 5.50314 8.25413 4.50440 6.25306 1.25290 4.75110 3.00356 8.50122 9.50

Distribuţia grafică a notelor

lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll

utilizând o funcţie de tip text, si nu un obiect grafic

lllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll

llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll

llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll

llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll

llllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll

Nume Prenume Sucursala Departament

ALBITER Oana Plevnei Creditare

ALBU Constanta Doctor Felix Creditare

BLAGA Mădălina Plevnei Corporaţii

CHIRU Bogdan Plevnei Oficiul juridic

COMAN Aura Ştefan cel Mare Asigurari

CONSTANTIN Ana Doctor Felix Corporaţii

DEDU Natalia Ştefan cel Mare Corporaţii

GANEA Pavel Ştefan cel Mare Creditare

MANESCU Andreea Ştefan cel Mare Oficiul juridic

MIHAI Carmen Ştefan cel Mare Creditare

MIHAI Dinu Doctor Felix Oficiul juridic

MONDREA Laura Ştefan cel Mare Creditare

NEDELCU Mihai Ştefan cel Mare Oficiul juridic

PANAIT Cornel Ştefan cel Mare Asigurari

PETRE Cristina Doctor Felix Relaţii clienţi

POPA Florin Ştefan cel Mare Corporaţii

POPESCU Viorel Dan Doctor Felix Creditare

SAVU Cătălin Ştefan cel Mare Asigurari

SORESCU Liana Plevnei Creditare

VISAN Alexandra Plevnei Corporatii

VLAD Petru Ştefan cel Mare Relaţii clienţi

Data naşterii (ll/zz/aa)

11/07/49 F Oct-1983 Nov-194909/04/77 F Feb-1970 Sep-197711/23/61 F Aug-1981 Nov-196108/17/56 M Dec-1979 Aug-195603/04/80 F Dec-2006 ###12/07/50 F May-2004 Dec-195007/22/61 F Feb-2006 Jul-196111/01/70 M Nov-2002 Oct-197010/10/81 F Apr-2006 Oct-198102/27/60 F Sep-1980 Feb-196006/02/55 M Jul-1979 Jun-195506/15/60 F Apr-2006 Jun-196001/30/81 M Jun-1985 Jan-198105/01/59 M Oct-1984 Apr-195908/09/66 F Apr-1980 Aug-196610/01/50 M Jun-1999 Sep-195012/12/62 M Apr-2006 Dec-196204/04/70 M Mar-1978 Apr-197003/12/68 F Apr-2006 ###12/25/72 F Nov-1975 Dec-197202/05/60 M Aug-2001 Feb-1960

Genul (M=masculin F=feminin)

Data angajării

Vechimea (ani)

Cod numeric personal

2,900 lei 2.49.11.07.345633

2,900 lei 2.77.09.04.444890

2,800 lei 2.61.11.23.546967

3,200 lei 1.56.08.17.341871

1,000 lei 2.80.03.04.227773

1,050 lei 2.50.12.07.472590

1,050 lei 2.61.07.22.114674

1,200 lei 1.70.11.01.555889

1,050 lei 2.81.10.10.510053

2,900 lei 2.60.02.27.503812

3,200 lei 1.55.06.02.422877

1,000 lei 2.60.06.15.100121

2,790 lei 1.81.01.30.333655

2,500 lei 1.59.05.01.673895

3,350 lei 2.66.08.09.310349

1,180 lei 1.50.10.01.701902

1,000 lei 1.62.12.12.345345

2,900 lei 1.70.04.04.222888

1,000 lei 2.68.03.12.508405

3,200 lei 2.72.12.25.557812

1,180 lei 1.60.02.05.667445

Salariu încadrare

Cod Produs pret

1231234 312

1233212 332

2345657 456

3578903 789

2134123 341

4568950 689

48.1666666666667 #DIV/0!

Să se calculeze preţul mediu, presupunând că acesta este editat începând de la valoarea poziţională 3 până la 5 în codul compozit din câmpul A3:A8.

, presupunând că acesta este editat începând de la valoarea poziţională 3 până la 5 în codul compozit din câmpul A3:A8.

5 9 12 0001 AAA

3 5 10 01 A

4 7 9 001 AA

Cod compozit in patru trepte variabile

Identificarea valorii

pozitionale aferente primului SPATIU

Identificarea valorii

pozitionale aferente celui de-al doilea

SPATIU

Identificarea valorii

pozitionale aferente celui de-al treilea

SPATIU

Extragerea primului grup de

caractere

Extragerea celui de-al

doilea grup de caractere

0001 AAA ZZ 999999

01 A ZZZZ 99

001 AA Z 9999

Observaţie: Alegerea succesiunii de afişare a grupurilor de caractere din codul compozit recompus rămâne la latitudinea studentului.

ZZ 9 0001 AAA ZZ 9

ZZZZ 99 01 ZZZZ 99

Z 9999 001 AA 9999

Extragerea celui de-al

treilea grup de

caractere

Extragerea ultimului grup de

caractere

Cod recompus in alta ordine (prin concatenare)

: Alegerea succesiunii de afişare a grupurilor de caractere din codul compozit recompus rămâne la latitudinea studentului.

Nume Prenume Sucursala Departament Codul salariatului

ALBITER Oana Plevnei Creditare Cred-Nov49 F

ALBU Constanta Doctor Felix Creditare Cred-Sep77 F

BLAGA Mădălina Plevnei Corporaţii Corp-Nov61 F

CHIRU Bogdan Plevnei Oficiul juridic Ofic-Aug56 M

COMAN Aura Ştefan cel Mare Asigurari Asig-Mar80 F

CONSTANTIN Ana Doctor Felix Corporaţii Corp-Dec50 F

DEDU Natalia Ştefan cel Mare Corporaţii Corp-Jul61 F

GANEA Pavel Ştefan cel Mare Creditare Cred-Nov70 M

MANESCU Andreea Ştefan cel Mare Oficiul juridic Ofic-Oct81 F

MIHAI Carmen Ştefan cel Mare Creditare Cred-Feb60 F

MIHAI Dinu Doctor Felix Oficiul juridic Ofic-Jun55 M

MONDREA Laura Ştefan cel Mare Creditare Cred-Jun60 F

NEDELCU Mihai Ştefan cel Mare Oficiul juridic Ofic-Jan81 M

PANAIT Cornel Ştefan cel Mare Asigurari Asig-May59 M

PETRE Cristina Doctor Felix Relaţii clienţi Rela-Aug66 F

POPA Florin Ştefan cel Mare Corporaţii Corp-Oct50 M

POPESCU Viorel Dan Doctor Felix Creditare Cred-Dec62 M

SAVU Cătălin Ştefan cel Mare Asigurari Asig-Apr70 M

SORESCU Liana Plevnei Creditare Cred-Mar68 F

VISAN Alexandra Plevnei Corporatii Corp-Dec72 F

VLAD Petru Ştefan cel Mare Relaţii clienţi Rela-Feb60 M

Genul (M=masculin F=feminin)

Codul angajatului reprezintă un cod compozit care conţine: primele 4 litere din departament, luna şi anul naşterii .

Exemplu: salariatul Visan Alexandra are codul Corp-12-72

Cod numeric personal

59 ani Oct-1983 25 ani 2,900 lei 2.49.11.07.345633 ALBITER 2.49.11.07.345633

31 ani Feb-1970 39 ani 2,900 lei 2.77.09.04.444890 ALBU Cons2.77.09.04.444890

47 ani Aug-1981 27 ani 2,800 lei 2.61.11.23.546967 BLAGA Mă2.61.11.23.546967

52 ani Dec-1979 29 ani 3,200 lei 1.56.08.17.341871 CHIRU Bo1.56.08.17.341871

29 ani Dec-2006 2 ani 1,000 lei 2.80.03.04.227773 COMAN A2.80.03.04.227773

58 ani May-2004 4 ani 1,050 lei 2.50.12.07.472590 CONSTAN2.50.12.07.472590

47 ani Feb-2006 3 ani 1,050 lei 2.61.07.22.114674 DEDU Nata2.61.07.22.114674

38 ani Nov-2002 6 ani 1,200 lei 1.70.11.01.555889 GANEA Pa1.70.11.01.555889

27 ani Apr-2006 2 ani 1,050 lei 2.81.10.10.510053 MANESCU 2.81.10.10.510053

49 ani Sep-1980 28 ani 2,900 lei 2.60.02.27.503812 MIHAI Ca 2.60.02.27.503812

53 ani Jul-1979 29 ani 3,200 lei 1.55.06.02.422877 MIHAI Di 1.55.06.02.422877

48 ani Apr-2006 2 ani 1,000 lei 2.60.06.15.100121 MONDREA 2.60.06.15.100121

28 ani Jun-1985 23 ani 2,790 lei 1.81.01.30.333655 NEDELCU 1.81.01.30.333655

49 ani Oct-1984 24 ani 2,500 lei 1.59.05.01.673895 PANAIT Co1.59.05.01.673895

42 ani Apr-1980 28 ani 3,350 lei 2.66.08.09.310349 PETRE Cri2.66.08.09.310349

58 ani Jun-1999 9 ani 1,180 lei 1.50.10.01.701902 POPA Flor 1.50.10.01.701902

46 ani Apr-2006 2 ani 1,000 lei 1.62.12.12.345345 POPESCU V1.62.12.12.345345

38 ani Mar-1978 31 ani 2,900 lei 1.70.04.04.222888 SAVU Cătă1.70.04.04.222888

41 ani Apr-2006 2 ani 1,000 lei 2.68.03.12.508405 SORESCU 2.68.03.12.508405

36 ani Nov-1975 33 ani 3,200 lei 2.72.12.25.557812 VISAN Ale2.72.12.25.557812

49 ani Aug-2001 7 ani 1,180 lei 1.60.02.05.667445 VLAD Petr1.60.02.05.667445

Vârsta (ani)

Data angajării

Vechimea (ani)

Salariu încadrare

Nume Prenume

Cod numeric personal

reprezintă un cod compozit care conţine: primele 4 litere din departament, luna şi anul naşterii .

Adresa e-mail

Pana Adrian

Ionescu Bogdan

Ionescu Iuliana

Oancea Mirela

Gheorghe Mirela

Mares Valerica

Mihai Florin

Stanciu Andrei

Gavrila Alexandru

Nume Prenume

pana@ase.roionescu@ase.roionescu@ase.rooancea@ase.rogheorghe@ase.romares@ase.romihai@ase.rostanciua@ase.rogavrila@ase.ro

Adresa e-mail va fi compusă din numele cadrului didactic + caracterul "@" şi domeniul "ase.ro".Exemplu: pana@ase.ro

va fi compusă din numele cadrului didactic + caracterul "@" şi domeniul "ase.ro".

Denumire disciplinamicrosoft Excel 2007birotică profeSIOnalăsisteme informatice de GesTiuNebazele tehnologiei informaţieimaTEmatici aplicate in ECOnomieDoctrine Contemporane

Text în care primul caracter este majusculă, eliminindu-se spatiile nesemnificativemicrosoftExcel2007biroticăprofeSIOnalăsistemeinformaticedeGesTiuNebazeletehnologieiinformaţieimaTEmaticiaplicateinECOnomieDoctrineContemporane

Extragerea anului Extragerea lunii Extragerea zilei

Precizarea zilei din saptaminaPrecizarea numarului saptaminii

7111

Format personalizat :dddd dd mmmm yyyy è

Formulă ce returnează numărul trimestrului

8/29/20152015

829

Data calendaristica

Monday 09 November 2015Monday 18 May 2015

Monday 10 August 2015Sunday 08 March 2015

Formulă ce returnează numărul semestrului

Data lansării unei comenzi de fabricaţie a unui vapor es Fri 13 March 2015Numărul de zile necesar fabricaţiei 45

Fri 20 March 2015Fri 20 March 2015

Diferenţa:

Data livrării (fără weekend-uri şi s.l.)Data livrării (cu weekend-uri şi s.l.)

zile

Suma depusă într-un depozit la termen:Rata dobânzii (anuale):Perioada constituirii depozitului (cu capitalizare)

Nr. luni Friday 22 May 20156 luni Tuesday 22 November 2016

12 luni Sunday 22 May 201618 luni Tuesday 22 November 201624 luni Monday 22 May 2017

obs: Sa se formateze conditional luna si anul unei scadente care coincid cu luna curenta a anului curent

Câmp numit "Data_depozit"

50,000 lei 12%

6 luni

obs: Sa se formateze conditional luna si anul unei scadente care coincid cu luna curenta a anului curent

ç Data constituirii depozituluiç Data primei scadenţe (după 6 luni)ç Data celei de a 2-a scadenţe (după 12 luni)ç Data celei de a 3-a scadenţe (după 18 luni)ç Data celei de a 4-a scadenţe (după 24 luni)

Câmp numit "Data_depozit"

Wednesday 15/04/2015Thursday 14/05/2015

Data plecarii în concediuData revenirii din concediu

Număr de zile (lucrătoare) de concediu (fără weekend-uri) èNumăr de zile concediu (fără weekend-uri şi sărbători legale) è

Thursday 01/01/2015Friday 02/01/2015

22 Saturday 24/01/201521 Sunday 12/04/2015

Monday 13/04/2015Friday 01/05/2015

Sunday 31/05/2015Monday 01/06/2015

Saturday 15/08/2015Monday 30/11/2015Tuesday 01/12/2015

Friday 25/12/2015Saturday 26/12/2015

Câmp intitulat "Sarbatori"