ECDL L1 Spreadsheet Software Excel 2010 S1.0 V1
ECDL European Computer Driving Licence Spreadsheet SoftwareBCS ITQ Level 1Using Microsoft Excel 2010Syllabus Version 1.0This training, which has been approved by BCS, includes exerciseitems intended to assist learners in their training for a BCS or ECDLCertification Programme. These exercises are not certification tests. Forinformation about how to take a certification test and to find ApprovedCentres in the UK, please refer to the BCS website atwww.bcs.org/qualifications.Release ITQ151v1
Spreadsheet SoftwareECDLContentsSKILL SET 1 FUNDAMENTALS. 111 - SPREADSHEET PRINCIPLES . 122 - STARTING EXCEL . 133 - THE LAYOUT OF THE EXCEL SCREEN . 144 - THE RIBBON. 165 - THE WORKSHEET WINDOW . 186 - CLOSING EXCEL . 197 - DEVELOP YOUR SKILLS. 20SUMMARY: FUNDAMENTALS . 21SKILL SET 2 OPEN, SAVE AND CLOSE WORKBOOKS. 228 - OPENING A WORKBOOK . 239 - MOVING AROUND A WORKSHEET . 2510 - SHEET TABS . 2611 - CLOSING A WORKBOOK . 2712 - SAVING A NAMED WORKBOOK . 2813 - DEVELOP YOUR SKILLS. 29SUMMARY: OPEN, SAVE AND CLOSE WORKBOOKS . 30SKILL SET 3 CREATING A WORKSHEET . 3114 - SPREADSHEET STRUCTURE . 3215 - CREATING A SPREADSHEET . 3316 - STARTING A NEW WORKBOOK . 3417 - ENTERING LABELS . 3518 - ENTERING NUMBERS. 3619 - INSERTING AN IMAGE . 3720 - SAVING A NEW WORKBOOK. 3821 - DEVELOP YOUR SKILLS. 39SUMMARY: CREATING A WORKSHEET . 40SKILL SET 4 EDITING CELLS . 4122 - OVERTYPING . 4223 - EDITING CELL CONTENTS. 4324 - COPYING CELLS . 4425 - FINDING TEXT . 4626 - REPLACING TEXT . 4727 - DELETING CELL CONTENTS. 4828 - UNDO AND REDO . 4929 - DEVELOP YOUR SKILLS. 50SUMMARY: EDITING CELLS . 51SKILL SET 5 FORMULAS. 5230 - INTRODUCING FORMULAS . 5331 - MATHEMATICAL OPERATORS. 54 CiA Training Ltd 20138Excel 2010
ECDLSpreadsheet Software32 - SELECTING CELLS WITH THE MOUSE . 5533 - THE SUM FUNCTION . 5634 - THE AVERAGE FUNCTION . 5735 - THE ROUND FUNCTION . 5836 - USING THE FILL HANDLE TO COPY . 5937 - COPYING FORMULAS . 6038 - BRACKETS . 6239 - CHECKING FORMULAS . 6440 - DEVELOP YOUR SKILLS. 66SUMMARY: FORMULAS . 67SKILL SET 6 PRINTING. 6841 - INTRODUCTION TO PRINTING. 6942 - PRINT PREVIEW . 7043 - PRINT SETTINGS . 7144 - CHANGING PAGE MARGINS . 7345 - PAGE ORIENTATION . 7446 - HEADERS AND FOOTERS . 7547 - SPELL CHECKING . 7748 - PRINTING WORKSHEETS . 7849 - DEVELOP YOUR SKILLS. 79SUMMARY: PRINTING . 80SKILL SET 7 FORMATTING WORKSHEETS . 8150 - CHANGING COLUMN WIDTHS. 8251 - CHANGING ROW HEIGHT . 8352 - INSERTING ROWS AND COLUMNS . 8453 - DELETING ROWS AND COLUMNS . 8654 - DEVELOP YOUR SKILLS. 87SUMMARY: FORMATTING WORKSHEETS . 88SKILL SET 8 FORMATTING CELLS. 8955 - FORMAT CELLS . 9056 - FORMAT NUMBER . 9157 - CURRENCY . 9358 - PERCENTAGES . 9459 - FONTS AND FONT SIZE . 9560 - DATE AND TIME . 9661 - ALIGNMENT . 9762 - BORDERS AND SHADING . 9863 - DEVELOP YOUR SKILLS. 101SUMMARY: FORMATTING CELLS . 102SKILL SET 9 SUMMARISING DATA. 10364 - ORGANISING DATA. 10465 - SORTING DATA . 10566 - SUMMARISING DATA . 106Excel 20109 CiA Training Ltd 2013
Spreadsheet SoftwareECDL67 - DEVELOP YOUR SKILLS. 107SUMMARY: SUMMARISING DATA . 108SKILL SET 10 INTRODUCTION TO CHARTS . 10968 - INTRODUCTION TO CHARTS . 11069 - CREATING A QUICK CHART . 11170 - CREATING AN EMBEDDED CHART . 11271 - MOVING AND RESIZING CHARTS . 11472 - DEVELOP YOUR SKILLS. 115SUMMARY: INTRODUCTION TO CHARTS . 116SKILL SET 11 CHART TYPES . 11773 - TYPES OF CHART . 11874 - PIE CHARTS. 11975 - LINE CHARTS . 12076 - BAR CHARTS . 12177 - DEVELOP YOUR SKILLS. 122SUMMARY: CHART TYPES . 123SKILL SET 12 FORMATTING CHARTS . 12478 - PARTS OF A CHART . 12579 - CHART TITLES. 12680 - AXIS TITLES . 12781 - CHART LEGENDS . 12882 - ADDING DATA LABELS . 12983 - EDITING CHART DATA . 13084 - FORMATTING CHARTS . 13185 - PRINTING CHARTS . 13386 - DEVELOP YOUR SKILLS. 134SUMMARY: FORMATTING CHARTS. 135ANSWERS . 136GLOSSARY . 141INDEX . 143 CiA Training Ltd 201310Excel 2010
ECDLSpreadsheet SoftwareSkill Set 1FundamentalsBy the end of this Skill Set you should be able to:Understand Spreadsheet PrinciplesStart Microsoft ExcelUnderstand the Screen LayoutUnderstand the Ribbon and Quick Access ToolbarUnderstand the Worksheet WindowExit ExcelExcel 201011 CiA Training Ltd 2013
Spreadsheet SoftwareECDLExercise 1 - Spreadsheet PrinciplesKnowledge:A spreadsheet package is a computer program created specifically to help in theprocessing of tabular information, usually numbers. The spreadsheet storesinformation in rows (across the screen) and columns (down the screen), forming aWorksheet (the Excel term for a spreadsheet). Several worksheets are boundtogether (three initially) to form a Workbook, the name Excel gives to a saved file.Spreadsheets are most commonly used to manipulate figures. They can be usedin:AccountingCash flowsBudgetsForecasts, etc.Any job involving the use of numbers can be done on a spreadsheet.The biggest advantage that a spreadsheet has over other methods of manipulatingdata - using a table in a word processing application for example, is its ability toconstantly update figures without the user having to do any calculations. Once aspreadsheet is set up correctly, its calculations will always be correct and anychanges in data are recalculated automatically.Spreadsheets can also take basic data and present it in an attractive way, forexample as formatted lists, tables and graphs.Cells can contain, text (labels), numbers or formulas. The relationship betweenLabels, Numbers and Formulas is shown below (remember this is a typicalexample of a table - cell contents can be arranged in other ways). CiA Training Ltd 201312Excel 2010
ECDLSpreadsheet SoftwareExercise 2 - Starting ExcelKnowledge:Microsoft Excel is a spreadsheet program that is part of the Microsoft Office suite ofapplications. Excel can be started by selecting its entry from the Start menu.Activity:1.When the computer is started, the Windows Desktop is automaticallydisplayed.2.Click once on the Start button,, in the bottom left corner of thescreen, to show the list of options available.3.Move to All Programs and then click Microsoft Office.4.Click Microsoft Excel 2010. The application will open and the Excel windowwill appear.Note:You can also open Excel by searching for and selecting its name using theWindows search feature (available on the Start Menu).Note:If an icon for Excel is available on the Desktop, you can double-click this tolaunch the program.Excel 201013 CiA Training Ltd 2013
Spreadsheet SoftwareECDLExercise 3 - The Layout of the Excel ScreenKnowledge:When the Excel screen (window) appears, the program displays a blank worksheet.Activity:1.The Excel screen will be similar to the picture below. Locate and familiariseyourself with all the features highlighted.Title BarQuick Access ToolbarFile tabRibbonViews and Zoom sliderStatus BarNote:Depending on your display settings, the screen you see may not appearexactly as shown above.2.The Title Bar is the top line of the Excel screen. It shows the applicationand the name of the workbook that is on the screen. Identify the Title Bar.3.The name of the current workbook is Book1 or similar. Check this in theTitle Bar.4.At the top left of the screen is the Quick Access Toolbar.5.By default this contains three buttons, Save, Undo and Redo. More buttonscan be added to this toolbar. CiA Training Ltd 201314Excel 2010
ECDLSpreadsheet SoftwareExercise 3 - Continued6.Under this toolbar is an area called the Ribbon. This consists of a range oftabs, containing buttons within groups (used to select commands in Excel).7.The Home tab is displayed by default, if it is not then click on the Home tab.The buttons are used to select an action or basic feature. Move the cursorover any button but do not click. Read the ToolTip, which gives the name ofthat button, with a small description, e.g. Italic in the Font group.8.The File tab contains a list of basic program functions such as; Open, Save,Print and Close. Click on the File tab,options.to display a list of the9.Display the Home tab.10.The Status Bar runs along the bottom of the window. This displaysmessages as tasks are performed. Check that the current message, at theleft, states Ready.11.The right side of the Status Bar contains Views buttons and a Zoom slider.12.Along the bottom of the screen is the Taskbar, this contains the Startbutton, open application buttons and others, including Time.Excel 201015 CiA Training Ltd 2013
Spreadsheet SoftwareECDLExercise 4 - The RibbonKnowledge:The Ribbon is displayed across the top of the application window. The Ribboncontains buttons and drop down lists to control the operation of Excel. The Ribbonis divided into a series of Tabs, each one of which has a set of controls specific to acertain function or process. On each tab, the controls are further divided intoseparate Groups of connected functions.Some tabs can be selected manually, some only appear when certain operationsare active, for example only when a Chart is active, will three Chart Tools tabs bedisplayed on the Ribbon.Activity:1.On the Ribbon, the Home tab should be selected. Other basic tabs, areavailable.Part of the Ribbon displaying the Home tabNote:2.Note:Any buttons displayed in pale grey are called ghosted and are not availableto be selected at present.Notice how the buttons on the Ribbon are divided into Groups (Clipboard,Font, Alignment, etc.).The display of buttons on the Ribbon is dynamic. That is it will changeaccording to how much space there is available. If the window is notmaximised or the screen resolution is anything other than 1024 by 768, theRibbon will not always appear as shown in this guide.3.Place the cursor over the Bold button,in the Font group. The ToolTipappears which give more information and an alternative key press Ctrl B for the function.4.Some buttons produce immediate effects, like the Bold Ctrl B , Italic Ctrl I and Underline Ctrl U buttons in the Font group. CiA Training Ltd 201316Excel 2010
ECDLSpreadsheet SoftwareExercise 4 - Continued5.Buttons with a drop down arrow lead to further options. Click theFind & Select button, which is found in the Editing group. A list offurther options is displayed.6.Some options will display a dialog box which needs data to be entered. Clickthe first option Find, the Find and Replace dialog box is displayed. Clickthe Close button in the dialog box to remove it.7.Some groups have a dialog box launcher to the right of the group name,e.g. the Font group,.8.Click the Font dialog box launcher to display the Format Cells dialog box.9.This is a tabbed dialog box, similar to those used in previous versions ofExcel. Click Cancel to close the Format Cells dialog box.10.Display the other basic tabs, one at a time, Insert, Page Layout, Formulas,Data, Review and View to see which other commands are available.Note:11.Excel 2010There may be a Developer tab displayed, used for controlling macros. Thistab is not displayed by default.Select the Home tab again.17 CiA Training Ltd 2013
Spreadsheet SoftwareECDLExercise 5 - The Worksheet WindowKnowledge:Spreadsheets help in the processing of numbers. They store information in rows(across the screen) and columns (down the screen). A cell is the intersection of arow and column. All the cells form a worksheet (the Excel term for a spreadsheet).Several worksheets are bound together and called a workbook.Activity:1.Each cell is identified by the column letter and row number, which form theintersection, e.g. the cell formed where column D and row 8 meet is knownas cell D8. Move the mouse pointer to cell B3 and click. The Current orActive cell is now B3. It has a dark border.Active CellreferenceFormula BarColumnHeadingActive CellScroll BarsRow BorderSheet Names2.Look for the Active Cell Reference, which is shown in the Name Box at theleft of the Formula Bar. It displays B3.3.Click in cell C6. The Active Cell Reference now shows C6. These lettersand numbers are shown highlighted in the Row and Column Headings onthe worksheet. C6 is now the Current or Active cell.4.The active cell can be moved using various key presses. Press the rightcursor key . The active cell moves right into cell D6.5.Press the down cursor to move into cell D7. Press the left cursor tomove into C7.6.Press the up cursor . The active cell should now be C6 again. CiA Training Ltd 201318Excel 2010
ECDLSpreadsheet SoftwareExercise 6 - Closing ExcelKnowledge:When Excel is closed, if any workbooks are still open and have not been saved, awarning will be displayed with an option to save the changes.Activity:1.Display the File tab to show the menu.2.Click Info on the left and look at the options available.3.Click Exit and Excel closes, however, if an open workbook needs savingbecause of changes then a save prompt is displayed. Click Don’t Save ifthere is a prompt to save.File tabNote:Excel 2010Excel can also be closed by clicking the Close button,corner of the screen.19in the top right CiA Training Ltd 2013
Spreadsheet SoftwareECDLExercise 7 - Develop Your SkillsNote:This training, which has been approved by the BCS, includes exercise itemsintended to assist learners in their training for a BCS or ECDL CertificationProgramme. These exercises are not certification tests. For informationabout how to take a certification test and to find Approved Centres in theUK, please refer to the BCS website at www.bcs.org/qualifications.You will find a Develop Your Skills exercise at the end of each Skill Set. Work throughit to ensure you’ve understood the previous exercises.1.Start Excel using the Start button.2.What is the name of the current workbook?3.How is the Active Cell displayed?4.How many worksheets are in a workbook by default?5.Use the mouse pointer to find ToolTips for the following buttons, located onthe Home tab:a)b)c)d)6.How many groups are displayed on the Data tab of the Ribbon?7.The Formulas tab has the following groups:Calculation, Formula Auditing and which other?8.Close down Excel using the File tab. What is the option called that actuallycloses the application down?9.Close Excel.Note:FunctionLibrary,The answers are listed in the Answers section at the end of the guide. CiA Training Ltd 201320Excel 2010
ECDLSpreadsheet SoftwareSummary: FundamentalsIn this Skill Set you have been introduced to the principles of a spreadsheet softwareprogram, Excel.You have opened Excel, become familiar with the screen layout, and identified thevarious parts of the screen and their uses.You have also closed ExcelYou should be able to demonstrate your ability to: Excel 2010Understand spreadsheet structure21 CiA Training Ltd 2013
Spreadsheet SoftwareECDLSkill Set 5FormulasBy the end of this Skill Set you should be able to:Create Simple FormulasUnderstand Mathematical OperatorsSelect Cells with the Mouse to Create FormulasUse the functions SUM, AVERAGE and ROUNDCopy and Check FormulasUse the Fill Handle CiA Training Ltd 201352Excel 2010
ECDLSpreadsheet SoftwareExercise 30 - Introducing FormulasKnowledge:A calculation in Excel is called a Formula. Formulas are used to calculate answersfrom numbers entered on the sheet, e.g. sales for the year, net profit in a month,overall profitability of the company, etc.All formulas begin with an equals sign ( ), followed by the calculation.Formulas automatically calculate results from the data. Any changes in the data willcause the formulas to be recalculated automatically.Activity:1.Open the workbook Formulas.2.To add the contents of B4 and B5, make B6 the active cell by clicking on it.Do not add spaces and use the symbol on the numeric keypad at the rightof the keyboard to type in b4 b5. Ignore any shortcut formula lists thatmay appear.3.Press Enter to complete the formula. The cells being selected in theformula are highlighted automatically when entered on the screen. Thiscreates a formula to add the contents of cells B4 and B5.Note:When entering cell references, like B4, it does not matter if they are enteredin capitals or not, as Excel converts them to uppercase.4.Click back on cell B6 and note the cell displays 9 and the Formula Bardisplays B4 B5, the formula.5.Leave the workbook Formulas open.Excel 201053 CiA Training Ltd 2013
Spreadsheet SoftwareECDLExercise 31 - Mathematical OperatorsKnowledge:The basic mathematical operators are add, subtract, multiply and divide. You havealready used the operator ; the others are introduced here. The symbols on akeyboard are slightly different to those used normally and are: Add-Subtract*Multiply/DivideThese symbols appear twice, one set placed around the main keyboard and theother set on the numeric keypad (right side). The keypad is easier to use becausethe keys are closer together and the Shift key is not used.More complicated calculations are entered using Functions. Apart from a couple ofbasic functions, SUM and AVERAGE, introduced in this guide, many more areavailable.Activity:1.Note:With the workbook Formulas open, click on cell C6.To use the numeric keypad for number entries, the Num Lock light on thekeyboard must be on. If not, press Num Lock .2.Enter the formula to subtract the two numbers above c4-c5. Complete theentry by pressing the right arrow key. The answer is displayed as 3.3.In cell D6, enter the formula to multiply the two numbers above d4*d5.Complete the entry by pressing the right arrow key. The answer is displayedas 15.4.In cell E6, enter the formula to divide the two numbers above e4/e5.Complete the entry by pressing the right arrow key. The answer is displayedas 3.5.Leave the workbook open for the next exercise. CiA Training Ltd 201354Excel 2010
ECDLSpreadsheet SoftwareExercise 32 - Selecting Cells with the MouseKnowledge:When entering formulas that involve the use of cell references, e.g. E6 F6 typingerrors can be made. The mouse can be used to enter the cell references. This iscalled pointing. The mouse pointer is moved to the required cell and clicked.Activity:1.If the workbook Formulas is not open then open it.2.Click on cell B6 and pr
ECDL European Computer Driving Licence Spreadsheet Software BCS ITQ Level 1 Using Microsoft Excel 2010 Syllabus Version 1.0 This training, which has been approved by BCS, includes exercise
Although the ECDL / ICDL Presentation sample part-tests are not certification tests they do give an indication about the scope and approach adopted within the actual ECDL / ICDL Presentation certification test. All test items within the actual ECDL / ICDL Presentation certification tests are based on ECDL /
New ECDL FAQ 2 So what’s this New ECDL all about? New ECDL is actually the 6th version of the ECDL programme (ECDL Version 6) since its beginning in 1997. To reflect the significance of Version 6, this version of the p
Excel 5.0 Excel 5.0 1993 Excel 5.0 1993 Excel 7.0 Excel 95 1995 Excel 8.0 Excel 97 1997 Excel 98 1998 Excel 9.0 Excel 2000 1999 Excel 2001 2000 Excel 10.0 Excel XP 2001 Excel v.X 2001 Excel 11.0 Excel 2003 2003 Excel 2004 2004 2.1.2 Worksheet Document Definition: Worksheet Document A worksheet document consists of a single sheet only.
PAGE 3 - ECDL MODULE 3 WORKBOOK (USING OFFICE XP) ECDL Approved Courseware IMPORTANT - PLEASE READ As a condition of providing official approval for this courseware, the ECDL Foundation demand that the following statement appear within all approved ECDL co
Advanced Spreadsheet Software BCS ITQ Level 3 Using Microsoft Excel 2010 Syllabus Version 2.0 This training, which has been approved by BCS, The Chartered Institute for IT, includes exercise items intended to assist learners in their training for an ECDL Certification Programme. These exercises are not ECDL certification tests.
Converting Excel to XML The first thing you need is, of course, an Excel spreadsheet. Below, we have an example spreadsheet with six columns and 26 rows of data. The columns separate the last names, first names, ages, majors, GPAs, and school year of each student listed in the spreadsheet. Step 1 - Create your Excel spreadsheet. excel to xml
ECDL: Module 4 Spreadsheets (Part 1 of 2) Date: September 2002 Revisions: Updated from Excel 97 to Excel 2002 (XP) - Aug 2002 by Fiona Strawbridge and Tamsin Griffith Abstract Microsoft Excel is a spreadsheet application used for manipulating and calculating numerical data, and
(ANSI) A300 standards of limitation on the amount of meristematic tissue (number of buds) removed during any one annual cycle (in general, removing no more than 25% on a young tree). The third circle is the top circle – the reason the other circles exist. We grow and maintain trees for aesthetic and functional values, and pruning properly for structure and biological health helps us achieve .
