Database Skill

1. Which of the following is NOT an example of software?

Word

Excel

PowerPoint

All of the above are examples of software.

2. What is the term used for making changes to a document to make it more visually appealing? These changes may include Spell Check, Bold, Underline, and Italics.

Changing

Editing

Documenting

Moving

3. All formulas begin with which symbol?

* (Asterisk)

= (Equal)

+ (Plus)

% (Percent)

4. After a long discussion on memorandums, the class is given a pop quiz to determine their understanding of the parts of a memorandum. How should a student answer the following question: "Which if the following is NOT a guide word used in memorandums?"

THE:

TO:

FROM:

SUBJECT:

5. Keyboarding is also known as:

Editing

Documenting

Touch Typing

Hunt and Peck

6. Which of the following is NOT an example of hardware?

Printer

Excel

Monitor

Mouse

7. A well known scientist has just completed a spreadsheet to perform calculations related to his latest experiment. One of the calculations requires for a range of cells to be averaged. Which function will he use to calculate the average in a range of cells?

AVG

SUM

COUNT

IF

8. Wanda needs to enter a formula to calculate payroll information for her employees. She is multiplying the hours worked by the rate of pay. What is the symbol used for multiplication operations in a spreadsheet?

* (Asterisk)

+ (Plus)

- (Minus)

& (Ampersand)

9. Which type of chart would be used to BEST display the percentage of books read by boys in 8th grade? This type of chart is great for showing the parts of a whole.

Bar

Pie

Line

Scatterplot

10. Ergonomics is the science of designing a workspace for comfort and safety. Which suggestion will make your computer workstation more comfortable?

Work for at least four hours at at time without taking a break.

Sit with legs wrapped around the chair.

Use a comfortable, adjustable chair.

Use the CD-ROM drive as a cup holder for a soft drink

11. If you wanted to respond to an advertisement posted by your favorite restaurant, which type of correspondence would be MOST appropriate?

Business letter

Personal letter

Personal business letter

Memorandum

12. What is the term used for the most common way to input data into a computer?

Printer

Keyboard

Monitor

Scanner

13. If Susan purchases a single-user license for a word processing program, on how many computers can she legally install the software?

Two

One

None

All computers included in her network

14. Which of the following is NOT a part of the information processing cycle?

Input

Process

Output

Cycle

15. Which of the following is NOT a part of an email address?

User name

Domain name

@ symbol

Public Domain

16. Which type of software is frequently used by people to calculate data using formulas or functions?

Word Processing

Database

Multimedia

Spreadsheet

17. Karen has spent a lot of time researching options for her new desk and chair. She wants to sit at a 90 degree angle and have her monitor at the right distance for viewing. What the term used for designing a workstation to be safe and comfortable?

Ergonomics

Keyboarding

Balance

Touch Typing

18. Which type of printer provides the BEST quality of printer documents?

Laser

Dot matrix

Inkjet

Deskjet

19. Yolanda has just written a letter for her Language Arts portfolio and is preparing for her test. After reviewing her notes and referencing her handout, how does she answer the question: "Which of the following is NOT a part of a letter?"

Salutation

Return Address

Outside Address

Complementary Close

20. Cindi is typing a report on the natural habitat of her favorite animals. To make sure she earns the highest possible grade she carefully considers her report formatting notes. How many inches will she use for the left margin of a leftbound report?

1

1.5

2

2.5

21. Which type of virus is created to multiply itself and use up system resources?

Logic Bomb

Time Bomb

Trojan Horse

Worm

22. When typing a report, how many inches are used for the top margin of the Title/Cover page?

One

Two

Three

None of the above

23. Which term BEST describes the technology that enables computers to communicate the transmission of text, numeric, voice and/or video data from one computer to another computer?

Basic Controller

Control Unit

Data Communications

Processing Unit

24. What is the term used for the printed copy of data?

Hard copy

Soft copy

Final copy

Used copy

25. Sharon wants to do a great job for her graduation project. After months of research and study on dance techniques of various cultures she has decided to present a visually stunning slideshow presentation to the judges. What type of software should Janet use to create the slideshow?

Multimedia

Spreadsheet

Word Processing

Desktop Publishing

26. A network consists of at least two computers being connected together. Which of the following is a type of network?

ALN

CPU

ROM

LAN

27. When considering paper choices for his report, Orlando decides to go with a standard sheet. What are the measurements of a standard sheet of paper?

3 X 5

4 X 6

8 X 10

8 1/2 X 11

28. Which piece of hardware is a device that processes the data entered into a computer?

ROM

RAM

CD-ROM

CPU

29. What is the term used for the physical parts of a computer system?

Equipment

Hardware

Software

Input

30. Which type of software is used to manage the resources of a computer? This type of software helps the application software interface with peripheral devices and memory of the computer.

Operating system

Utility

Anti-virus

Application

31. Which type of virus is created to do something different than what is expected?

Logic Bomb

Time Bomb

Trojan Horse

Worm

32. Which type of memory is long term memory? This is the type of memory where the instructions needed to boot the computer are stored.

Random Access Memory

Read Only Memory

Short Term Memory

None of the above are correct

33. What is the term used for the address of the writer of a letter?

Inside address

Outside address

Return address

Sender's address

34. When you purchase a new CD just released by your favorite artist, how many copies can you legally make? Why?

One - to give your best friend

One - to serve as a back-up copy

One- to use for writing down the lyrics

None, it is not legal to make any copies

35. Juan is asked to type a report on his favorite sport. The guidelines ask for double-spacing within the paragraphs. How many blank lines are used in double spacing lines of text?

Two

One

Three

None

36. Databases are used to manage large amounts of data. Some examples are: catalogs, inventories, and address book information. Which is NOT a benefit of a computerized database?

Finding specific records that match certain conditions.

Keeping an up-to-date listing of friends' phone numbers

Organizing your family's favorite recipes

Keying your social studies report

37. While manipulating a database of the planets, Sandra considers locating information on planets beginning with the letters M and N. Which type of sort will Sandra use to arrange all of the planets by name in alphabetical order?

Sort the Name field using the UP option

Sort the Diameter field in ascending order

Sort the Name field in descending order

Sort the Name field in ascending order

38. Janet wants to create a flyer to advertise her new business. She has visited the local computer shop and asks the owner a question on what type of software she needs to purchase. Most likely the owner will suggest one which is used for creating text documents with pictures and/or other images. Which type of software will he MOST likely advise Janet to purchase?

Spreadsheet

Desktop Publishing

Multimedia

Word Processing

39. Which type of chart is used to BEST display trends and comparisons? This chart works well for showing similarities and differences between two sets of data.

Bar

Line

Pie

Scatterplot

40. What is the term used for the type of software used to view documents over the World Wide Web?

Word Processing

Browser

WWW

Public Domain

41. If you want to communicate new ideas to your employees, which type of correspondence is MOST appropriate to use?

Business letter

Personal letter

Personal business letter

Memorandum or Memo

42. Karina has decided to mail a personal business letter to her favorite restaurant. She uses a standard sheet of paper and has along the short edge of the paper. What is the term used for her page orientation?

Short way

Portrait

Long way

Landscape

43. Which of the following is NOT a characteristic of short term memory?

Will be erased when the computer is turned off.

Also know as RAM

Also know as ROM

Will be erased when the computer loses power.

44. Lucas never wants to type using his keyboard. So he has decided to purchase software that will type as he speaks into a microphone. What type of software has Lucas purchased?

Voice activated

Voice recognition

Voice typist

Voice renewal

45. When guide words are typed in upper/lower case, which of the following is the appropriate formatting?

Bold, DS, and followed by a colon

Bold, and DS

DS, and followed by a colon

None of the above is correct?

46. Which type of software can be used for a trial period before the owner asks for a fee?

Freeware

Shareware

Public Domain

Commercial software

47. When order supplies for her business office, Nina must consider envelopes for business letters and a small form frequently mailed out to clients. If the catalog offers various sizes of business envelopes, MOST likely what will be the sizes for small and large business envelopes?

Small 6.5 and large 14

Small 3.5 and large 12

Small 6 3/4 and large 10

None of the above is correct

48. How many inches are used for the left margin in an unbound report?

1

1.5

2

2.5

49. Which function is used to calculate a specific outcome based on various sets of data?

AVG

COUNT

SUM

IF

Database Skill

1. Which of the following is NOT an example of software?

2.

What first name or nickname would you like us to use?

2. What is the term used for making changes to a document to make it more visually appealing? These changes may include Spell Check, Bold, Underline, and Italics.

3. All formulas begin with which symbol?

4. After a long discussion on memorandums, the class is given a pop quiz to determine their understanding of the parts of a memorandum. How should a student answer the following question: "Which if the following is NOT a guide word used in memorandums?"

5. Keyboarding is also known as:

6. Which of the following is NOT an example of hardware?

7. A well known scientist has just completed a spreadsheet to perform calculations related to his latest experiment. One of the calculations requires for a range of cells to be averaged. Which function will he use to calculate the average in a range of cells?

8. Wanda needs to enter a formula to calculate payroll information for her employees. She is multiplying the hours worked by the rate of pay. What is the symbol used for multiplication operations in a spreadsheet?

9. Which type of chart would be used to BEST display the percentage of books read by boys in 8th grade? This type of chart is great for showing the parts of a whole.

10. Ergonomics is the science of designing a workspace for comfort and safety. Which suggestion will make your computer workstation more comfortable?

11. If you wanted to respond to an advertisement posted by your favorite restaurant, which type of correspondence would be MOST appropriate?

12. What is the term used for the most common way to input data into a computer?

13. If Susan purchases a single-user license for a word processing program, on how many computers can she legally install the software?

14. Which of the following is NOT a part of the information processing cycle?

15. Which of the following is NOT a part of an email address?

16. Which type of software is frequently used by people to calculate data using formulas or functions?

17. Karen has spent a lot of time researching options for her new desk and chair. She wants to sit at a 90 degree angle and have her monitor at the right distance for viewing. What the term used for designing a workstation to be safe and comfortable?

18. Which type of printer provides the BEST quality of printer documents?

19. Yolanda has just written a letter for her Language Arts portfolio and is preparing for her test. After reviewing her notes and referencing her handout, how does she answer the question: "Which of the following is NOT a part of a letter?"

20. Cindi is typing a report on the natural habitat of her favorite animals. To make sure she earns the highest possible grade she carefully considers her report formatting notes. How many inches will she use for the left margin of a leftbound report?

21. Which type of virus is created to multiply itself and use up system resources?

22. When typing a report, how many inches are used for the top margin of the Title/Cover page?

23. Which term BEST describes the technology that enables computers to communicate the transmission of text, numeric, voice and/or video data from one computer to another computer?

24. What is the term used for the printed copy of data?

25. Sharon wants to do a great job for her graduation project. After months of research and study on dance techniques of various cultures she has decided to present a visually stunning slideshow presentation to the judges. What type of software should Janet use to create the slideshow?

26. A network consists of at least two computers being connected together. Which of the following is a type of network?

27. When considering paper choices for his report, Orlando decides to go with a standard sheet. What are the measurements of a standard sheet of paper?

28. Which piece of hardware is a device that processes the data entered into a computer?

29. What is the term used for the physical parts of a computer system?

30. Which type of software is used to manage the resources of a computer? This type of software helps the application software interface with peripheral devices and memory of the computer.

31. Which type of virus is created to do something different than what is expected?

32. Which type of memory is long term memory? This is the type of memory where the instructions needed to boot the computer are stored.

33. What is the term used for the address of the writer of a letter?

34. When you purchase a new CD just released by your favorite artist, how many copies can you legally make? Why?

35. Juan is asked to type a report on his favorite sport. The guidelines ask for double-spacing within the paragraphs. How many blank lines are used in double spacing lines of text?

36. Databases are used to manage large amounts of data. Some examples are: catalogs, inventories, and address book information. Which is NOT a benefit of a computerized database?

37. While manipulating a database of the planets, Sandra considers locating information on planets beginning with the letters M and N. Which type of sort will Sandra use to arrange all of the planets by name in alphabetical order?

39. Which type of chart is used to BEST display trends and comparisons? This chart works well for showing similarities and differences between two sets of data.

40. What is the term used for the type of software used to view documents over the World Wide Web?

41. If you want to communicate new ideas to your employees, which type of correspondence is MOST appropriate to use?

42. Karina has decided to mail a personal business letter to her favorite restaurant. She uses a standard sheet of paper and has along the short edge of the paper. What is the term used for her page orientation?

43. Which of the following is NOT a characteristic of short term memory?

44. Lucas never wants to type using his keyboard. So he has decided to purchase software that will type as he speaks into a microphone. What type of software has Lucas purchased?

45. When guide words are typed in upper/lower case, which of the following is the appropriate formatting?

46. Which type of software can be used for a trial period before the owner asks for a fee?

47. When order supplies for her business office, Nina must consider envelopes for business letters and a small form frequently mailed out to clients. If the catalog offers various sizes of business envelopes, MOST likely what will be the sizes for small and large business envelopes?

48. How many inches are used for the left margin in an unbound report?

49. Which function is used to calculate a specific outcome based on various sets of data?