{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

nematology_pracexcel

# nematology_pracexcel - Exercise excel Introduction to Excel...

This preview shows pages 1–2. Sign up to view the full content.

Exercise excel Prof. Dr. Ann Vanreusel 5/10/2009 1 Introduction to Excel Excel is a spreadsheet program that allows to order, to process and to save in rows (1,2,3,. .), columns (A, B, C etc) and sheets (sheet 1, sheet 2,. .) numerical data. Each unit (number, formula, text) is placed in a cell which is indicated by a row number and a column letter, and if more than 1 sheet by a sheet label. By means of this exercise we get insight in the basic principles of this type of programs. In order to start with other statistical programs it is important to know this type of program, because without thorough knowledge of excel the use of other statistical programs is rather difficult and complex A few functions will be explicitly shown in this exercise but others can be looked for by means of the Help function and/or the toolbars. Start by filling in the following dataset on the first worksheet. Put the species in rows and the stations in columns. Species names and station labels are filled in respectively on the first row and first column. menubar toolbars cel content - calculate at bottom of the data matrix the total amount of organisms per station ( function in toolbar or type: =sum(cell 1 st row:cell last row) - FORMULAS can be filled in the cell where one wants to see the result. A formula is always preceded by = . Each new operation within the formula, is delineated by brackets. In this way rather complex calculations can be done in one movement. Some basic operations are: sum, - subtraction, / division, * multiplication, ^ exponent. - A formula can be copied from 1 cell to all other possible adjacent cells by holding the square in the right corner at the bottom of the cell (a 'handler'). When the cursor changes into a small cross you can drag the formula to the other cells you wish. You can also simple copy and paste the formula. Take into account that the formulas that you are using are relative in the sense that each time you drag the content of the cell, the

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

nematology_pracexcel - Exercise excel Introduction to Excel...

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

View Full Document
Ask a homework question - tutors are online