EXCEL 2016
CHAPTER 3
ABSOLUTE
REFERENCES
P. 3 2 7 , 4 1 1
2. ENTER FORMULA. USE F4
FOR ABSOLUTE REFERENCE
1. SELECT CELL THAT
MUST DISPLAY RESULT
3. PRESS TO ENTER
CALCULATE RESULT
4. FORMULA COPIED
5. FORMATTING: %, CENTERED
CREATE PIE
CHART
P. 4 1 3
2. CLICK INSERT TAB
3. CLICK INSERT PIE OR
DOUGHNUT CHART
4. CLICK 3-D PIE CHART
5. 3-D PIE CHART INSERTED
1. SELECT DATA FOR CHART
MOVE CHART TO
NEW WORKSHEET
P. 4 1 3
2. CLICK CHART
TOOLS DESIGN
3. CLICK MOVE CHART
4. SELECT NEW SHEET 5. SPECIFY SHEET NAME
6. CLICK OK
1. SELECT CHART
6. CHART MOVED
TO CHART SHEET
FORMAT A PIE
CHART
P. 4 1 4
CHART TITLE
2. ENTER CHART TITLE
AND PRESS ENTER
1. SELECT CHART TITLE
3. CHART TITLE INSERTED
2. CLICK CHART TOOLS
FORMAT
3. SELECT WORDART
FORMATTING
FORMATTING: 32PT, FILL – 1. SELECT CHART TITLE
GOLD, ACCENT 4, SOFT BEVEL
CHART ELEMENTS
P. 4 1 4
2. SELECT CHART ELEMENTS
1. SELECT CHART
3. SELECT CHART ELEMENTS
TO DISPLAY / HIDE
2. SELECT CHART ELEMENTS
1. SELECT CHART
3. SELECT MORE OPTIONS
4. SELECT LABEL OPTIONS
5. SELECT LABEL POSITION
DATA SERIES
P. 4 1 6
2. CLICK ON
EFFECTS BUTTON
4. SET WIDTH &
HEIGHT TO 512PT
1. DOUBLE CLICK
ON DATA SERIES 3. SELECT CIRCLE BEVEL
2. CLICK CHART
TOOLS FORMAT
3. CLICK SHAPE
EFFECTS
4. SELECT SHADOW
1. SELECT DATA
SERIES
5. SELECT PERSPECTIVE BELOW
ROTATE PIE
CHART
P. 4 1 8
2. CLICK ON SERIES
OPTIONS BUTTON
3. SET ANGLE TO 250 DEGREES
1. SELECT DATA
SERIES
EXPLODE PIE
SLICE
P. 4 1 9
2. CLICK ON SERIES
OPTIONS BUTTON
3. SET EXPLOSION TO 10 DEGREES
1. DOUBLE CLICK
DATA POINT
CHART AREA
P. 4 2 0
2. CLICK ON FILL &
LINE BUTTON
1. DOUBLE CLICK
CHART AREA 3. SELECT GRADIENT FILL
4. SELECT PRESET GRADIENT
5. SELECT BOTTOM SPOTLIGHT – ACCENT 5
GOAL SEEK
P. 4 2 2
2. CLICK DATA TAB
3. CLICK WHAT-IF ANALYSIS
4. CLICK GOAL SEEK
1. SELECT CELL THAT MUST
CONTAIN DESIRED RESULT
5. DESIRED RESULT CELL REFERENCE
6. DESIRED VALUE
7. CELL TO BE CHANGED REFERENCE
8. CLICK OK
9. RESULT REACHED STATUS
10. CLICK OK
CALCUL ATIONS
P. 4 2 7
ORDER OF OPERATIONS
1. Parentheses
2. Exponents
3. Multiplication / Division
4. Addition / Subtraction
5. Same level of precedence are calculated from left to right
USING
PARENTHESES
P. 3 2 7
2. ENTER FORMULA
& PRESS ENTER TO
CACULATE RESULT
3. FORMULA COPIED
1. SELECT CELL THAT MUST
DISPLAY THE RESULT
FORMAT PAINTER
P. 4 2 9
2. CLICK HOME TAB
3. CLICK FORMAT PAINTER
1. SELECT CONTAINING
FORMATTING TO COPY
4. SELECT CELL TO FORMAT
FORMATTING COPIED
CREATE LINE
CHART
P. 4 3 4
2. CLICK INSERT TAB
3. CLICK INSERT LINE OR AREA CHART
4. CLICK LINE WITH MARKERS
1. SELECT DATA FOR CHART
5. LINE CHART INSERTED
1. CHART TITLE UPDATED
2. CHART MOVED AND
SIZED TO A8:F23
FORMAT LINE
CHARTS
A XIS
P. 4 3 6
2. CLICK CHART
TOOLS DESIGN TAB
3. CLICK SELECT DATA
5. SELECT DATA X-AXIS LABELS
4. CLICK EDIT
6. CLICK OK
1. SELECT X-AXIS ON CHART
3. CLICK ON SERIES
OPTIONS BUTTON
4. SET MINIMUN
BOUND TO 4 000 000
5. SET MAJOR UNITS
TO 2 000 000
2. RIGHT CLICK Y-AXIS AND
SELECT FORMAT AXIS
1. SELECT Y-AXIS ON CHART
CHART AREA
P. 4 3 9
2. CLICK ON FILL &
LINE BUTTON
3. CLICK PICTURE OT
TEXTURE FILL
5. BROWSE FOR AND
SELECT FILE 4. CLICK FILE
1. DOUBLE CLICK CHART
AREA
6. CLICK INSERT
PICTURE APPLIED TO CHART AREA
CHANGE CHART
T YPE
2. CLICK CHART
TOOLS DESIGN TAB
3. CLICK CHANGE
CHART TYPE
5. CLICK CHART TYPE
4. CLICK CHART CATEGORY
6. CLICK CHART STYLE
1. SELECT CHART
6. CLICK OK
CHART CHANGED
TO COLUMN CHART