CPSC 203 Introduction to Computers

1 / 11

# CPSC 203 Introduction to Computers - PowerPoint PPT Presentation

CPSC 203 Introduction to Computers. T43, T46 &amp; T68 TA: Jie (Jeff) Gao. 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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' CPSC 203 Introduction to Computers' - neena

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### CPSC 203Introduction to Computers

T43, T46 & T68

TA: Jie (Jeff) Gao

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

CPSC 203 Tutorials by Jie Gao

Excel – Interface
• Cell address bar, formula bar
• Work space
• Worksheet tabs and navigator

CPSC 203 Tutorials by Jie Gao

Excel – Basic Concepts
• Columns, rows
• Cells
• Cell naming
• Data types
• “General”
• Number
• Currency
• Date/time
• Text

CPSC 203 Tutorials by Jie Gao

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

CPSC 203 Tutorials by Jie Gao

Excel – Cell Formatting
• Font: face, style, size, colour
• Background
• Border
• Alignment
• Indentation
• Orientation
• Data type related

CPSC 203 Tutorials by Jie Gao

Excel – Worksheets
• Rename worksheets
• Delete a worksheet
• Change worksheet orders

CPSC 203 Tutorials by Jie Gao

Excel – Formulas
• Formulas are calculation expressions
• Starts with a “=“
• The formula expression is shown in the formula bar but the formula result is shown in worksheet
• Examples

CPSC 203 Tutorials by Jie Gao

Excel – Functions
• Functions are predefined formulas
• They are organized in categories
• Use the “Paste function” button or “Insert  Function” menu
• Choose function
• Provide arguments
• Input by hand
• Pick by mouse

CPSC 203 Tutorials by Jie Gao

Excel – Useful Functions
• Statistical
• Min, Max, Average
• Mathematical
• Sum
• Date and time
• Now
• More …

CPSC 203 Tutorials by Jie Gao

Assignment 1
• Due: Jan 28, Friday 4:00pm
• 3 Parts:
• Follow steps on EX-176 to EX-197 (NOT EX-198) to get a payment schedule
• The payment schedule with formula expressions shown
• A chart showing Principal Paid and Interest Paid for the last 12 months (any suitable chart type is OK)

CPSC 203 Tutorials by Jie Gao