Cpsc 203 introduction to computers
Download
1 / 11

CPSC 203 Introduction to Computers - PowerPoint PPT Presentation


  • 70 Views
  • Uploaded on

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

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


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


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


Show formulas
Show Formulas

  • By default the spreadsheets only show formula results

  • Formula expressions can be shown in spreadsheets

    • Menu Tools  Options, View tab, check option Formulas

    • Uncheck it to return to formula result view

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


Excel cell references
Excel – Cell References

  • Range

    • Named by the cells on upper left and lower right corners

    • Custom names can be provided in the name box

  • Relative

  • Absolute

    • Use “$” to indicate absolute references

CPSC 203 Tutorials by Jie Gao


Excel chart wizard
Excel – Chart Wizard

  • “Insert Chart” button or “Insert  Chart” menu

  • 4 steps

    • Select chart type

    • Define source data and series

    • Chart options: labels, legend and axes

    • Create chart as: object or sheet

CPSC 203 Tutorials by Jie Gao


Excel tricks in chart wizard
Excel – Tricks in Chart Wizard

  • Select source data range before starting the wizard

  • Specify the series names and labels by cell references

  • Make use of the preview

CPSC 203 Tutorials by Jie Gao


Excel modify charts
Excel – Modify Charts

  • Text elements: Use the format buttons directly

  • Size and position: Use handles to adjust

  • Other appearance: Right click and use “Format …” menu

  • The 4 steps of chart wizard also have corresponding menu items

CPSC 203 Tutorials by Jie Gao


Excel page setup
Excel – Page Setup

  • Each worksheet has separate page setups

  • Paper size, orientation, margin

  • Header and footer

  • Show gridlines or not

  • Print preview

CPSC 203 Tutorials by Jie Gao


Assignment 1
Assignment 1

  • Remember: it contains 3 parts

  • It is not required to fit the spreadsheets into single pages

  • Make sure you have your official name and tutorial section number on the pages

    • A cover page is not required for this assignment

CPSC 203 Tutorials by Jie Gao


ad