word - 2010 - advanced - part - i

word - 2010 - advanced - part - i

(Parte 4 de 10)

Real work

International opportunities ree work placements al Internationa or ree wo

I wanted real responsibili I joined MITAS because

Please click the advert

Download free ebooks at bookboon.com Word 2010 Advanced: Part I

Advanced tables

The table above is currently in alphabetical order by Country. Supposing you wanted to sort the table by Year, and where the year is the same, you want it sub-sorted by Investment.

ӹTo sort the table: Mouse

1. Select the table. 2. Under TABLE TOOLS, on the LAYOUT ribbon, in the DATA group, click SORT. 3. In the SORT dialog box, select the options that you want.

4. Choose the main SORT BY column from the drop-down list. 5. Select the TYPE of information in that column (Text, Number or Date). 6. Choose the SORT ORDER (Ascending or Descending). 7. Repeat this process in the THEN BY field if you are sub-sorting.

The table from the previous page would now appear like this:

COUNTRY YEAR INVESTMENT Albania 1998 £1,867,659.0 Romania 1998 £867,482,475.0

Download free ebooks at bookboon.com Word 2010 Advanced: Part I

Advanced tables

Header Row

• The first row in the table will not be included in the sort, and the text in the cells of that row will appear as choices in the Sort by/Then by fields. No Header Row

• All the rows will be included in the sort, and you select the column number to sort by (rather than the names). The choice here depends on whether your table has headings in the first row:

Sort A Single Column In A Table

If you just wish to sort the data in one column while leaving the data in all other columns unchanged then we need to select that column and change a setting.

ӹTo sort a single column Mouse

1. Select the column that you want to sort. 2. Under TABLE TOOLS, on the LAYOUT ribbon, in the DATA group, click SORT.

3. Under MY LIST HAS, click HEADER ROW or NO HEADER ROW. 4. Click OPTIONS. 5. Under SORT OPTIONS, select the SORT COLUMN ONLY check box. 6. Click OK.

Sort By More Than One Word Or Column Inside A Table.

To sort the data in a table that is based on the contents of a column where it includes more than one word, you must first use characters to separate the data — including data in the header row.

• E.G. if the cells in a column contain both last and first names, you can use commas to separate the names.

Download free ebooks at bookboon.com Word 2010 Advanced: Part I

Advanced tables ӹTo sort a table by multiple columns Mouse

1. Select the column that you want to sort. 2. Under TABLE TOOLS, on the LAYOUT ribbon, in the DATA group, click SORT. 3. Under MY LIST HAS, click HEADER ROW or NO HEADER ROW.

4. Click OPTIONS. 5. Under SEPARATE FIELDS AT, click the type of character that separates the words or fields that you want to sort. 6. Click OK to close dialog 7. In the SORT dialog under SORT BY, in the USING list, select which word or field you want to sort by.

By 2020, wind could provide one-tenth of our planet’s electricity needs. Already today, SKF’s innovative knowhow is crucial to running a large proportion of the world’s wind turbines.

Up to 25 % of the generating costs relate to maintenance. These can be reduced dramatically thanks to our systems for on-line condition monitoring and automatic lubrication. We help make it more economical to create cleaner, cheaper energy out of thin air.

By sharing our experience, expertise, and creativity, industries can boost performance beyond expectations.

Therefore we need the best employees who can meet this challenge!

The Power of Knowledge Engineering

Brain power

Plug into The Power of Knowledge Engineering. Visit us at w.skf.com/knowledge

Please click the advert

Download free ebooks at bookboon.com Word 2010 Advanced: Part I

Advanced tables

8. In the first THEN BY list, enter the column that contains the data that you want to sort by, and then in the

USING list, select which word or field you want to sort by. 9. If you want to sort by an additional column, repeat this step in the second THEN BY list. 10. Click OK to apply sort

Table formulas

You can write formulae inside table cells to perform common calculations. You can use A1, B1-style references as you might in an Excel spreadsheet. However, you are not able to create relative cell references, therefore formulas cannot be copied across a row or down a column.

ӹTo create a formula: Mouse

1. Position the mouse in the cell you wish to create a formula.

2. Under TABLE TOOLS, on the LAYOUT ribbon, in the DATA group, click FORMULA. 3. Word may automatically suggest a formula, which you can overwrite. Use the = sign to begin the formula and the same mathematical operators as are used in Excel ( ,-,*,/).

Download free ebooks at bookboon.com Word 2010 Advanced: Part I

Advanced tables

4. Use A1 style references to cells within the table - you will have to work out which reference will apply to each cell you are referring to. In the example above, the profit has been worked out using the formula =B2- B3, and assigning a currency number format to get the £ sign.

Formatting Numbers

(Parte 4 de 10)

Comentários