COA QUESTION - JUNE 2019

COMPUTER ON OFFICE AUTOMATION QUESTION – JUNE 2019
Fill in the Blanks
  1. A computer free from tiresome and boredom is called _____________
  2. Linux is written in _____________ language.
  3. ____________shortcut key will display print preview.
  4. In MS Excel, every cell in a worksheet is identified using _____________
  5. Open Office Base uses _____________ as the field format for text fields.
  6. A collection of interconnected networks is called _____________ .
  7. Mobile phones know their locations because they are equipped with _____________ receivers.
  8. _____________ command compares files and shows where it differs.
  9. _____________ formatting attribute causes a table to automatically resize whenever the content is added or removed.
  10. _____________ menu provides options like animation scheme, custom animation and slide transition.
Match the Following:
1. Switch between open workbooks - a. Print last n lines
2. Tail - b. Mail Merge
3. Flash memory - c. Finds related records
4. Operating systems - d. Video games
5. Envelope - e. Task Pane
6. Primary Key - f. Ctrl + F6
7. VLOOKUP function - g. TCP
8. Connection Oriented Protocol - h. Mirrored Margin
9. Inner Margin - i. Interface between user and computer
10. Slide master in open - j. No Duplicates

Choose the Correct Answer
1. The term GIGO is related to ________.
a. Speed b. Accuracy
c. Reliability d. Automatic
2. ________ command shows the first part of a file, just as much as will fit on one screen.
a. pipes b. news
c. more d. wall
3. _________ is the word processor component of OpenOffice.org
a. Impress b. Calc
c. Base d. Writer
4. Which function in Excel tells how many numeric entries are there?.
a. NUM b. COUNT
c. SUM d. CHKNUM
5. How to insert a function in Calc?.
a. Ctrl + F2 b. Ctrl + F4
c. Ctrl + F6 d. Ctrl + F10
6. Which of the following expresses correct order?
a. Characters, Fields, Records, Tables, Files, Databases b. Character, Fields, Records, Tables, Databases, Files
c. Database, Tables, Files, Records, Fields, Characters d. Files, Databases, Tables, Records, Fields, Characters
7. When entering field name, how many characters you can type in maximum?
a. 16 b. 64
c. 128 d. any num of character
8. Which of the following is not an option when printing handouts?
a. 6 slides per page b. 5 slides per page
c. 3 slides per page d. 2 slides per page
9. In Impress, which view shows thumbnail versions of all your slides arranged in horizontal rows.
a. Notes b. Slide sorter
c. Outline d. Handout
10. IEEE 802.16 is popularly known as _________.
a. WiMax b. WiMi
c. WiFi d. WiMa

True or False
  1. A computer can perform every calculation with the same accuracy.
  2. USB enables parallel communication.
  3. cd displays the current working directory.
  4. The operating system manages only one resource.
  5. Formatting bar is context-sensitive.
  6. VisiCalc is the oldest spreadsheet package.
  7. VARCHAR ignore case is a vaild datatype in Base.
  8. In MS Access, Yes/No field can have three states.
  9. Once a clip art image is added to a slide, it cannot be removed.
  10. Bridges are network layer devices.
Write answer in two or three lines
  1. Differentiate PROM and EPROM.
  2. What are the characteristics of a computer?
  3. Why Linux is secured than other operating system?
  4. List the functions of operating system.
  5. How can you create style template?
  6. what are thumbnails?
  7. what happens if you do not use the equal (=) sign with a formula in MS Excel?
  8. Write the difference between Ms Excel and Open Office Calc.
  9. What is a Database?
  10. Write about any three string functions used in Base?
  11. In MS Power point what is a placeholder?
  12. What is meant by graphic style in Impress?
  13. What is naming convention?.
  14. What are some of the factors that determine whether a communication system is LAN or WAN?
  15. What is UC Browser?
Write answer in brief
  1. a. Explain the basic components of a computer with a neat diagram. (or)
    b. Explain the different topologies used for constructing local area network.
  2. a. Write the purpose of the following linux commands:
    1. Cat 2. cmp 3. Wall 4. Kill 5. Pipes
    (or)
    b. Explain the functions of operating systems in detail.
  3. a. Explain security options and warning in Open office Writer? (or)
    b. How will you create a page break? Why is it needed?.
  4. a. Write short notes on: 1. Table handling 2. Find and replace data (or)
    b. Discuss the steps for renaming, copying and deleting tables?
  5. a. Explain the process for creating a view in Base? (or)
    b. Describe in detail the steps to open presentation in Impress and Ms powerpoint.
  6. a. What is search engine? Explain its functionality. (or)
    b. Compare Smart phone and Tablet?
ANSWERS FOR ONE WORD QUESTIONS - JUNE 2019
Fill in the Blanks
  1. Diligence
  2. C
  3. Ctrl + F2
  4. Name box
  5. Varchar
  6. Internet
  7. GPS
  8. cmp
  9. Autofit in pivot Table
  10. Animation

Answer for Match the Following:
Match the Following:
1. Switch between open workbooks - a. Ctrl + F6
2. Tail - b. Print last n lines
3. Flash memory - c. Video games
4. Operating systems - d. Interface between user and computer
5. Envelope - e. Mail Merge
6. Primary Key - f. No duplicates
7. VLOOKUP function - g. Finds related records
8. Connection Oriented Protocol - h. TCP
9. Inner Margin - i. Mirrored margin
10. Slide master in open - j. Task Pane

Answer for Choose the best answer
  1. Accuracy
  2. more
  3. Writer
  4. COUNT
  5. Ctrl + F2
  6. Characters, Fields, Records, Tables, Files, Databases.
  7. 64
  8. 5 slides per page
  9. Slide sorter
  10. WiMax
Answer for True or False
  1. true
  2. false
  3. false
  4. false
  5. true
  6. true
  7. true
  8. false
  9. false
  10. true
Answers