COA QUESTION - DECEMBER 2018

COMPUTER ON OFFICE AUTOMATION QUESTION – DECEMBER 2018
Fill in the Blanks
  1. Blue Ray Disk is an example of _____________ memory.
  2. Expansion of DVD is _____________ .
  3. The system tray is located in the windows. _____________ .
  4. Linux is an example for _____________ software.
  5. Function key for help is _____________ .
  6. _____________ is a Linux command used to display the content of file to all the logged in users.
  7. In MS word _____________ is the short cut key used for closing the current window.
  8. Internet explorer is an example for _____________ .
  9. Slide transition of impress is available on the _____________ menu.
  10. MS Access is a _____________ .
Match the Following:
1. SMPS - a. Blank Page
2. Computer Network - b. MS-Access
3. .Odp - c. Excel
4. Redirection Utilities - d. Power Supply
5. Portal - e. stdin, stdout
6. Spread sheet - f. Impress
7. Create Menu - g. ISDN
8. Insert - h. LAN
9. Broadband - i. DBMS
10. Open office base - j. Single point of Access

Choose the Correct Answer
1. From where can we change the name of an user account?
a. Setting b. Computer
c. Code Panel d. Control panel
2. Identify the false statement.
a. can find deleted file in recycle bin b. can restore files from recyle bin
c. can decrease free space of disk by sending files in recyle bin d. can right click and choose Empty Recycle Bin to clean it at once
3. In MS Word view menu Header and Footer are visible in ________.
a. Web Layout b. Page Layout
c. Print Layout d. Draft
4. We can Remove/Hide border of a shape in MS-word by selecting ___________.
a. No Line b. No Outline
c. White Line d. No Border
5. To see all the slides in one screen of MS-Powerpoint, we can use ________ from view menu.
a. Slide sorter b. slide
c. master d. slide show
6. Which operator is used to filter and display rows when all (2 or more) conditions are satisfied?
a. RANGE b. IN
c. ALL d. AND
7. What Linux command is used to terminate or restart processes?
a. who b. cat
c. kill d. tail
8. How to insert a function in calc?
a. Ctrl + F2 b. Ctrl + F4
c. Ctrl + F6 d. Ctrl + F10
9. Which is not a filter in Calc?
a. Auto Filter b. Standard filter
c. Advanced filter d. Normal filter
10. A web address is also called as __________.
a. URL b. ULR
c. RLU d. LUR

True or False
  1. EEPROM stadns for Error Erasable Programmable Read Only Memory.
  2. Laser printer is a type of printer which uses pins impacting on ink ribbon to print.
  3. RTOS is an operating system.
  4. Impress cannot be used for commercial purpose.
  5. Linux is not a secure Operating system.
  6. The transfer of data from a CPU to the peripheral devices of a computer is achieved through computer ports.
  7. Primary Key is used to set a unique field.
  8. Openoffice calc is not the part of Openoffice package.
  9. DSL stands for Digital Special Line.
  10. A track changes is a way of MS-Word to keep track of the changes made to a document.
Write answer in two or three lines
  1. What is the procedure for inserting symbols in MS Word documents?
  2. What is sorting? How can you sort a cell range in MS Excel?
  3. How can you create MS Access forms and mention its use?
  4. How do you create and save a file in Calc?
  5. List out any four drawing tools in OpenOffice Writer?
  6. What are LINUX permissions?
  7. What is template in impress?
  8. Write any two types of reports in OpenOffice Base.
  9. What is a chart in MS Excel? Name 3 types of charts?
  10. How can we insert date and time in Excel?
  11. What is query in MS-Access? Name two types of queries?
  12. What is trigger, in context of animations in Powerpoint?
  13. What is Search Engine? Give an Example.
  14. What is the expansion of modem?
  15. What is trash?
Write answer in brief
  1. a. Explain about the input and output devices. (or)
    b. Explain the various components of CPU.
  2. a. Write a shore notes on:
    1. Multitasking 2. Wordpad 3. Hotkeys
    (or)
    b. Explain the following Linux commands. 1. news; 2. mail; 3. merge; 4. chmod
  3. a. Explain any three applications that come with Openoffice.org? (or)
    b. What is a slide transition? Mention any three transition effects in Impress.
  4. a. Explain about Quick Access tool bar and Format painter in MS word. (or)
    b. What are the salient features of MS Access?
  5. a. Differentiate the absolute and relative addressing in MS-Excel with an example? (or)
    b. Explain advanced filtering in MS Excel.
  6. a. What are the steps to import data from MS-Excel to MS-Access? (or)
    b. What are the different types of Internet connections? Explain.
ANSWERS FOR ONE WORD QUESTIONS - DECEMBER 2018
Fill in the Blanks
  1. Secondary
  2. Digital Video Disc
  3. Taskbar
  4. System
  5. F1
  6. Wall
  7. Alt + F4
  8. browser
  9. Animation
  10. Relational Database Management System.

Answer for Match the Following:
1. SMPS - a. Power Supply
2. Computer Network - b. LAN
3. .Odp - c. Impress
4. Redirection Utilities - d. stdin, stdout
5. Portal - e. Single point of Access
6. Spread sheet - f. Excel
7. Create Menu - g. MS-Access
8. Insert - h. Blank Page
9. Broadband - i. ISDN
10. Open office base - j. DBMS

Answer for Choose the best answer
  1. Control Panel
  2. Can decrease free space of disk by sending files in recycle bin
  3. Print Layout
  4. No outline
  5. Slide sorter
  6. AND
  7. Kill
  8. Ctrl + F2
  9. Normal filter
  10. URL
Answer for True or False
  1. False
  2. False
  3. True
  4. False
  5. False
  6. True
  7. True
  8. False
  9. False
  10. True
Answers