E-mail software. Anti-virus software. Compression software. Word-processing software. What is the name and version number of the operating system on the computer you are using for this test? Enter your answer in the sample answerfile2. Use the search feature to search in the extracted ecdltest folder including subfolders for a file named invoice. Enter the file type of the invoice file as your answer in the sample answerfile2.
Locate the file decision. Locate the football folder on your candidate drive. Create two subfolders within the football folder and name them juniors and seniors. Delete the files issue. Copy the file panel. Print one copy of the sample answerfile2. This sample part-test contains 16 questions giving a total of 16 marks. The following is a sample part-test for Module 3, Word Processing. Your task is to prepare a circular letter giving notice about an upcoming annual general meeting of your local badminton club.
In the test you are asked to modify the letter, to apply various formatting actions to it; and to carry out a mail merge operation. Open the word processing application and open the file called game. Save the document to your candidate drive as badminton. Centre align the heading Badminton located at the top of the document.
Change the colour of the heading Badminton to a colour of your choice. In the paragraph beginning The idea of… create a new paragraph at the sentence beginning Badminton became popular …. Apply single line spacing to the paragraph beginning It was adopted In the paragraph beginning It was adopted… make the words Duke of Beaufort bold and save.
Select the paragraph beginning As with all… and change the font size to Apply bullets to the text near the bottom of the page from When the shuttle lands… to When a player touches… [1 Mark] 9. Remove the paragraph mark and change the paragraph spacing below after the text A New Scoring System to 6 pt instead. Enter your name in the left hand side of the header of the document. Print one copy of the badminton document to an output printer.
Save and close the badminton file. Mail Merge: Open the file called agmletter.
European Computer Driving Licence: what it means for the NHS
Use the document as the form letter for a mail merge. Use the file addrlst. Merge the address list data source file with the letter to create a mail- merged document showing all the addressees. Save the mail merge document as merge. Save and close all open files. Open the file called memorandum. Save and close any open files and close the word processing application.
Your task is to prepare an information sheet providing tips about hill walking.
Computer Essentials - ICDL - International Computer Driving Licence
In the test you are asked to edit the information sheet, to apply various formatting actions to it, and to edit a simple table. Open the word processing application and open the file called test Save the document to your candidate drive as hill walking. Change the colour of the heading Hill Walking to a colour of your choice. Change the spacing of the paragraph beginning This is the practice… so that there is a 6 pt space after below the paragraph.
In the paragraph beginning This is the practice… edit the text land to read terrain. In the paragraph beginning This is one… underline the word considerations. In the paragraph beginning This is one… delete the soft line break after the word account. Apply the paragraph style subhead to the text Equipment above the paragraph beginning There are many types….
Apply automatic numbering to the list of points from Compass to Water. The heading Summer Months for Hill Walking was aligned using the spacebar. Remove the spacing and set and apply a left aligned tab of 1 cm to the heading Summer Months for Hill Walking and save. Complete the table with the following information. Add a shading of your choice to the first row containing the text Months and Temperature Celsius.
Set the line width for all the borders in the table to 1 pt. Change the left and right margins in the document to 2 cm.
Table of contents
Print one copy of the document to an output printer. Save and close the hill walking file and close the word processing application. Select, sort and copy, move and delete data. Copy, move, delete and appropriately rename worksheets. Use good practice in formula creation and recognize error values in formulas.
The following sample part-test for Module 4, Spreadsheets, is based on creating a spreadsheet for improvements to your house. In the test you are asked to develop a budget for improvements to your house, to carry out various formatting actions, and to make some calculations before presenting the spreadsheet to your bank manager. Open the spreadsheet application and open the file called improvements.
Save the file as costings. Widen column A so that the content of the column is fully visible. Enter the number 2, into cell C7. Enter a function in cell B11 to calculate the sum of the cell range B5:B Copy the sum function in cell B11 to the cell range CF Enter a formula in cell B13 that subtracts cell B11 from cell B3.
- ECDL Module 2.
- Wireless Sensor and Actor Networks: IFIP WG 6.8 First International Conference on Wireless Sensor and Actor Networks, WSAN’07, Albacete, Spain, September 24–26, 2007.
- Links and Books?
- Hearts Stolen (Texas Romance, Book 2).
- US NAVY FACT FILE Aircraft Carriers CV-1 USS Langley.
- You are here.
Copy the formula in cell B13 to the cell range CE Enter a formula in cell F5 with an absolute cell reference for one cell only that divides the content of cell E5 by the content of cell E Copy the formula in cell F5 to the cell range F6:F Format the cell range F5:F11 as a percentage with no decimal places and save. Enter a function in cell B15 to calculate the minimum of the cell range B5:B Copy the function in cell B15 to the cell range CD Enter a function in cell B17 to calculate the maximum of the cell range B5:B Copy the function in cell B17 to the cell range CD Rename the Sheet3 worksheet so that it meaningfully relates to the worksheet content.
On the loan worksheet create a 2-D clustered column chart from the cell range A3:D5. Position the chart to display at cell A7 in the worksheet and save.
On the loan worksheet enter your name in the right section of the header of the worksheet.
Related ECDL Module 2: Using the Computer and Managing Files: ECDL—the European PC standard
Copyright 2019 - All Right Reserved