Writing Formulae with Microsoft Excel 2002

Short Description
series in Task 1. Click on C9 again, and note that the formula bar. shows the Excel function that was used in the calculation. Point to the …

Website: www.leeds.ac.uk | Filesize: 431kb

Content
UNIVERSITY OF LEEDS
TUT 47
A Tutorial for Excel 2002 for Windows
INFORMATION SYSTEMS SERVICES
Writing Formulae with Microsoft Excel 2002
EDITION: 2.0
DATE: August 2004
AUTHOR: Information Systems ServicesContents
1.0 Introduction……………………………………………………………………………1
1.1 About Spreadsheet Software……………………………………………………….1
1.2 Prerequisites……………………………………………………………………………1
Task 1 Using Series……………………………………………………………………………………..2
2.0 Formulae………………………………………………………………………………..4
2.1 Functions……………………………………………………………………………….4
2.2 Layers…………………………………………………………………………………….5
Task 2 Simple Calculations…………………………………………………………………………..6
Task 3 Copying Formulae…………………………………………………………………………….7
Task 4 Using Insert Function…………………………………………………………………………8
2.3 Relative and Absolute Cell Addressing………………………………………….9
Task 5 Using Absolute Cell Addressing………………………………………………………..10
Task 6 Statistical Functions…………………………………………………………………………11
Task 7 Ranges……………………………………………………………………………………………13
Task 8 Using an Array Formula…………………………………………………………………..14
Task 9 Finishing Excel………………………………………………………………………………15
Format Conventions
In this document the following format conventions are used:
Menu items are given in a bold, Arial font.
Windows Applications
Keys that you press are enclosed in angle brackets.

Feedback
If you notice any mistakes in this document please contact the Information Officer. Email should be sent to the address info-officer@leeds.ac.uk
Copyright
This document is copyright University of Leeds. Permission to use material in this document should be obtained from the Information Officer (email should be sent to the address info-officer@leeds.ac.uk)
ii…