Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

romana - excel udemy > 5. Visualising > Flashcards

5. Visualising Flashcards

1
Q

unde trebuie sa ma situez pentru a crea un Chart?

A

oriunde in tabel

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

de unde introduc un Chart?

A

din ribbon, meniul Insert, submeniul Charts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

cel mai simplu chart?

A

2d chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

vreau sa vad datele dintr-un chart

A

apas sus, in chart, click dpta “ Select Data “

se deschide fereastra “Select Data Source”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ce cuprinde fereastra “Select Data Source” care rezulta din click dpta:select data

A

1.chart data range (aria de celule selectate a graficului)

  1. switch Row/Column
  2. Horizontal Axis Labels (etichetele axei orizontale) -diponibil buton de Edit
  3. Legend Entries (Series)
    (intrarile legendei sau seriile legendei)
    -disponibil Edit : Series Name, Series Values
    -disponibil Add, Remove
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

daca avem date putine in tabel cum facem pt a crea un chart?

A
  1. click oriunde in tabel —-> meniul Insert —–>submeniul Charts

——> click dpta “select data”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

daca avem un tabel cu multe coloane , cum facem pt a crea un chart?
3 metode

sa zicem ca avem nevoie doar de 2 coloane din tabel

A
  1. click oriunde in tabel ——> meniul Insert —–>submeniul Charts

——> click dpta “select data”, si selectez exact ce date doresc

  1. selectez cele 2 ——> meniul Insert —–>submeniul Charts
  2. meniul Insert —–>submeniul Charts —-> se creeaza un chart gol, unde adaug eu date
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Cum copiezi un Chart? sa faci un duplicat?

A

ctrl + c, in cadrul chartului

ctrl + v, oriunde in afara chartului

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

vreau sa mut un chart. cum fac?

A

click dpta pe chart —-> Move Charts

  1. in new sheet ( foaia nu va avea zona grila, va fi doar graficul)
  2. object in…sheet X
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Cand esti intr-un chart , ce submeniuri gasesti in ribon?

A

1.Chart Design, 2.Format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Din ce este format 1.Chart Design (meniul Charts)?
mai exact ce submeniuri

A

1.1.Chart Layouts

1.2.Chart Styles

1.3.Data

1.4.Type

1.5.Location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Din ce este format 2.Format (meniul Charts)?

A

2.1. Current Selection

2.2. Insert Shape

2.3.Shape Styles

2.4. WordArt Styles

2.5.Accessibility

2.6.Size

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

1.1.Chart Layouts ce cuprinde?

A

Add Chart Element

Quick Layout

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

1.1.1.Add Chart Element (Chart Layouts-din cadrul submeniului Design din meniul Chart) ce cuprinde?

A
  1. Axes
  2. Axis Titles
  3. Chart Title
  4. Data Labels
  5. Data Table
  6. Error Bars
  7. Gridlines
  8. Legend
  9. Lines
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

label : Chart Title - componenta

A
  1. None
  2. Above Chart
  3. Centered Overlay
  4. More (Fill, Shadow, Alignment)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

daca fac dublu click pe Chart Title , axis, etc, ce se deschide?

A

se deschide caseta corespunzatoare

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

label : Axis Title - componenta

(titlurile pentru axe)

A

Primary Horizontal

Primary Vertical

More (fill, Shadow, Alignment )

se face CTRL + A, si se introduce textul dorit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

label : Legend- componenta

Cand este de folos?

se poate edita textul legendei?

A

None,

Right, Left

Top, Bottom

este de folos cand avem mai multe culori

Nu poate fi editat continutul legendei pt ca reprezinta titlurile tabelului , fata de alte componente unde se pot edita (titlul chart-ului, axe )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

label : Data Labels- componenta

inseamna numarul (data) pe care o poti pune peste acea coloana

(se poate vedea daca treci cu mouse-ul peste coloana)

A

None,

Center

Inside End (se afiseaza cifra inauntru la varful coloanei)

Inside Base (la baza coloanei, inauntru)

Data Callout (se afiseaza atat cifra cat si denumirea coloanei, ca si eticheta)
.
.
.
More (Fill, Shadow, alignment ,

LABEL OPTIONS (se poate afisa : Series Name, Category Name, Value),

NUMBER (se afiseaza formatul dorit de mine);

LINKED TO SOURCE (daca bifez imi va afisa doar cifra de la sursa, fara denumirea coloanei )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

label : Data Table- componenta

A

With Legend Keys

No Legend Keys

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

ce cuprinde CHART BACKGROUND?

A

Plot Area (zona graficului : File, Shadow)

Chart Area (zona din exteriorul graficului :File, Shadow, Size )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

label : Axes- componenta

A

Primary Horizontal
(axa doar pe orizontala )

Primary Vertical
(axa doar pe verticala)

More : Fill, Shadow, Alignment, AXIS OPTIONS!! )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

AXES - AXIS OPTIONS

A

bounds (min, max) - limita maxima si limita minima

unit (major, minor) - gradatia mare si mica

display units (Hundreds, Milions, etc)

horizontal/vertical axis crosses:
(de la ce valoare apare linia orizontala/verticala)

PT CEA ORIZONTALA:
specify interval unit : 2 (specifica denumirea coloanei din 2 in 2)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

label : Gridlines- componenta

A

PRIMARY MAJOR HORIZONTAL (VERTICAL)

PRIMARY MINOR HORIZONTAL (VERTICAL)

25
Q

daca chartul are etichetele orizontale prea lungi ce se recomanda?

A

bar chart

26
Q

de unde pot modifica un tip de chart? 2 metode

A

click dreapta sau din meniu Chart Design (change chart type)

27
Q

daca vreau sa vad chartul in care se vede contributia fiecaruia la intreg, ce aleg?

A

apple chart

click dpta pe mar si “Add Data Labels”

se pot vedea si sumele si procentele, Series, Categorii

28
Q

pt trenduri ce grafice folosesc?

A

Line Charts

29
Q

line charts
1. vreau sa adaug eticheta colturilor din “line”
2. vreau sa mai adaug un element in “Lines”
3. vreau sa schimb valorile etichetelor care reprezinta coloanele din linia horizontala (de ex: din 1,2,3 in Jan, Feb, Mar)

A
  1. click dpta —> Add Data Label (si daca sunt prea multe date, dau Undo)
  2. click dpta –>Select Data–>
    Add Series (Series name and Series Value)
  3. tot in Select Data –>
    Edit Horizontal Axis Label
30
Q

la un grafic de tip Line exista diferenta de scala intre cele 2 linii (una are valori prea mari si cealalta prea mici)

Ce fac?

A

click dpta pe linia de jos(cu valorile mai mici) —> Format Data Series —> Series Options : aleg Secondary Axis

—> se formeaza a doua axa in dreapta, cu valorile coresc

31
Q

Conditional Formatting (meniul Home)

A

formateaza o celula in functie de valoarea celulei

32
Q

Daca vreau sa vad niste cifre in forma de bare, cum fac?

A

HOME—> CONDITIONAL FORMATTING
—> data bars (si alegem Gradient Fill sau Solid Fill)

33
Q

In formatarea tip “Data Bars” unde putem vedea odata ce am stabilit regula de formatare ?

A

HOME —> CONDITIONAL FORMATTING —> MANAGE RULES

34
Q

in MANAGE RULES pt formatarea tip Data Bars ce reguli putem vedea?

ce cuprinde in mare?

A

formatarea conditionata se poate aplica in:
- pagina curenta,
-selectie si
-alte pagini ;

-BAR APPEARANCE (culoare:fill, border) - schimba culoarea barului celulei si a marginii celulei;

-bifa “SHOW BAR ONLY”(arata doar barele fara cifre)

35
Q

bifa SHOW DATA BAR ce face?
(MANAGE RULES)

A

arata doar barele, fara cifre

36
Q

3 tipuri de vizualizare pe baza valorilor pt Conditional Formatting:

format all cells based on their values

A

DATA BARS

COLOR SCALES (2 color scale, 3 color scale)

ICON SETS

37
Q

COLOR SCALES: poate fi de ex de 2 feluri

A

in 2 culori, in 3 culori

(scale de culoare)
de ex:culoarea rosie are valoarea cea mai mica si albastra are cea mai mare

38
Q

tipuri de ICON SETS

A

DIRECTIONAL

SHAPES

INDICATORS

RATINGS

39
Q

RULE TYPE: diferite tipuri

A
  1. format all cells based on their values(data bars, color scales, icon sets)
  2. format only the cell that contain (care indeplinesc un anumit criteriu: pt valoare celula, daca contine text, intre anumite date, daca contine celule goale, erori)
40
Q

Vreau sa vad evidentiate intr-un anumit format (de ex fond galben, text albastru)

1.doar celulele cu valoare > 10.000, (CELL VALUE) sau
2.cu un text continand, incepand, terminand cu..(SPECIFIC TEXT)
3.date tip data: azi, saptamna trecuta (DATES OCCURING)
4. blanks
5.not blanks
6. errors
7.not errors

A

HOME —> Conditioning Format —> New Rule –> Format only cell that contain

(formateaza doar celulele care indeplinesc anumite criterii)

41
Q

formatarea conditionata pe baza anumitor criterii (FORMAT ONLY CELLS THAT CONTAIN) se aplica datelor tip:

A
  1. numar (valori)
    2.text
    3.data
    4.spatii libere sau nu
    erori
42
Q

daca celulele nu indeplinesc criteriile din formatarea conditionata, cum se schimba continutul formatarii?

A

nu se schimba nimic la ele

43
Q

Vreau sa vad evidentiate primele 3 valori, sau 3% din cadrul unui sir de valori

A

HOME —> Conditioning Format —> New Rule –> Format only top or bottom ranked values

(valori clasate)

44
Q

vreau sa sterg o regula deja stabilita prin formatare

A

DELETE ROW

45
Q

TOP/BOTTOM RULES
(il gasesc in meniul CONDITIONAL FORMATTING)

A

TOP 10 ITEMS, 10%

BOTTOM 10 ITEMS, 10%

ABOVE/BELOW AVERAGE

46
Q

Format only values that are above or below average. - de unde poate fi accesat?

A

(se poate direct din meniul Conditional Formatting sau Edit Formatting Rule)

47
Q

se pot trece doua reguli aceluiasi set de celule (una pt below, una pt average)?

A

da,

si pot apasa : “stop if true” pt prima regula ca sa nu mai mearga la a doua

48
Q

Format only unique or duplicate values

A

(Conditional Formatting –Highlight Cells Rules –Duplicate Values sau Edit Formatting Rule)

49
Q

ex: daca valoarea din Sales este < 42000, atunci formatul rezultat va fi bolduit

daca vrem ca formula sa caute pe fiecare rand folosim referinta mixta $L13

A

Home–>Conditional Formatting —> New Rule –>
>Use a formula to determine which cells to format

50
Q

Definitia Conditional formatting

A

sa se uita dupa o conditie si daca conditia este adevarata, indeplinita, atunci vrem ca Excel sa faca un anumit format

51
Q

New Rule
Clear Rule
Manage Rules

A
52
Q

daca vreau sa adaug forme (imagini, patrate) cum fac?

A
  1. Insert –> Illustrations
    pictures smartArt
    shapes Screenshot
    icons
    3dmodels
53
Q

daca vreau sa adaug un text intr-o casuta pe un grafic sau oriunde , cum fac?

A
  1. Insert —>Text

da o privire pe WordArt si Text Box

54
Q

WHICH CHART TYPE IS RECOMMENDED FOR USE WHEN YOU PLAN TO SHOW TRENDS OVER TIME?

PIE CHART
2-D BAR CHART
3-D BAR CHART
LINE CHART

A

LINE CHART

55
Q

WHICH CHART TYPE WOULD BE A BETTER CHOICE WHEN YOU HAVE LONG CATEGORY LABELS?

PIE CHART
BAR CHART
COLUMN CHART
LINE CHART

A

BAR CHART

56
Q

YOU CAN HAVE ONLY ONE CONDITIONAL FORMATTING RULE APPLIED TO A CELL.

TRUE
FALSE

A

FALSE

57
Q

WHEN YOU COPY A CELL WITH CONDITIONAL FORMATTING AND PASTE IT IN ANOTHER CELL, THE CONDITIONAL FORMATTING IS COPIED.

TRUE
FALSE

A

TRUE

58
Q

proprietati formatare conditionata pe baza valorilor : tip DATA BARS

A

*barele sunt afisate in functie de valorile minime si maxime ale celulei

  • data bars sunt bare incluse in cadrul celulelor;

*sunt mult mai usor de citit decat valorile celulei

59
Q

proprietati formatare conditionata pe vaza valorilor: Icon Sets

A

Type: number, percent, formula

Value:>30.000 si <10000

Icon

SHOW ICON ONLY (arata doar icon fara cifre)

romana - excel udemy (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions