Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
29 Cards in this Set
- Front
- Back
John uses a special type of application package to total up the takings from his shop.
State the TYPE of application package John would be using. |
Spreadsheet Application
|
|
How has the following number been FORMATTED?
£47.39 |
Currency
|
|
John wants to add up the totals from cells D1 to D12.
State a suitable formula to carry out this operation. |
=SUM(D1:D12)
|
|
John needs to copy the total formula from cell D13 to D14.
Name a feature of the package that would allow him do this. |
Fill Down
|
|
What does the SUM function do in a spreadsheet package?
|
Adds the values of a range of cells.
Ex. =SUM(D1:D12) would add together all the numbers from all the cells from D1 to D12 |
|
John decides to add a new product to his spreadsheet.
Describe how John could add this product to his spreadsheet |
Go to the relevant menu and choose option INSERT ROW
OR Right click on the row below where you would like your new row to be inserted and click INSERT |
|
John wants to train his staff on all of the products in the store. He decides to create an audio file (.mp3)
State 1 item of hardware that John would require to RECORD the file. |
Microphone
|
|
State 1 advantage of using an electronic database
|
Search for information quickly
OR Sort information quickly OR Insert/Delete/Amend records quickly OR Takes up less physical storage space |
|
Jemima uses adds a field for ADDRESS to her database.
What data type should this be assigned? |
TEXT
|
|
Jemima alse adds a field for CLIENT AGE to her database.
What data type should this be assigned? |
NUMBER
or NUMERIC |
|
Jemima has had a client contact her to tell her that she is no longer needing her services.
State an operation that Jemima could do to remove the client data from the database. |
DELETE RECORD
|
|
Jemima has realised that one her clients names has been incorrectly spelled.
State an operation that Jemima could do to fix this problem. |
AMEND/EDIT RECORD
|
|
Jackson has created a multimedia application and wants to take it to school to show his friend.
State 1 type of backing storage that would be suitable to take this into school. |
USB Flash Drive
or CD-R or CD-RW any other valid |
|
Joanna wants to back up her
120 GB computer movie collection to some form of backing storage device. State a device that would be suitable for carrying out this task. |
Hard Disk or Hard Drive
Accept: External Hard Disk |
|
State 1 FILE TYPE Joanna should use to store her home movies?
|
.MPEG
or .AVI |
|
Jimmy has created a website. When a user selects and image, they are taken to a new web page.
State which web page feature this is an example of. |
Hyperlink
|
|
Jenny has created an image with her drawing (vector) graphics package. She would like add her name.
State the TOOL she would need to select to add her name to the drawing. |
TEXT TOOL
or ADD TEXT |
|
Jenny's computer drawing contains different objects, but they move together when she clicks on any one of them.
Describe the operation Jenny has carried out on these objects. |
She has selected all the objects
She has chosen the GROUP option in the application package |
|
NOTE!!!!
|
REMEMBER TO LOOK OUT FOR THE NUMBER OF MARKS AVAILABLE FOR A QUESTION.
|
|
NOTE!!!
|
REMEMBER TO WATCH OUT FOR KEY WORDS:
Describe State Name |
|
Jamie has created a slide for his presentation and wants all the pages to have a similar layout.
Name the feature Jamie would use. |
Master slide
or Slide Master or Page Master or Master Page |
|
Jamie wants to create a poster to go along with his slideshow. He does not have much time to design the layout though.
State a feature of a Desktop Publishing Package that would allow Jamie to quickly create a professional looking presentation. |
Template
|
|
Jez has created a hand drawing and wants to add it to the computer system so she can use it within her graphics package.
Which INPUT device would Jez use? |
Scanner
|
|
What is the name of the type of SOFTWARE that is used with a microphone to allow a user to enter text into a computer system?
|
Voice/Speech Recognition Software
|
|
Jackie wants to improve her presentation by animating the text.
She wants the text to disappear slowly before moving onto the next slide. State the text effects used on her titles. |
Fade Out
|
|
Jini has broken her hand.
State a method she could use to enter text into a computer without using a keyboard. |
Microphone and Speech/Voice Recognition software
(must have both HARDWARE and SOFTWARE) |
|
- Apple
- Banana - Pear The above are examples of? |
Bullet Points
|
|
Where would you add your name and page number in a word processed document?
|
The Footer
|
|
Jinky has added a photograph to his Word Processed document. The text flows around the image.
What is this feature called? |
Text Wrap
|