Section 1

  1. Open the Excel software by using the Start button on the bottom left of the screen, using the ‘All Programs’ option. Do NOT use any shortcuts on your desktop. Close the Excel document but NOT the application without saving any changes.
  2. Create a new Blank document. Can you identify the different parts of the Excel window on your screen?

Enter the correct number against each section:

Title Bar / Sheet Tabs
Dialogue Box Launcher / Quick Access Toolbar
Cell / Formula Bar
Name Box / Ribbon
Status Bar
  1. Fill in the blanks using the words below:

three / Worksheet / columns / Formula bar / rows / Name box
Ribbon / Workbook / Sheet tab / cells / Backstage view

A file in Excel is called a ; it contains worksheets where you can enter, calculate and analyse data.
Each sheet in a workbook is called a – it is a collection of rows and columns.
You can move from one worksheet to another by clicking on the . A blank workbook contains sheets by default.
Data is entered in and is identified by the combination of the column letter and number (for ex E4).
On a worksheet the are numbered serially and the are identified using letters of the English alphabet.
The tells you the name or location of a selected cell.
In the you can enter or edit data, formula or a function that will appear in a specific cell.
The Microsoft Office is the set of commands that provides you with access to functions that affect the entire document. This includes setting document properties, versioning, printing, protection and more.
Within the Excel window, the contains groups of commands that are specific to the selected tab.

  1. Do you know how to minimise the Ribbon? If you have already completed the Word Processing module; it will be using the same method.
  2. True or False?
    - It is good practice to have only one element of data in each cell.
    - It is good practice to leave blank rows and columns in the main body of a list.
  3. Which of these commands would you use to move data from one workbook to another?
    cut copy sort
  4. Which command would you use in the View tab to see all open workbooks?
  5. Use the Help command to find information on How to display numbers as currency?
  6. What is the name of the Workbook displayed below?
  1. Create a new blank workbook and enter the data as shown below:

  2. Save the workbook with the filenameTraining-yourname. Close the workbookbut make sure you leave the application open.
  3. Open an existing file named Timetable and make sure you are in the worksheet named Hours.There are some errors on this worksheet that need to be amended:
    -Go to cell C8 and change the hours for Paul to 8
    -Go tocell A9 and change the spelling of Catherine to Kathryn
    -Delete the contents in cells G4 to G12 as they are no longer required
    -The deletion was a mistake – undo your last action
  4. Place your cursor in cell B3 and use the fill handle to replicate the days of the week across to cell H3.
  5. Select cell J4 and use the fill handle to replicate/copy this amount down to cell J12.
  6. The hours for FRI are missing; everyone worked the exact same hours as WED.
    Copy the contents of cells D4 to D12 and place the cursor in cell F4 and paste the data.
  7. Delete the contents of cell I4as they are no longer required.
  8. Select the data in cells A4 to A12 and sort in ascending alphabetical order.
  9. Findall instances of 7.25 in the cells and replace with the value 8.25in the Hours worksheet.
  10. Select cells A4 to A12 – copy the content and paste in cell A4 in the Overtime worksheet.
  11. Go to Hours worksheet. Highlight the following cells: A3 to A12, G3 to G12, H3 to H12
    Hint: you must use the Ctrl key on the keyboard to select non-adjacent cells
    Copy and paste into cell A1 in the Weekend shiftworksheet.
    Use the zoom tool to magnify the Weekend shift worksheet to 180%.
  12. Save the document as a Microsoft Excel 97 - 2003 Workbookusing the filename Timetable-yourname.
  13. Change the settings in Excel’s ‘Options’ so that the author/user name details of the document contains your name. Create a screen capture to evidence this.
  14. Before attempting this question, make a note of the default file location for saving documents on your computer.
    Change the default file location of where a document is saved to the Desktop. Create a screen capture to evidence this. Restore the default file location to its previous settings.
  15. Insert the correct file format in the boxes below:
    CSV (Comma-delimited) Formatted Text (Space-delimited) Text (Tab-delimited)
    PDF Excel 97-Excel 2003 workbook Excel Template
    OpenDocument Spreadsheet

Saves as plain text and does not retain any formatting from the original application it was created in. It retains line breaks and other characters by inserting tab characters – it does not retain font and other formatting changes – active sheet can only be saved
Can be opened in any version of Excel between Excel 97 and 2003
Saves as plain text and does not retain any formatting from the original application it was created in. It retains line breaks and other characters by inserting commas– active sheet can only be saved
This format only saves the active sheet in Lotus space-delimited format
Retains the format and data cannot be easily changed – this format is useful for documents that will be reproduced by using commercial printing methods
A useful way to store layouts and styles for future use
Saved in this format the workbook can be opened in OpenOffice or Google Docs
  1. When you have finished all the above, save this existing document (ECDL SS task 1) as
    SS Task 1-yourname.
    Close the spreadsheet. Exit the Excel application.
  2. You have now completed this task. Please ensure you have the following files ready to email to the team for
    Training-yourname.xls
    Timetable-yourname.xls
    SS Task 1-yourname.docx (this document completed)
    screen captures (can be one document or individual files)

L:\MOLU\MOLU common folder\ECDL taught sessions\Spreadsheets\ECDL SS task 1.docx1