nematology_pracexcel - Exercise excel Introduction to Excel...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/28/2010 for the course WE BIBI010000 taught by Professor Marnikvuylsteke during the Spring '10 term at Ghent University.

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 Right Arrow Icon
Ask a homework question - tutors are online