ECDL 95/97 Module 4

ECDL 95/97 Module 4

By (author)  , By (author)  , By (author) 

List price: US$37.50

Currently unavailable

We can notify you when this item is back in stock

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Module 4 SpreadsheetsThis 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 ExercisesEverything you need to pass the European Computer Driving Licence module by moduleshow more

Product details

  • Paperback | 192 pages
  • 138 x 216mm | 301g
  • Pearson Education (US)
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130446386
  • 9780130446381

Table of contents

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 Unsuitable for financial amounts 111 The comma style 111 The currency style 112 The percent style 113 Changing from the general format 116 The number format 116 Toolbar buttons 117 Excel and dates 118 Entering dates 118 Formatting dates 119 Regional settings 120 Excel and text 120 Text across multiple columns 120 Entering numbers as text 121 Excel's autoFill feature 122 AutoFill and single numbers and text 124 AutoFill and number series 124 AutoFill and months, days, times and years 124 AutoFill and calculations 125 AutoFill and cell references 125 AutoFill keyboard shortcuts 127 Chapter summary: so now you know 128 chapter 6 Charting with Excel 129 In this chapter 129 New skills 129 New words 129 Charting: the two steps 131 The four dialog boxes to an Excel chart 131 Charts: two ideas you need to know 134 About data points 135 About data series 136 Single data series charts 136 Creating a multiple data series chart 137 Editing your chart 139 Changing chart data 139 Resizing the chart 139 Changing the chart title 140 Adding a chart title 140 Adding data labels 141 Formatting data labels 143 Changing the scale 143 Changing chart colours 145 Chart types 147show more

About Paul Holden

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.show more