MISC Flashcards

1
Q

$ CREATES ___?

A

ABSOLUTE REFERENCES

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

___ KEY + ___ KEY CREATES NEW LINE OF TEXT WITHIN CELLS?

A

ALT + ENTER

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

ALT + ENTER DOES WHAT?

A

CREATES NEW LINE OF TEXT WITHIN CELLS

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

FUNCTION LISTING AMOUNT OF CELLS INCLUDED IN A SAMPLE IS ___?

A

COUNT

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

KEY ___ “SNAPS” CHART BORDERS SO THAT THEY MATCH COORDINATE LINES

A

ALT

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

PATH TO FORMAT Y AXIS MINIMUM VALUE IS?

A

RIGHT CLICK Y AXIS/FORMAT AXIS/AXIS OPTIONS/FIXED/

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

PATH TO CREATE A SECONDARY AXIS ?

A

RIGHT CLICK LINE/FORMAT DATA SERIES/SECONDARY AXIS

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

THE PATH TO ADD VALUES TO THE SECONDARY AXIS?

A

RIGHT CLICK ON THE AXIS/FORMAT AXIS/NUMBER

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

KEY ___ CREATES “INSTANT CHART”

A

F11

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

F11 CREATES WHAT?

A

INSTANT CHART

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

PATH TO CREATE A CHART SHEET IS?

A

RIGHT CLICK CHART/MOVE CHART/NEW SHEET

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

PATH TO ADD PIE CHART DATA LABELS

A

RIGHT CLICK PIE PART/ADD DATA LABELS

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

PATH TO FORMAT PIE CHART DATA LABELS

A

RIGHT CLICK PIE PART/FORMAT DATA LABELS

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

PATH TO TOGGLE STACKED COLUMN CHART X-AXIS DATA

A

CHART TOOLS/DESIGN/SWITCH ROW COLUMN

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

PATH TO ADD A DATA TABLE IN A STACKED COLUMN CHART

A

CHART TOOLS/LAYOUT/DATA TABLE/SHOW DATA TABLE WITH LEGEND KEYS

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

PATH TO HID COLUMNS

A

HOME/CELLS/FORMAT/HIDE & UNHIDE

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

PATH TO DATA CALLOUT IS?

A

(2016) “+” BUTTON ON GRAPH (CHART ELEMENTS)/DATA LABELS/DATA CALLOUTS

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

The pioneer of data visualization is:

A

Edward Tufte

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

The pioneer of data visualization calls unnecessary chart elements:

A

JUNK

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

PATH TO MAKE SLICER FROM TABLE

A

TABLE TOOLS/DESIGN/INSERT SLICER

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

PATH TO ADD TOTAL ROW STYLE IN TABLE

A

TABLE TOOLS/DESIGN/TABLE STYLE OPTIONS/TOTAL ROW

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

PATH TO CONVERT TO NORMAL RANGE?

A

(REMOVE TABLE) TABLE TOOLS/DESIGN/CONVERT TO RANGE

23
Q

3 STEP PROCESS TO SUBTOTAL A TABLE

A
  1. SORT DESIRED COLUMN OF TABLE
  2. CONVERT TABLE TO A NORMAL RANGE
  3. SUBTOTAL
24
Q

KEYS ___ & ___ GO TO CELL A1

A

CTRL & HOME

25
Q

PATH TO CENTER A TABLE FOR PRINTING, AND ADD HEADERS/FOOTERS

A

PRINT/PAGE SETUP/

26
Q

PATH TO PRINT TOP ROWS ACROSS THE SAME WORKSHEET

A

PAGE LAYOUT/PRINT TITLES/ROWS TO REPEAT AT TOP

27
Q

When you filter your data, data is:

A

Hidden

28
Q

___ KEY SELECTS MULTIPLE SHEETS

A

SHIFT

29
Q

FORMULA TO COPY DATA FROM ONE SHEET TO ANOTHER

A

=DESIREDSHEET!DESIREDCELL

30
Q

PATH TO =SUM ACROSS SHEETS

A

=SUM( / LEFTMOST DESIRED SHEET TO SUM / SHIFT CLICK ON RIGHTMOST / RESELECT SELECTED CELL / ENTER

31
Q

IF:

___ FIELD SPECIFIES COLUMNS TO BE USED AS FORMULA “TERMS”

A

RANGE

32
Q

IF/S:

___ FIELD SPECIFIES BOUNDARIES OF “IF”

A

CRITERIA

33
Q

IF/S:

___ FIELD SPECIFIES COLUMNS TO BE AVERAGED

A

_RANGE

34
Q

IF:

ALL IF FORMULAS BEGIN WITH ___ & ___

A

RANGE & CRITERIA

35
Q

IF:

ONLY ___ & ___ IF FORMULAS END IN ___

A

_RANGE

36
Q

IF:

ONLY IF FORMULA WITH ONLY 2/3 FORMULA “FIELDS”

A

COUNTIF

37
Q

IFS:

ONLY ___ & ___ IF FORMULAS BEGIN WITH ___ _RANGE & ___ _RANGE

A

SUMIFS & AVERAGEIFS

38
Q

IFS:

ONLY IFS FORMULA WHICH EXCLUSIVELY COMPOSED OF CRITERIA_RANGE

A

COUNTIFS

39
Q

IFS:

ALL IFS FORMULAS END WITH ___ “FIELD”

A

CRITERIA_RANGE

40
Q

___ function links multiple cells together in a chain or series

A

=CONCATENATE

41
Q

___ FUNCTION REMOVES ALL BUT SINGLE SPACES BETWEEN WORDS

A

=TRIM

42
Q

PATH TO TRIM & CONCATENATE

A

=TRIM(CONCATENATE(___CELLS___))

43
Q

___ FUNCTION EXTRACTS PHRASES FROM THE MIDDLE OF CELLS WITH NO SPACES

A

=MID

44
Q

___ FUNCTION EXTRACTS PHRASES FROM THE LEFT OF CELLS WITH NO SPACES

A

=LEFT

45
Q

___ FUNCTION EXTRACTS PHRASES FROM THE RIGHT OF CELLS WITH NO SPACES

A

=RIGHT

46
Q

___ functionreturns the number of the character at which a specific character or text string is first found

A

=SEARCH

47
Q

BETWEEN =FIND & =SEARCH FUNCTIONS, WHICH CONSIDERS CASE?

A

=FIND

48
Q

___ & ___ FUNCTIONS LOCATE SPECIFIC CHARACTERS WITHIN CELLS

A

=FIND & =SEARCH

49
Q

BETWEEN =FIND & =SEARCH FUNCTIONS, WHICH DOES NOT CONSIDER CASE?

A

=SEARCH

50
Q

___ FUNCTION ADDS ADDITIONAL CHARACTERS AT BEGINNING OF CELL

A

=TEXT(___CELL___,”0000000”)

51
Q

___ FUNCTION REMOVES SPECIAL CHARACTERS, LEAVING ONLY NUMBERS

A

=VALUE

52
Q

___ FUNCTION GIVES A NUMERIC RETURN FROM A CELL (EXAMPLE ‘12345)

A

=VALUE

53
Q

___ function removes all nonprintable characters

A

=CLEAN