|
" ECDL3 for Microsoft Office 95/97. Module 4, Spreadsheets "
Brendan Munnelly and Paul Holden.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
786374
|
| Doc. No
|
:
|
b606389
|
| Main Entry
|
:
|
Brendan Munnelly and Paul Holden.
|
| Title & Author
|
:
|
ECDL3 for Microsoft Office 95/97. Module 4, Spreadsheets\ Brendan Munnelly and Paul Holden.
|
| Publication Statement
|
:
|
Harlow: Prentice Hall, 2002
|
| Page. NO
|
:
|
xiii, 178 pages : illustrations ; 22 cm
|
| ISBN
|
:
|
0130446386
|
|
|
:
|
: 9780130446381
|
| 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 147
|
| Subject
|
:
|
European Computer Driving Licence.
|
| Subject
|
:
|
Microsoft Excel (Computer file)
|
| Added Entry
|
:
|
Brendan Munnelly
|
|
|
:
|
Paul Holden
|
| Parallel Title
|
:
|
Spreadsheets
|
| |