Excell beginner

Question 1

Extensia fisierelor excel fara macro

Answer 1

xlsx

Question 2

Extensia fisierelor excel cu marcro

Answer 2

xlsm

Question 3

Extensia fisierelor excel sablon cu macro si fara macro

Answer 3

xltm respectiv xltx

Question 4

Panoramare

Answer 4

Nagyittas, zoom

Question 5

rescalare

Answer 5

nagittas, arata ribonul extins, nu minimizat

Question 6

Combinatia de taste pentru referinta relativa

Answer 6

CTR+F4

Question 7

Enumerti mourile in care puteti face referire la o celula sau o arie

Answer 7

C8
C8:D5
C:C
C:E
2:2
2:5
Nume arie

Question 8

Referinta absoluta si relativa, dati exemple

Answer 8

A2 Relativ

$A$2

Question 9

In referitna blocati doar coloana

Answer 9

$A2

Question 10

Dati exemple de moduri de selctare a ariilor si a celulelor neadiacente

Answer 10

Selctare arie:
- Click prima celula +Shift+ click ultima celula
- Click and drag
- Selectare rand sau coloana:
- click header
- SHIFT + SPACE - selecatare rand
- CTRL + SPACE - selectare coloana
- Selectare foaie de calcul: CLICK coltul stanga sus
Selectare celule neadiacente: CTRL+celulele dorite

Question 11

Imbinare

Answer 11

osszevonni - Merge

Question 12

Wrap text

Answer 12

textul se incadreaza in celule in functie de latimea coloanei

Question 13

Meniu contextual

Answer 13

Maniul care apare cu click dreapta

Question 14

Descriptor de formate

Answer 14

Format painter

Question 15

Elementele unui grafic

Answer 15

Chart area
Plot area
Axes (Horizontal or vertical)
Legend
Title
Data labels (etichete de date)

Question 16

Galerie de aspecte predefinite

Galerie de stiluri predefinite

Answer 16

Chart layouts

Chart Styles