COA QUESTION - JULY 2017

COMPUTER ON OFFICE AUTOMATION QUESTION - JULY 2017
Fill in the Blanks
  1. CPU stands for _____________.
  2. _____________ and Portrait are page orientation.
  3. _____________ function displays a row data in a column or a column data in a row.
  4. Special effects used to introduce slides in a presentation are known as _____________.
  5. _____________ key is pressed for spell checking.
  6. _____________ is the command used to remove directory in Linux.
  7. Open Office _____________ is similar to MS Access.
  8. www stands for _____________.
  9. Open Office _____________ is used for processing word document.
  10. In E-Mail terminology cc stands for _____________.
Match the Following:
1. Cache memory - a. Browser
2. Opera - b. Impress
3. Linux - c. Post
4. Presentation - d. High speed data access
5. Blog - e. Operating System
6. VLOOKUP - f. Formatting
7. Calc - g. Excel
8. Page Style - h. Spreadsheet
9. Queries - i. Messenger
10. WhatsApp - j. Access

Choose the Correct Answer
1. Where is RAM located?
a. Expansion Board b. External Drive
c. Motherboard d. All the above
2. Full form of URL is __________.
a. Uniform Resource Locator b. Uniform Resource Link
c. Uniform Registered Link d. Uniform Resourced Locator
3. Where are saved files stored in the computer?
a. RAM b. Cache
c. Hard disk d. ROM
4. Linux is an ________
a. malware b. Operating System
c. application program d. firmware
5. 1 Megabyte is equal to
a. 1024 bytes b. 1024 KB
c. 1024 GB d. 1024 bits
6. Microsoft Office is a type of ________.
a. System Software b. Application Software
c. Utility Software d. firmware
7. The default extension of calc file is _________.
a. .odf b. odw
c. .ods d. odcalc
8. To open an existing database, press ____________ in the keyboard.
a. Ctrl + N b. Ctrl + O
c. Ctrl + X d. Ctrl + S
9. To insert a new slide in PowerPoint, press _______ in the keyboard.
a. Ctrl + M Ctrl + D
c. Ctrl + T Ctrl + J
10. What is the keyboard shortcut for creating a new document in Open Office Writer?
a. Ctrl + V b. Ctrl + N
c. Ctrl + Z d. Ctrl + X

True or False
  1. One byte is equal to 8 bits.
  2. OMR stands for Optical Message Reader.
  3. The function key F5 is used to check spelling.
  4. Ctrl + I is used to bold text or remove bold formatting.
  5. Alt + Y is used to open the external data tab in MS Access.
  6. Sound files cannot be added to a slide.
  7. Skype is an application to chat in Video.
  8. Ubuntu OS is not based on Linux OS.
  9. In Linux everything is stored as a file.
  10. It is possible to export drawings as Macromedia Flash Files in Open Office Impress.
Write answer in two or three lines
  1. What is the use of Port?
  2. What for scrollbars are used?
  3. List the advantages of mail merge feature.
  4. How do you open a file in Calc?
  5. What are the uses of reports in Open Office Base?
  6. List the effects that can be used to imporve the presentation.
  7. What are websites and URLs?
  8. Differentiate workbook and worksheet in Calc.
  9. Define notepad.
  10. Is Open Office compatible with Microsoft Office? Explain
  11. How can you customize your desktop?
  12. What are the uses of header and footer in MS Word?
  13. What are the advantages of E-Mail?
  14. Define a text box. How will you insert a text box in your document.
  15. What is sorting? How can you sort a cell range in MS Excel?
Write answer in detail
  1. a. Explain about input and output devices. (or)
    b. Explain the characteristics of a Computer.
  2. a. Explain the features of Linux. (or)
    b. Explain the following linux commands: 1. cat; 2. wc; 3. mkdir; 4. rmdir; 5. who
  3. a. Compare Microsoft Office and Open Office. (or)
    b. Explain how can you add auto shapes in a document?
  4. a. How will you use auto fill in MS Excel? Name the different types of charts in MS Excel. (or)
    b. How will you create and insert charts in Open Office Calc?
  5. a. Explain the types of fields available in MS Access table. (or)
    b. Explain the steps to create a Presentation in Open Office Impress.
  6. a. What is a web browser? What are the different browsers available? (or)
    b. How will you attach files to your mail? What are the issues to be considered while attaching files?
ANSWERS FOR ONE WORD QUESTIONS - JULY 2017
Fill in the Blanks
  1. Central Processing Unit.
  2. Landscape
  3. Transpose
  4. Transitions.
  5. F7
  6. rmdir
  7. base
  8. World Wide Web.
  9. Writer
  10. Carbon Copy.

Answer for Match the Following:
1. Cache memory - a. High speed data access
2. Opera - b. Browser
3. Linux - c. Operating System
4. Presentation - d. Impress
5. Blog - e. Post
6. VLOOKUP - f. Excel
7. Calc - g. Spreadsheet
8. Page Style - h. Formatting
9. Queries - i. Access
10. WhatsApp - j. Messenger

Answer for Choose the best answer
  1. Motherboard
  2. Uniform Resource Locator
  3. Hard disk
  4. Operating System
  5. 1024 KB
  6. Application Software
  7. .ods
  8. Ctrl+O
  9. Ctrl+M
  10. Ctrl+N
Answer for True or False
  1. True
  2. False
  3. False
  4. False
  5. True
  6. False
  7. True
  8. False
  9. True
  10. True
Answers