ECDL 95/97 Module 4
Addison Wesley (Verlag)
978-0-13-044638-1 (ISBN)
- Titel ist leider vergriffen;
keine Neuauflage - Artikel merken
Module 4 Spreadsheets
This module develops your understanding of the basic concepts of spreadsheets and will teach you how to use a spreadsheet application on a personal computer. You will develop the ability to accomplish basic operations associated with developing, formatting and using a spreadsheet, and to carry out standard mathematical and logical operations using basic formulas and functions. It also introduces some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.
Contains:
Computer terms and concepts explained in plain English
Screen images and illustrations to guide the student through the Microsoft Windows 95/98 and Microsoft Office 97 applications
"How to" information based upon practical examples of everyday tasks.
Short cuts and insider tips drawn from real world experience of computer professionals
Summary of critical information
Easy to follow Exercises
Everything you need to pass the European Computer Driving Licence module by module
Brendan Munnelly is an experienced IT trainer,consultant, journalist and author. Based in Dublin, Ireland, Brendan has developed user training materials for a range of corporate and government organisations throughout Europe. He is also a frequent contributor to computer publications.
Contents Introduction 1 Chapter 1 Your first steps in Excel 3 In this chapter 3 New skills 4 New words 4 Starting Excel 5 Worksheets and workbooks 5 Column letters: upper or lower case? 8 Entering numbers in cells 9 Why does Excel right-align numbers? 10 Entering text to a cell 11 Entering a cell reference in a cell 12 The ARROW keys 12 Editing the content of a cell 13 Dependent cells 13 F2: Excel’s EDIT key 14 Deleting the content of a cell 14 Deleting and the ENTER key 15 Deleting cell content – not the cell 15 Standard and formatting toolbars 15 Working with toolbars 16 Excel’s undo 16 Working with Excel workbooks 17 Saving your workbook 18 Creating a new workbook 19 Opening an existing workbook 19 Closing a workbook 19 Quitting Excel 20 Online help 20 Using help menu options 21 Using help from dialog boxes 22 Chapter summary: so now you know 23 chapter 2 Arithmetic with Excel 25 In this chapter 25 New skills 26 New words 26 Formulae in Excel 27 Formulae and arguments 28 Calculated cells 30 Adding down and across 31 Adding non-adjacent cells 32 Editing formulae 33 Combining operators 34 Formulae: using constants 35 Formulae: the rules of arithmetic 36 Fixed-factor calculations 37 Calculations and recalculations 40 Error Messages: when bad things happen 42 Excel’s zoom views 43 Zoom and printing 44 Saving to a diskette 44 Chapter summary: so now you know 45 chapter 3 Functions, formatting and printing 47 In this chapter 47 New skills 48 New words 48 Excel functions 49 The SUM function 49 Upper or lower case? 50 The AutoSum button 51 SUM tolerates text and spaces 52 The AVERAGE function 53 Formatting and aligning single cells 54 Formatting and aligning cell groups 55 Cancelling a selection 56 Cell ranges 56 Non-adjacent cell range 57 Selected cells and the active cell 59 F8: Excel’s SELECT key 59 Selecting columns and rows 60 Deleting rows and column contents 60 Selecting the entire worksheet 61 Adjusting column width and row height 61 Vertical alignment 63 Orientation 64 Fonts 65 Font sizes 66 Font colours 66 Cell borders 67 Cell colour backgrounds 68 Finding cell content 70 Find options 70 Replacing cell content 71 Spell-checking 72 Page setup 74 Paper size 74 Orientation 74 Scaling 74 Margins 75 Gridlines and headings 75 Headers and footers 76 Printing options 78 Print preview 78 Print range options 79 Chapter summary: so now you know 81 chapter 4 Inserting, sorting and moving cells 83 In this chapter 83 New skills 84 New words 84 Inserting and deleting rows 85 Deleting rows 87 Inserting and deleting columns 87 Deleting columns 88 Inserting and deleting cells 89 Copying and pasting cell contents 89 About the clipboard 91 The flashing marquee 92 Cutting and pasting cell contents 94 Copying between worksheets and workbooks 95 Moving calculations 95 Cell references: the two kinds 98 Sorting: reordering cells by content 100 Symbols and special characters 104 Chapter summary: so now you know 105 chapter 5 More about numbers, text and calculations 107 In this chapter 107 New skills 108 New words 108 Numbers: the different formats 109 The general format 110 Zeros after the decimal point 110 Trailing zeros 110 Thousands separators 111 Currency symbols 111 Unsu
| Erscheint lt. Verlag | 29.10.2001 |
|---|---|
| Verlagsort | Boston |
| Sprache | englisch |
| Maße | 138 x 216 mm |
| Gewicht | 301 g |
| Themenwelt | Informatik ► Betriebssysteme / Server ► Windows |
| Informatik ► Weitere Themen ► Hardware | |
| ISBN-10 | 0-13-044638-6 / 0130446386 |
| ISBN-13 | 978-0-13-044638-1 / 9780130446381 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
