When using spreadsheet files, which would improve the calculations you use?

Use SUM to add up a range of data rather than addition

Which one of the following would represent a weakness in your final work?

Text hidden behind photographs or illustrations

In terms of business productivity, which is a benefit of using IT tools and systems?

Working remotely means less travel so more time to work

You need access to a number of files regularly. Which would help you find them quickly?

Set up shortcuts on your desktop to the files

Which BEST describes the method used to create a letter from a list of names & addresses?

Use of mail merge to combine data

Why would Excel be the most appropriate software to generate a price list structure & a chart?

It has a range of features to create charts & graphs

Which would MOST likely affect your ability to carry out calculations on financial data?

Having the skill to create formulas and functions

Which of these is most important when creating a PowerPoint presentation?

Making it clear, well laid out and consistently formatted

studbud

ECDL Improving Productivity: Revision / Quick Test

13 termsStudBud Administration847 plays

This quiz focuses on the ECDL Improving Productivity test. It is intended to be an extra revision/homework resource. This test does not repeat the practical skills covered in the other tests as students should know these now, but instead focuses on the multiple choice questions.

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
When using spreadsheet files, which would improve the calculations you use?
Use AVERAGE to calculate which figure occurs the most often
Use MAX to calculate the smallest figure in a range of data
Use SUM to add up a range of data rather than addition
Use COUNT when you need to add an absolute cell reference
2
Which one of the following would represent a weakness in your final work?
Text hidden behind photographs or illustrations
Re-sizing photographs to make the best use of space
All text can be seen
Spell checking before printing
3
In terms of business productivity, which is a benefit of using IT tools and systems?
Printing emails gives you access to all the info you need
Using networked computers means no more meetings
Having files in 'the cloud' means you never need to backup
Working remotely means less travel so more time to work
4
You need access to a number of files regularly. Which would help you find them quickly?
Use of a compression application
Keep backup copies of your most important files
Keep on a memory stick stored in a locked drawer
Set up shortcuts on your desktop to the files
5
Which of the following is NOT an efficient method of arranging a list of names and addresses?
Using a spreadsheet with 1 data type in each cell
Using tabs within PowerPoint
In a text file, separated by commas
Using rows and columns in Word
6
When using a company logo, which of the following legal aspects would you need to consider?
Display Screen Equipment Regulations
Copyright Law
Health and Safety Act
Data Protection Act
7
Which BEST describes the method used to create a letter from a list of names & addresses?
Use of copy and paste to combine data
Use of tables to combine the data via 'the cloud'
Use of default templates to combine data
Use of mail merge to combine data
8
Why would Excel be the most appropriate software to generate a price list structure & a chart?
It enables charts and graphs to be animated
It has a range of features to manipulate images
It uses related tables to store data
It has a range of features to create charts & graphs
9
Which would MOST likely affect your ability to carry out calculations on financial data?
Having access to an accurate project plan
Having access to a suitable budget for the project
Having the skill to create formulas and functions
Having the skills to generate suitable images
10
Which Microsoft application would you use to create a chart based on financial data?
Word
Excel
PowerPoint
Access
11
Which of these is most important when creating a PowerPoint presentation?
Using tables to control the layout
Saving the document using the date instead of a filename
Making it clear, well laid out and consistently formatted
Adding photographs to replace the text
12
If you were asked to insert an image on every PowerPoint slide, what tool would you use?
Animation
WordArt
Master slide
Slide show
13
Which is the best way to check that your animations and timings work correctly?
Set up the file so the spell-checker works automatically
Run an onscreen show
Make sure the design templates are the same for each slide
Set timings so that slides automatically advance

ECDL Improving Productivity: Revision / Quick Test Flashcards | StudBud

ECDL Improving Productivity: Revision / Quick Test

13 termsStudBud Administration847 plays

Flashcards13 cardsFPractice quizPHost liveL

Questions 13

Answers

1
When using spreadsheet files, which would improve the calculations you use?
Use AVERAGE to calculate which figure occurs the most often
Use MAX to calculate the smallest figure in a range of data
Use SUM to add up a range of data rather than addition
Use COUNT when you need to add an absolute cell reference
2
Which one of the following would represent a weakness in your final work?
Text hidden behind photographs or illustrations
Re-sizing photographs to make the best use of space
All text can be seen
Spell checking before printing
3
In terms of business productivity, which is a benefit of using IT tools and systems?
Printing emails gives you access to all the info you need
Using networked computers means no more meetings
Having files in 'the cloud' means you never need to backup
Working remotely means less travel so more time to work
4
You need access to a number of files regularly. Which would help you find them quickly?
Use of a compression application
Keep backup copies of your most important files
Keep on a memory stick stored in a locked drawer
Set up shortcuts on your desktop to the files
5
Which of the following is NOT an efficient method of arranging a list of names and addresses?
Using a spreadsheet with 1 data type in each cell
Using tabs within PowerPoint
In a text file, separated by commas
Using rows and columns in Word
6
When using a company logo, which of the following legal aspects would you need to consider?
Display Screen Equipment Regulations
Copyright Law
Health and Safety Act
Data Protection Act
7
Which BEST describes the method used to create a letter from a list of names & addresses?
Use of copy and paste to combine data
Use of tables to combine the data via 'the cloud'
Use of default templates to combine data
Use of mail merge to combine data
8
Why would Excel be the most appropriate software to generate a price list structure & a chart?
It enables charts and graphs to be animated
It has a range of features to manipulate images
It uses related tables to store data
It has a range of features to create charts & graphs
9
Which would MOST likely affect your ability to carry out calculations on financial data?
Having access to an accurate project plan
Having access to a suitable budget for the project
Having the skill to create formulas and functions
Having the skills to generate suitable images
10
Which Microsoft application would you use to create a chart based on financial data?
Word
Excel
PowerPoint
Access
11
Which of these is most important when creating a PowerPoint presentation?
Using tables to control the layout
Saving the document using the date instead of a filename
Making it clear, well laid out and consistently formatted
Adding photographs to replace the text
12
If you were asked to insert an image on every PowerPoint slide, what tool would you use?
Animation
WordArt
Master slide
Slide show
13
Which is the best way to check that your animations and timings work correctly?
Set up the file so the spell-checker works automatically
Run an onscreen show
Make sure the design templates are the same for each slide
Set timings so that slides automatically advance