St John Fisher ::: ICT ::: ECDL ***


Welcome to the ECDL Homepage Here you will find lesson resources and helpful hints and tips to help you pass. TIPS and TRICKS to PASS Module 2 requires you to know several core keyboard shortcuts: Print out the list below and carry around with you and use when ever you are on a computer so that you can remember them. The ones in red and the most common in the Module 2 exam General keyboard shortcuts CTRL+C (Copy) CTRL+X (Cut) CTRL+V (Paste) CTRL+Z (Undo) DELETE (Delete) SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) CTRL while dragging an item (Copy the selected item) CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) F2 key (Rename the selected item) CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) CTRL+A (Select all) F3 key (Search for a file or a folder) ALT+ENTER (View the properties for the selected item) ALT+F4 (Close the active item, or quit the active program) ALT+ENTER (Display the properties of the selected object) ALT+SPACEBAR (Open the shortcut menu for the active window) CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously) ALT+TAB (Switch between the open items) ALT+ESC (Cycle through items in the order that they had been opened) F6 key (Cycle through the screen elements in a window or on the desktop) F4 key (Display the Address bar list in My Computer or Windows Explorer) SHIFT+F10 (Display the shortcut menu for the selected item) ALT+SPACEBAR (Display the System menu for the active window) CTRL+ESC (Display the Start menu) ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command) F10 key (Activate the menu bar in the active program) RIGHT ARROW (Open the next menu to the right, or open a submenu) LEFT ARROW (Open the next menu to the left, or close a submenu) F5 key (Update the active window) BACKSPACE (View the folder one level up in My Computer or Windows Explorer) ESC (Cancel the current task) SHIFT when you insert a CD-ROM into the CD-ROM drive (Prevent the CD-ROM from automatically playing) CTRL+SHIFT+ESC (Open Task Manager) Right Click Keyboard Short Cuts: To create a compressed file: Select File/Right Click/Send To/Compressed Zipped Folder To send a file or folder to a removable Disk i.e. USB: Select File/Right Click/Send To/Removable Disk To create a desktop shortcut: Select File/Right Click/Send To/Desktop (create shortcut) TIPS and TRICKS to PASS Module 4 Spreadsheets REMEMBER: All formula's start with an = sign To get your calculations right you MUST learn and follow this order in Excel and in the ECDL tests: Excel Order of Calculation ( ) Calculations in brackets are ALWAYS done FIRST, then x or / multiplications or division and then LAST + or - addition or subtraction Look at the following examples and try them in Excel: Add Addition + Formula Cell B4 add (+)Cell B5 = Formula =B4+B5 Subtraction - Formula Cell E5 subtract (-)Cell E6 = Formula =E5-E6 Multiply x Formula Cell E7 multiply () Cell B10 = Formula* =E7B10 Divide* Formula Cell B9 divide(/) by 4 = (Total cost of holiday for 4 people divided by 4 to give individual cost per person) Formula =B9/4 Combined Formula Cell B4 subtract (-) 32 = then divide (/) answer by 1.8 = The bracket part of the formula MUST be calculated first so that the bracket answer is used to base the second part of the formula on i.e. 275 - 32 = 243 243 divided by 1.8 = 135 Formula =(B4-32)/1.8 Percentage Formula Cell B6 divided (/) by Cell B13 select % button = The percentage is calculated by dividing the value of B6 Total Police Expense by the total of Expenses in B13 and pressing the % button i.e. 1,400,000 divided by 9,560,000 = 15% Formula =B6/B13 Copying Formula Absolute Reference If you need to change the formula in a cell so that is dosn't become relative where it changes with all formulas as in above, you make the cell reference absolute by placing a dollar sign in the row and column reference. This means that the formula can be copied and used elsewhere, but it will always refer to value of A1 cell. Formula =$A$1 In the example below, the formula contains an absolute reference to cell C3 to ensure that 10% is calculated for all staff bonus cells from C6 to C8 ie. Jim Myers Salary of £12,000 multiply 10% = £1,200 Formula =B6$C$3 Mixed Cell Reference* In a mixed formula the Row reference is the 2nd digit ie. =B$2 means column B, row 2. The dollar infront of the Row digit indicated that the row cell is absolute only. In the example below, we have a formula setup to enable the row numbers in Row 3 to multiply the column numbers in column B

General keyboard shortcuts