Docstoc

test_xlsx

Document Sample
test_xlsx Powered By Docstoc
					This document covers all features.

Font                                       Calibri            Arial        ComicSansMS




Font size                                Calibri 6            Calibri 11   Calibri 48
Bold                                       This text is boldfaced

Italics and underline                      Italics and underline

Text color/Fill color                      Red on light blue

Solid/Dashed board                         solid                           dashed

Shading

Strikethrough                              Strikethrough

                                         Superscript
Superscript/Subscript                                         Subscript


                         Te
                              xt
                                 rot
                                    at
                                      ed
                                           -4
                                                4
                                                    de
                                                      gr
                                                        ee
Rotated text                                              s
                                A small
                                US study
                                has found
                                a link
                                between
                                consumpti
                                on of
                                "energy
                                drinks"
                                and high
                                blood
                                pressure
                                or heart
                                disease
Wrapped text                    risk.

Autofit to cell                             Autofit to this cell

                                                                           Right and top
                                 center
Horizontal/Vertical alignment               Left and bottom


                                            Three default row
Row height                                  heights

Column width                                This column is fitted to cell C25

Hidden text

Merged cells                          Cell B35-D35 are merdged and centered.
ri 48
Number                        12345.00
Number negative             (12345.00)
Currency                    $12,345.00
Currency negative          -$12,345.00
Accounting               $ 12,345.00
Sceintific                    1.23E+04
Percentage               1234500.00%
Date                        11/9/2007
Time                      11:24:00 AM
Fraction                           3/5
Custom (;;;-hidden)
Special                  000-01-2345
Conditional formatting         12345 (if value is equal to '12345')


                                   26
References          sum(G2:G9)                                 72

3D references       C2*Number formatting!B2               888840

Names for recalc    average(Data)                    5.571428571

Formula auditing    To show formulas select Formulas tab->Formula auditing->Show formula button


        2          8
        3          9
        7          8
        8          3 Range named 'Data'
        9          4
        0          5
        5          7

Array formulas
 Sales                                                              Total
 Person Car Type           Number Sold             Unit Price       Sales      Array formula
 Barnhill Sedan                               5          2200       11000   {C21:C30*D21:D30}
            Coupe                             4          1800        7200   {C21:C30*D21:D30}
 Ingle      Sedan                             6          2300       13800   {C21:C30*D21:D30}
            Coupe                             8          1700       13600   {C21:C30*D21:D30}
 Jordan     Sedan                             3          2000        6000   {C21:C30*D21:D30}
            Coupe                             1          1600        1600   {C21:C30*D21:D30}
 Pica       Sedan                             9          2150       19350   {C21:C30*D21:D30}
            Coupe                             5          1950        9750   {C21:C30*D21:D30}
 Sanche Sedan                                 6          2250       13500
 z                                                                          {C21:C30*D21:D30}
            Coupe                             8           2000      16000   {C21:C30*D21:D30}
 1
 4
 3
 7
54
 3
Charts

           0        1                                                  y=cos(x)
           1 0.707107
                                                                               Series1
           2 6.13E-17
           3 -0.70711                 1.5
           4       -1                   1
           5 -0.70711
           6 -1.8E-16                 0.5
           7 0.707107                   0
           8        1
                                             1    2      3       4         5     6       7   8   9
           9 0.707107                 -0.5
          10 3.06E-16                  -1

                                      -1.5


Grouping
Rows 19-22 are grouped, so they could be expanded or collapsed




ColumnsF-H are grouped together, so they could be collapsed or expanded.

Filters
            Person      Work city
            Mario       Youngsville
            Mario       Youngsville
            Mario       Youngsville
            Mario       Youngsville
            Adrian      Easton
            Adrian      Easton
            Adrian      Easton
            Adrian      Easton
            John        Bend
            John        Bend
            John        Bend

Image
Word art




Comments
              Cell w comment


Range protection




              This range is locked for editing
              and selection




To unlock cells, unprotect the worksheet first and then unlock the range.

Text box
               Inside out

               Understanding Display
               Order Rules for Categories
               and Groups

Pivot table

Person        Town          Order
John          Easton             1825                    Row Labels         Sum of Order
Douglas       Easton             1436                    Adrian                      2350
Adrian        Elias               349                      Elias                     2350
Daniel        Elias               678                    Daniel                      4140
Mario         Bend                134                      Elias                     4140
Paul          Bend               3113                    Douglas                     1436
Mario         Bend               1825                      Easton                    1436
John          Easton              134                    John                        1959
Adrian        Elias               678                      Easton                    1959
Mario         Bend                678                    Mario                       2637
Adrian        Elias              1323                      Bend                      2637
Daniel         Elias         3113                          Paul           3113
Daniel         Elias          349                          Grand Total   15635

Data validation
Only the whole number greater than 100 could be entered in A102:D018.

         123

                       444




                              101

Track changes

It will track all changes that have been made to this highlighted
range

The changes will be highlighted on the screen

In order to see all changes on the separate sheet select Review tab
Track changes->Highlight changes->List changes on a new sheet
10   11
Quickoffice Inc.                             6/16/2010      2613b799-3f51-4f67-a98c-28fd2d72b2d9.xlsx

Column
to repeat
Row to repeat on every page   Row to repeat on every page    Row to repeat on every page
Column
to repeat
Column
to repeat
Column
to repeat
Column
to repeat
Column
to repeat
Column
to repeat
Column
to repeat
Column
to repeat




                                            page 11 of 17
Quickoffice Inc.                             6/16/2010      2613b799-3f51-4f67-a98c-28fd2d72b2d9.xlsx

Row to repeat on every page   Row to repeat on every page    Row to repeat on every page




                                            page 12 of 17
Quickoffice Inc.                             6/16/2010      2613b799-3f51-4f67-a98c-28fd2d72b2d9.xlsx

Row to repeat on every page   Row to repeat on every page    Row to repeat on every page




                                            page 13 of 17
Quickoffice Inc.                             6/16/2010      2613b799-3f51-4f67-a98c-28fd2d72b2d9.xlsx

Row to repeat on every page   Row to repeat on every page    Row to repeat on every page




                                            page 14 of 17
Quickoffice Inc.                             6/16/2010      2613b799-3f51-4f67-a98c-28fd2d72b2d9.xlsx

Row to repeat on every page   Row to repeat on every page    Row to repeat on every page




                                            page 15 of 17
This portion of the sheet visible while   Zoom level is et to 85 %.
the rest of the sheet scrolls             Document should open with this cell




Row 10, 11, 12 are hidden.                Sort settings

                                                                 Second, Z toFirst,
                                                     Third, Smallest ot largestA Blue color on top
                                                              5k                     40
                                                              5f                     20
                                                              8h                     30
                                                              9I                     90
                                                             10 w                    60
                                                             10 S                    70
                                                             36 s                   100
                                                             42 a                    10
                                                             77 a                    80
                                                            100 i                    50
                                                            710 H                   110


                                                     Sorting as follows: First, Second and Third
               selected.




                           Columns K, L, and M are hidden too.




color on top

				
DOCUMENT INFO
Categories:
Stats:
views:19
posted:6/16/2010
language:English
pages:17