Pass ECDL4 Module 4

Pass ECDL4 Module 4

List price: US$14.22

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

The European Computer Driving Licence (ECDL) is an internationally recognised qualification for IT skills. There are 7 modules in total. Written in a lively but straightforward and easy-to-follow style, this book will be an indispensable guide for all students studying for the ECDL qualification. Module 4: Spreadsheets. This module covers the basic concepts of spreadsheets. You will learn how to use a spreadsheet application to keep records of numerical and financial data, perform calculations and what-if analyses, draw charts and graphs. Step-by-step ECDL
show more

Product details

  • Paperback | 96 pages
  • 189 x 247 x 6mm | 213g
  • Pearson Education Limited
  • PAYNE-GALLWAY PUBLISHERS
  • Harlow, United Kingdom
  • 1904467326
  • 9781904467328
  • 1,685,486

Table of contents

Chapter 4.1 What is a spreadsheet? Moving around the worksheet The Zoom tool Toolbars Changing defaults and preferences Using the Help functions Entering data Editing data Deleting the contents of a cell Inserting and deleting rows and columns Saving your work Chapter 4.2 Formulae Selecting Cells Formatting cell contents Inserting a border Entering formulae Automatic recalculation Standard error values Entering formulae by pointing Formatting numbers Chapter 4.3 Columns of Data Changing column widths Formatting decimals Adding column of numbers Renaming a worksheet Inserting and deleting sheets Copying a worksheet Moving worksheets Chapter 4.4 Functions The SUM function The AVERAGE function MAXand MIN functions The COUNT function Copying data between sheets Filling a series Hiding and unhiding rowns & columns Freezing row and column titles Unfreezing panes Opening several workbooks Saving under another name Saving as different file type Chapter 4.5 Charts Sorting data Drawing a bar chart Moving and sizing a chart Deleting the title Adding axis titles Changing the background colour Changing the colour of the bars Chapter 4.6 Pie Charts Creating a pie chart Formatting the data labels Copying and pasting the chart type Deleting a chart Chapter 4.7 Printing Printing a chart Printing an entire worksheet Printing a cell range Printing an entire workbook Printing row and column headings Printing the title row on each page Hiding/ Unhiding gridlines on printouts Printing row and column headers Paper Orientation Paper Size Changing the margins Preparation Chapter 4.8 Cell Referencing Relative and absolute cell referencing Calculating a percentage The currency format Merge and centre cell contents Adding a date field Wrapping cell content Adding borders Find and replace Headers and Footers Chapter 4.9 If...Then...Else Changing font style and size Adding the formulae IF statements Changing the font colour Changing the background fill colour Aligning dell content Cell content orientation
show more

Author information

Flora Heathcote is the author of many of Payne-Gallway's successful IT books including Basic Access, Further Access, Access Right from the Start and Dreamwaver Right from the Start.
show more