MISC Flashcards
$ CREATES ___?
ABSOLUTE REFERENCES
___ KEY + ___ KEY CREATES NEW LINE OF TEXT WITHIN CELLS?
ALT + ENTER
ALT + ENTER DOES WHAT?
CREATES NEW LINE OF TEXT WITHIN CELLS
FUNCTION LISTING AMOUNT OF CELLS INCLUDED IN A SAMPLE IS ___?
COUNT
KEY ___ “SNAPS” CHART BORDERS SO THAT THEY MATCH COORDINATE LINES
ALT
PATH TO FORMAT Y AXIS MINIMUM VALUE IS?
RIGHT CLICK Y AXIS/FORMAT AXIS/AXIS OPTIONS/FIXED/
PATH TO CREATE A SECONDARY AXIS ?
RIGHT CLICK LINE/FORMAT DATA SERIES/SECONDARY AXIS
THE PATH TO ADD VALUES TO THE SECONDARY AXIS?
RIGHT CLICK ON THE AXIS/FORMAT AXIS/NUMBER
KEY ___ CREATES “INSTANT CHART”
F11
F11 CREATES WHAT?
INSTANT CHART
PATH TO CREATE A CHART SHEET IS?
RIGHT CLICK CHART/MOVE CHART/NEW SHEET
PATH TO ADD PIE CHART DATA LABELS
RIGHT CLICK PIE PART/ADD DATA LABELS
PATH TO FORMAT PIE CHART DATA LABELS
RIGHT CLICK PIE PART/FORMAT DATA LABELS
PATH TO TOGGLE STACKED COLUMN CHART X-AXIS DATA
CHART TOOLS/DESIGN/SWITCH ROW COLUMN
PATH TO ADD A DATA TABLE IN A STACKED COLUMN CHART
CHART TOOLS/LAYOUT/DATA TABLE/SHOW DATA TABLE WITH LEGEND KEYS
PATH TO HID COLUMNS
HOME/CELLS/FORMAT/HIDE & UNHIDE
PATH TO DATA CALLOUT IS?
(2016) “+” BUTTON ON GRAPH (CHART ELEMENTS)/DATA LABELS/DATA CALLOUTS
The pioneer of data visualization is:
Edward Tufte
The pioneer of data visualization calls unnecessary chart elements:
JUNK
PATH TO MAKE SLICER FROM TABLE
TABLE TOOLS/DESIGN/INSERT SLICER
PATH TO ADD TOTAL ROW STYLE IN TABLE
TABLE TOOLS/DESIGN/TABLE STYLE OPTIONS/TOTAL ROW