Formula Bar A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE

Formula bar a b c d e f g h i j k l m n o p q r s t u

This preview shows page 19 - 40 out of 41 pages.

Formula Bar A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB AC
Image of page 19
AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV 1 2 3 4 Product Cost Markup Rate Retail Price Percent Of Sale Price Profit Amount Profit Margin 5 Electronics 6 OK Office Systems Pricing Information 9/1/2016
Image of page 20
Computer System 475.5 0.5 713.25 0.15 606.2625 130.7625 7 Color Laser Printer 457.7 0.755 803.2635 0.2 642.6108 184.9108 8 28" Monitor 195 0.835 357.825 0.1 322.0425 127.0425 9 Furniture 10 Desk Chair 75 1 150 0.25 112.5 37.5 11 Solid Oak Computer Desk 700 1.857 1999.9 0.3 1399.93 699.93 12 Executive Desk Chair 200 1 0.499975 0.333333 0.39449 0.287749 0.215686
Image of page 21
400 0.25 300 100 13 14 15 16 17 0.333333
Image of page 22
18 19 20 21 22 23 24 25 26
Image of page 23
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
Image of page 24
47 48 49 A B C D E F G H I J K L M N O P Q R
Image of page 25
S T U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV 1
Image of page 26
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
Image of page 27
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 READY
Image of page 28
100% SUM: COUNT: AVERAGE: READY 100% SUM: COUNT: AVERAGE: Width: 8.43 (64 pixels) Cut C opy Paste Options: 0 Paste (P) Paste (P) Paste (P) Paste (P) Values (V) Values (V) Formulas (F) Formulas (F) Transpose (T) Transpose (T) Formatting (R) Formatting (R) Paste Link (N) Paste Link (N) Paste S pecial... Paste S pecial... Paste Paste (P) P Formulas (F) F Formulas & Number Formatting (O) O Keep Source Formatting (K) K No Borders (B) B Keep Source Column Widths (W) W Transpose (T) T Paste Values Values (V)
Image of page 29
V Values & Number Formatting (A) A Values & Source Formatting (E) E Other Paste Options Formating (R) R Paste Link (N) N Picture (U) U Linked Picture (I) IPaste Special... Paste Special... Insert... Insert Insert Delete... Delete Delete Clear Contents Quick Analysis Edit Group Location & Data... Edit Single Sparklines's Data... Group Ungroup Clear Selected Sparklines Clear Selected Sparkline Group Sparklines Filter Sort Insert Comment Format Cells... PickFrom Drop-down List... Define Name... Hyperlink... Insert Page Break Reset All Page Breaks Set Print Area Reset Print Area Page Setup... Column Width... Row Height... Hide Unhide Hide Unhide Bold (Ctrl + B)Italics (Ctrl + I)CenterFill Color Theme ColorsStandard ColorsNoFillMore Colors...Font Color Bottom Border Increase DecimalDecrease DecimalFormat PainterMerge & CenterComma StylePercent Style (Ctrl+Shift+%)Accounting Number Format Decrease Font SizeIncrease Font Size
Image of page 30
Image of page 31
September New Sheet
Image of page 32
Image of page 33
Image of page 34
Image of page 35
R e s e t Q u e s t i o n s 2 1 o f 2
Image of page 36
Image of page 37
Image of page 38
Image of page 40

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture