cpsc 203 introduction to computers tutorial 03 and 29 by jie (jeff) gao

CPSC 203Introduction to Computers

Tutorial 03 and 29

By Jie (Jeff) Gao

27 & 28 September 2004 CPSC Tutorials by Jie Gao 2

Introduction to Excel

• Excel is a spreadsheet software

• Excel document – Workbook– Worksheets in workbook

• It is mainly used for calculating numbers, especially the repetition of same calculation on different numbers

27 & 28 September 2004 CPSC Tutorials by Jie Gao 3

Excel – Interface

• Menu, Toolbars, scroll bars

• Cell address bar, formula bar

• Work space

• Worksheet tabs and navigator

27 & 28 September 2004 CPSC Tutorials by Jie Gao 4

Excel – Basic Concepts

• Columns, rows• Cells

– Cell naming

• Data types– “General”– Number– Currency– Date/time– Text

27 & 28 September 2004 CPSC Tutorials by Jie Gao 5

Excel – Inputting Data

• Directly input – overwrites the old content

• Double click and input – keeps the old content

• Input in the formula bar• Fill handle

– Generate sequence– Copy data– Ctrl key to toggle

27 & 28 September 2004 CPSC Tutorials by Jie Gao 6

Excel – Cell Formatting

• Font: face, style, size, colour

• Background

• Border

• Alignment

• Indentation

• Orientation

• Data type related

27 & 28 September 2004 CPSC Tutorials by Jie Gao 7

Excel – Worksheets

• Rename worksheets

• Add a new worksheet

• Delete a worksheet

• Change worksheet orders

27 & 28 September 2004 CPSC Tutorials by Jie Gao 8

Assignment 2

• Input data and format worksheet

• Use formulas to calculate missing values (marked as “fill in”)

• Create charts– A pie chart– A multi-series chart

• E-mail hand in (see instructions) togaoj@cpsc.ucalgary.ca