COA QUESTION - DECEMBER 2019
COMPUTER ON OFFICE AUTOMATION QUESTION – DECEMBER 2019
Fill in the Blanks
- _____________ is also called as the working memory of the CPU.
- _____________ key is used as shortcut for renaming the selected folder.
- GUI stands for____________.
- To get the symbol dialog box, click on the_____________ menu and choose symbol.
- A _____________ field can store alphanumeric characters, very long strings up to 65,538 characters.
- Open Office.org presentation program is called as _____________ .
- To prevent two words from being separated at the end of a line in Open Office Writer, press _____________ after the first word.
- The _____________ button is used to add up a series of numbers in MS Excel. Whenever the content is added or removed.
- _____________ formatting attribute causes a table to automatically resize whenever the content is added or removed.
- 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
- Plotter is a graphical Input device.
- Write allows a user to move a file to another folder or directory.
- A blog is a website where entries are made in journal style and displayed in a reverse chronological order.
- The entry 345X will be treated as a text entry in Excel.
- The currency data type adapts to the region and language settings of the operating system.
- Power point limits the user to six colors for fill and line color changes.
- Slide sorter view enables you to easily move, copy or delete slides in Power point.
- Openoffice.org does not have a grammar checker.
- Delete with No action in Base will delete the record you want but will not delete the records associated with it.
- Data from any record can be placed in a report header.
Write answer in two or three lines
- What are the logical operations performed by ALU?
- What are the characteristics of a Laser Printer?
- Why is Linux called as open source operating system?
- State the procedure to find and replace a text.
- What is the use of paint brush format?
- Explain importing and exporting documents in Open office Writer?
- What is the “what if” condition in Excel formula?
- What are the benefits of using multiple worksheets?
- What are the types of reports in MS Access?
- What is a cascade delete?
- List the steps for inserting a picture in Power Point presentation?
- What is Placeholder?
- What will happen if you delete the bookmark at the end of the document in Open Office Writer?.
- Give the difference between MS Excel and Open Office Calc?
- Within Base, which command should a computer user execute prior to running a query to eliminate duplicate entries?
Write answer in brief
- a. Describe the applications of computer. (or) b. Elaborate on various output devices .
- a. Elaborate editing images with Microsoft paint. (or)b. Write about any five dialog boxes in MS Word
- 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?.
- a. Explain about sorting, filtering in MS Excel. (or) b. Explain any three chart types available in Excel?
- 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?
- 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
- RAM
- F2
- Graphical User Interface
- Insert
- memo
- Impress
- transition
- Ctrl + S + Spacebar
- autosum
- 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
- Printers
- >
- Format Painter
- superscript
- Yes/No
- Dissolve
- 21,20
- Snap to grid
- All
- Slide sorter
Answer for True or False
- false
- false
- true
- true
- true
- false
- true
- false
- true
- false