BIS3589_ch01 - Sorting one factor many factors Autofilter...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 1 Spreadsheet Basic
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Selecting the range of cell    Contiguous cells   Click and drag   Use Shift key    Discontiguous cells    Use Ctrl key
Background image of page 2
Formatting and Alignment option    Font      Typeface    Typesize    Alignment    Left, Right, Center   Center across selection   Merge and center    Number formatting    1000 separator,  decimal place   Custom format
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Mathematical operators priority     (…) (parenthesis)         ^ (exponentiation)     * (multiplication), / (division)     + (addition), - (subtraction)
Background image of page 4
Formula    Copying and moving formula   copying    formula adjusting with relative cells   moving    formula exactly the same    Build-in function    SUM      AVERAGE   arithmetic mean   GEOMEAN   geometric mean    Function place holder
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Manage lists of data
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sorting one factor many factors Autofilter Creating graphics (chart) Chart place Chart in separate window Embedded chart Chart option chart title title for X-axis and Y-axis Printing Print preview Set print area Page setup Orientation Scaling Other topics Saving and opening fle Save Save as Open Save as webpage Using with others OLE (object linking and embedding Self-Test (1+k) n D + P = (D + P)/(1+K)^n (1+k) D = D /(1+K) P D = D /P + K + g Self-Test k g D (1 + g) 1 + g 1 -1 + k n = (D*(1+g))/(k-g) = 1-((1+g)/(1+k))^n Self-Test (1 + k) n k g D (1 + g) n (1 + g) = ((D*(1+g)^n*(1+g)) /(k-g))/(1+k)^n...
View Full Document

Page1 / 12

BIS3589_ch01 - Sorting one factor many factors Autofilter...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online