COA QUESTION - DECEMBER 2017

COMPUTER ON OFFICE AUTOMATION QUESTION - JULY 2017
Fill in the Blanks
  1. GUI stands for _____________.
  2. The brain of any computer system is _____________ .
  3. To select all text, the shortcut key used is _____________ .
  4. _____________ is a database management software.
  5. The _____________ command will allow user to change between directories in Linux.
  6. Open Office _____________ is similar to Microsoft Excel.
  7. Handouts can be printed in MS _____________ .
  8. WhatsApp uses the _____________ to send message and videos.
  9. Excel's _____________ feature is used to summarise workbooks into one worksheet.
  10. Broadband wireless technology is also known as _____________.
Match the Following:
1. Plotter - a. Database
2. Forms - b. Output Device
3. Slide - c. Used to edit / display data
4. Font Style - d. Impress
5. Writer - e. Formatting Tool Bar
6. Google - f. Spreadsheet
7. Taskbar - g. Quick Launch Toolbar
8. Locking cells - h. Word Processor
9. Mozilla Firefox - i. Search Engine
10. Collection of Tables - j. Web Browser

Choose the Correct Answer
1. A list of instructions used by a computer is called as __________.
a. CPU b. Text
c. Program d. Output
2. USB is expanded as __________.
a. Universal Slide Bus b. Universal Serial Bus
c. Updated System Bus d. Universal System Bus
3. The font size of the selected text can be increased one point every time by pressing __________.
a. Ctrl + [ b. Ctrl + ]
c. Ctrl + } d. Ctrl + {
4. Ctrl+ B will ________.
a. print the text b. paste the selected text
c. begin new text file d. bold the selected text
5. The shortcut key for Find & Replace dialog box in MS Excel ________.
a. Ctrl+H b. Ctrl+F
c. Ctrl+R d. Ctrl+Shift+F
6. ________ is a type of Application Software.
a. Android b. Windows
c. Linux d. MS Office
7. The default extension of MS Excel file is _________.
a. .exls b. xlsx
c. .exlx d. xlmf
8. What is the maximum length of a filename in Linux?
a. 32 bytes b. 64 bytes
c. 512 bytes d. 255 bytes
9. Which command is used to change password in Linux?
a. pwd password
c. passwd chpwd
10. Twitter is not a _________.
a. browser b. mobile app
c. application software d. social network

True or False
  1. Input and Output devices are classified as peripheral devices.
  2. Root is the name of normal user account in Linux.
  3. My Documents contains only MS Word documents.
  4. To apply center alignment to a paragraph the shortcut key is Ctrl+N.
  5. Image and Text can be used as water mark in Word document.
  6. Pie charts are used for comparing a given category with the total.
  7. Update query in Open Office Base is available in MS Access.
  8. Videos cannot be played using MS Powerpoint.
  9. Bing is an example of search engine.
  10. Skype is a type of weather forecasting mobile App.
Write answer in two or three lines
  1. What is RTOS?
  2. Differentiate Blu-Ray from DVD.
  3. How to view computer details in Windows?
  4. What is the difference between Process and Thread?
  5. Write any two disadvantages of MS-Office.
  6. What is the use of header and footer in MS Word document?
  7. How cells are referred in MS Excel? Give an example.
  8. What is Open Office Impress? What is the file extension and its uses?
  9. What are the uses of Database?
  10. Explain any two data function in Open Office Calc.
  11. What are websites and URL(s)?
  12. Differentiate tablet from smartphone.
  13. What is presentation template in Powerpoint? Give an Example.
  14. What are the uses of reports in MS Access?
  15. List the connecting ports available in Computer.
Write answer in brief
  1. a. Explain the working principle of a computer with the help of a block diagram. (or)
    b. What is data communication? Explain the various types of Networks.
  2. a. With a neat sketch explain the parts of windows. (or)
    b. Explain the basic components of Linux.
  3. a. Compare Microsoft Offie and Open Office. (or)
    b. Explain te steps involved in creating forms with an example in Open Office Base.
  4. a. Explain how contents of a book are created in MS Word. (or)
    b. Name the different types of Charts in MS Excel with necessary diagrams.
  5. a. How will you create queries and reports in MS Access? (or)
    b. How will you create presentation in MS PowerPoint?
  6. a. What is a web browser? What are the different browsers available? (or)
    b. Explain the procedures for creating an Email-id and attaching files.
ANSWERS FOR ONE WORD QUESTIONS - JULY 2017
Fill in the Blanks
  1. Graphical User Interface
  2. CPU (Central Processing Unit)
  3. Ctrl + A
  4. Access
  5. cd
  6. Spreadsheet
  7. PowerPoint
  8. Internet
  9. Consolidate
  10. Wireless fidelity (Wi-Fi)

Answer for Match the Following:
1. Plotter - a. Output Device
2. forms - b. Used to edit / display data
3. Slide - c. Impress
4. Font Style - d. Formatting Tool Bar
5. Writer - e. Word Processor
6. Google - f. Search Engine
7. Taskbar - g. Quick Launch Toolbar
8. Locking cells - h. Spreadsheet
9. Mozilla Firefox - i. Web Browser
10. Collection of Tables - j. Database

Answer for Choose the best answer
  1. Program
  2. Universal Serial Bus
  3. Ctrl + ]
  4. bold the selected text
  5. Ctrl + H
  6. MS Office
  7. .xlsx
  8. 255 bytes
  9. passwd
  10. browser
Answer for True or False
  1. True
  2. True
  3. False
  4. False
  5. True
  6. False
  7. True
  8. False
  9. True
  10. False
Answers