Chapter 5. Spreadsheets

[ LiB ]  

Terms you'll need to understand:

  • Aggregate functions

  • AutoFill

  • Cells

  • Cell reference

  • Formula

  • Freeze

  • Function

  • Most-recently used (MRU) list

  • Spreadsheet

  • Unfreeze

  • Worksheet

Techniques you'll need to master:

  • Opening and closing spreadsheets

  • Creating a new spreadsheet

  • Navigating between spreadsheets and worksheets

  • Customizing spreadsheet settings

  • Adding and editing data

  • Searching for, replacing, and sorting data

  • Adding, removing, and copying worksheets

  • Creating formulas and using functions

  • Customizing cell formats

  • Creating charts and graphs

  • Printing spreadsheets

Another common business application is the spreadsheet . Spreadsheets present a rectangular grid into which you can enter and perform calculations on numbers ; they're important in just about every business. This module tests your familiarity with these basic facets of spreadsheet operation:

  • Opening and closing spreadsheets

  • Editing data

  • Managing worksheets

  • Performing calculations

  • Formatting data

  • Using charts and graphs

  • Printing spreadsheets

This chapter will help you review the skills that you need to pass this module of the ICDL.

Excel standard toolbar.

Excel formatting toolbar.

Excel chart toolbar.

[ LiB ]  


ICDL Exam Cram 2
ICDL Exam Cram 2
ISBN: 0789730928
EAN: 2147483647
Year: 2006
Pages: 142

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net