ECDL Module E Revision

What is the main purpose of database software?
1. Store and analyse financial data only
2. Store and analyse textual and numerical data
3. Create presentations to show to a group
4. Create a web page
What is not a purpose of spreadsheet software?
1. Sorting data
2. Doing calculations
3. Writing reports
4. Creating graphs
What is not a purpose main of presentation software
1. Doing calculations
2. Preparing and printing handouts
3. Preparing a slide show to show to a group
4. Preparing a slide show to show at a kiosk
What program is not suitable for storing the product details of a retail organisation?
1. Spreadsheet
2. Database
3. PowerPoint
4. A word table in a word processing document
Which of the following is the format of a 'long date'?
1. 9 Sept 2005
2. 09 September 2005
3. 9 September 2005
4. 09 Sept 2005
Which of the following is the correct format of 'medium date'?
1. 09-09-05
2. 09-Sep-05
3. 09-Sep-2005
4. 9-Sept-05
Which of the following is the correct format of 'short date'?
1. 9/9/05
2. 09/09/05
3. 09/09/2005
4. 9/09/2005
What happens when you link a spreadsheet to a word document and then change the spreadsheet?
1. The Word document doesn't change
2. When you open the Word document it asks you if you want to update the link
3. The Word document updates when you change the spreadsheet (when only the spreadsheet is open)
4. You can't change the spreadsheet
Which two documents do you need to create a mail merge letter?
1. Spreadsheet and database
2. Source data and spreadsheet
3. Source data and form letter
4. Form letter and presentation
What is the source data of a mail merge letter?
1. The text of the letter
2. The names and addresses
3. A program
4. A web page
Where can the data not be stored?
1. In a spreadsheet
2. In a database
3. In a PowerPoint presentation
4. In a Word table
Where are images stored when they are copied?
1. In My Documents
2. On the Clipboard
3. In media viewer
4. On the desktop
You want to change the name of a file. Which way will not work?
1. With the file open, choose Save as... from the File menu
2. In Windows Explorer, right click on the file and choose Rename
3. In Windows Explorer, click on the file, wait a moment, click the file again, delete the original name and type in the new one
What is the difference between .rtf and .txt formats?
1. .rtf retains images and .txt doesn't
2. .txt retains the text formatting and .rtf doesn't
3. .rtf retains the text formatting and .txt doesn't
4. .txt can use a number of different fonts in one document and .rtf can use only one
How do you get a leading zero in a number in Excel?
1. Set the format as number
2. Set the format as text
3. Set the format as date
4. Type in the zero and it will stay automatically
You want to create a graph that will show clearly the highest and lowest scores on a test that five people have taken, what type of graph would you choose?
1. Pie
2. Bar or column
3. Line
4. Comparative

ECDL Module E Revision

Quiz