cpsc 203 introduction to computers
Download
Skip this Video
Download Presentation
CPSC 203 Introduction to Computers

Loading in 2 Seconds...

play fullscreen
1 / 11

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 88 Views
  • Uploaded on

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.

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

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


An Image/Link below is provided (as is) to download presentation

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 203 introduction to computers

CPSC 203Introduction to Computers

T43, T46 & T68

TA: Jie (Jeff) Gao

introduction to excel
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
Excel – Interface
  • Menu, toolbars, scroll bars
  • Cell address bar, formula bar
  • Work space
  • Worksheet tabs and navigator

CPSC 203 Tutorials by Jie Gao

excel basic concepts
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
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
Excel – Cell Formatting
  • Font: face, style, size, colour
  • Background
  • Border
  • Alignment
  • Indentation
  • Orientation
  • Data type related

CPSC 203 Tutorials by Jie Gao

excel worksheets
Excel – Worksheets
  • Rename worksheets
  • Add a new worksheet
  • Delete a worksheet
  • Change worksheet orders

CPSC 203 Tutorials by Jie Gao

excel formulas
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
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
Excel – Useful Functions
  • Statistical
    • Min, Max, Average
  • Mathematical
    • Sum
  • Date and time
    • Now
  • More …

CPSC 203 Tutorials by Jie Gao

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

ad