1 / 11

# CPSC 203 Introduction to Computers - PowerPoint PPT Presentation

CPSC 203 Introduction 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.

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

• 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

• 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