COA QUESTION - DECEMBER 2019

COMPUTER ON OFFICE AUTOMATION QUESTION – DECEMBER 2019
Fill in the Blanks
  1. _____________ is also called as the working memory of the CPU.
  2. _____________ key is used as shortcut for renaming the selected folder.
  3. GUI stands for____________.
  4. To get the symbol dialog box, click on the_____________ menu and choose symbol.
  5. A _____________ field can store alphanumeric characters, very long strings up to 65,538 characters.
  6. Open Office.org presentation program is called as _____________ .
  7. To prevent two words from being separated at the end of a line in Open Office Writer, press _____________ after the first word.
  8. The _____________ button is used to add up a series of numbers in MS Excel. Whenever the content is added or removed.
  9. _____________ formatting attribute causes a table to automatically resize whenever the content is added or removed.
  10. In Base, a table can be saved by pressing _____________ on the keyboard, animation and slide transition.
Match the Following:
1. MODEM - a. TCP
2. Refreshing Content - b. Underline
3. Insert Footnote - c. Alt + Ctrl + F
4. Replace - d. Orientation
5. Formatting Toolbar - e. Internet
6. Strikethrough - f. F5
7. Landscape - g. Ctrl + H
8. Displaying all objects Contained in document in Impress - h. Ctrl + Home
9. First field of first record - i. Line through the middle of the text
10. Connection Oriented Protocol - j. Navigator

Choose the Correct Answer
1. What type of resource is most likely to be a shared common resource in a computer network?
a. Printers b. Speakers
c. Floppy disk drive d. Keyboards
2. Which symbol is used with cat command for creating files.
a. < b. >
c. / d. *
3. _________ copies format from one place to another.
a. Format painter b. paint format
c. font set d. group
4. Which is not a font style.
a. Bold b. Superscript
c. Regular d. Italic
5. Which of the following data type is used to store logical value in MS Access?.
a. True/False b. On/Off
c. Yes/NO d. All
6. Which of the following is not a transition effect?
a. Blinds Diagonal b. Dissolve
c. Fade through black d. Blinds Vertical
7. FTP uses port _______for the control connection, and port _________is used for the data connection.
a. 20,21 b. 21,20
c. 20,20 d. 21,21
8. ________can be very helpful to align several objects such as graphics or tables.
a. Grid align b. Align graphics
c. Object align d. Snap to grid
9. Open Office.org presentation program has features like
a. Spelling checker b. Thesaurus
c. Text and background styles d. All
10. In Impress, which view shows thumbnail versions of all your slides arranged in horizontal rows.
a. Notes b. Slide sorter
c. Outline d. Handout

True or False
  1. Plotter is a graphical Input device.
  2. Write allows a user to move a file to another folder or directory.
  3. A blog is a website where entries are made in journal style and displayed in a reverse chronological order.
  4. The entry 345X will be treated as a text entry in Excel.
  5. The currency data type adapts to the region and language settings of the operating system.
  6. Power point limits the user to six colors for fill and line color changes.
  7. Slide sorter view enables you to easily move, copy or delete slides in Power point.
  8. Openoffice.org does not have a grammar checker.
  9. Delete with No action in Base will delete the record you want but will not delete the records associated with it.
  10. Data from any record can be placed in a report header.
Write answer in two or three lines
  1. What are the logical operations performed by ALU?
  2. What are the characteristics of a Laser Printer?
  3. Why is Linux called as open source operating system?
  4. State the procedure to find and replace a text.
  5. What is the use of paint brush format?
  6. Explain importing and exporting documents in Open office Writer?
  7. What is the “what if” condition in Excel formula?
  8. What are the benefits of using multiple worksheets?
  9. What are the types of reports in MS Access?
  10. What is a cascade delete?
  11. List the steps for inserting a picture in Power Point presentation?
  12. What is Placeholder?
  13. What will happen if you delete the bookmark at the end of the document in Open Office Writer?.
  14. Give the difference between MS Excel and Open Office Calc?
  15. Within Base, which command should a computer user execute prior to running a query to eliminate duplicate entries?
Write answer in brief
  1. a. Describe the applications of computer. (or)
    b. Elaborate on various output devices .
  2. a. Elaborate editing images with Microsoft paint. (or)
    b. Write about any five dialog boxes in MS Word
  3. a. List at least ten shortcut keys in MS Office and write their usage. (or)
    b. Explain security options and warning in Open office Writer?.
  4. a. Explain about sorting, filtering in MS Excel. (or)
    b. Explain any three chart types available in Excel?
  5. a. How do you import data from other database to MS Access with example? (or)
    b. How to create a query using the query design view in Base?
  6. a. What are the steps involved in printing handouts in impress? (or)
    b. Write in detail the steps involved to start a slide show of the Power point presentation with animation effect?
ANSWERS FOR ONE WORD QUESTIONS - DECEMBER 2019
Fill in the Blanks
  1. RAM
  2. F2
  3. Graphical User Interface
  4. Insert
  5. memo
  6. Impress
  7. transition
  8. Ctrl + S + Spacebar
  9. autosum
  10. Ctrl + S

Answer for Match the Following:
Match the Following:
1. MODEM - a. Internet
2. Refreshing Content - b. F5
3. Insert Footnote - c. Alt + Ctrl + F
4. Replace - d. Ctrl + H
5. Formatting Toolbar - e. Underlining
6. Strikethrough - f. Line through the Middle of the text
7. Landscape - g. Orientation
8. Displaying all objects Contained in document in Impress - h. Navigator
9. First field of first record - i. Ctrl + home
10. Connection Oriented Protocol - j. TCP

Answer for Choose the best answer
  1. Printers
  2. >
  3. Format Painter
  4. superscript
  5. Yes/No
  6. Dissolve
  7. 21,20
  8. Snap to grid
  9. All
  10. Slide sorter
Answer for True or False
  1. false
  2. false
  3. true
  4. true
  5. true
  6. false
  7. true
  8. false
  9. true
  10. false