Loading in 5 sec....

CPSC 203 Introduction to ComputersPowerPoint Presentation

CPSC 203 Introduction to Computers

- By
**marcy** - Follow User

- 70 Views
- Uploaded on

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

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

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

- Statistical
- Min, Max, Average

- Mathematical
- Sum

- Date and time
- Now

- More …

CPSC 203 Tutorials by Jie Gao

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

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

- 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

- 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

- 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

- 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

Download Presentation

Connecting to Server..