- 65 Views
- Uploaded on
- Presentation posted in: General

CPSC 203 Introduction to Computers

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 - - - - - - - - - - - - - - - - - - - - - - - - - -

CPSC 203Introduction to Computers

T59 & T64

TA: Jie (Jeff) Gao

- 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

- Menu, toolbars, scroll bars
- Cell address bar, formula bar
- Work space
- Worksheet tabs and navigator

CPSC 203 Tutorials by Jie Gao

- Columns, rows
- Cells
- Cell naming

- Data types
- “General”
- Number
- Currency
- Date/time
- Text

CPSC 203 Tutorials by Jie Gao

- 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

- Font: face, style, size, colour
- Background
- Border
- Alignment
- Indentation
- Orientation
- Data type related

CPSC 203 Tutorials by Jie Gao

- Rename worksheets
- Add a new worksheet
- Delete a worksheet
- Change worksheet orders

CPSC 203 Tutorials by Jie Gao

- 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

- 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

- Statistical
- Min, Max, Average

- Mathematical
- Sum

- Date and time
- Now

- More …

CPSC 203 Tutorials by Jie Gao

- Due: 2:00pm Jan 27
- 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