HOME OFFICE AUTOMATION QUESTIONS



tally erp9 training

OFFICE AUTOMATION QUESTIONS

JUNE 2018
Time: Two Hours
Maximum Marks: 100

I. Fill in the Blanks (Answer all Questions)

10x1=10 marks
1.  The _________.is also called as the brain of the computer
2.  The operating system is the most common type of ___________System software
3.  ___________ is the shortcut key for help in windows.
4.  In Excel……………… creates automatically the sum
5.  ___________Commands used to count the total number of line, words, and character contained in linux file
6.  Open Office _______________ is similar to MS Word
7.  ______________ is the shortcut key for save in windows
8.  The default extension of open office base is ______________.
9.  Picture option is in the ______________ menu in MS Powerpoint
10. In E-mail terminology BCC stands for ________________.
10x1=10 marks


II. Match the following (Answer all Questions)

1. Joystick a. Page Style
2. RAM b. Ctrl+H
3. Presentation c. Excel
4. Gadgets d. Input Device
5. Internet Explorer e. Mobile Phone
6. Formula f. Impress
7. Open Office Base g. Bing
8. Formatting h. Primary Memory
9. Search Engine i. MS Access
10. Replace  j. Browser


III. Choose the Best Answer (Answer all Questions)


10x1=10 marks

1. Which one stores more data than a DVD?

a. CD-ROM
b. Floppy Disc
c. Blue Ray Disc
d. Red Ray Disc

2. The output shown on the computer monitor is called

a. VDU
b. HARD COPY
c. SCREEN COPY
c. Softcopy


3. Which of the following is not a type of page margin in MS-WORD?

a. Left
b. Right
c. Centre
d. Top

4. Subscript, Superscript, Strikethrough in MS-word are also know as

a. Font Face
b. Font Style
c. Font Effects
d. Font Format

5. Doughnut is a type of ______________chart in Excel

a. Bar
b. Column
c. Line
d. Pie

6. A_____________ enable to view data from a table based on a specific criterion in MS-Access

a. Form
b. Query
c. Report
d. Macro


7. What command is used to create directory in Linux?

a. Type
b. Mddir
c. Cd
d. Rd

8. To Print Powerpoint presentation slide, Press

a. Ctrl+P
b. Ctrl+T
c. Ctrl+C
d. Ctrl+I

9. E-mail Address is made up of

a. Single Part
b. Three Parts
c. Four Parts
d. Two Parts

10. A Webpage’s front page/main page is called as____________

a. Browser Page
b. Contact Page
c. Home Page
d. Products Page

IV. Say True or False (Answer all Questions)

10x1=10 marks

1. Calbri is the default font of a MS-Word 2007 document
2. SMPS stands for Simple Mode Power Supply
3. The Protect sheet option can be found in the review tabs of the ribbon
4. Hard Disk, DVD belongs to Primary Memory.
5.The process of removing unwanted part of an image in MS PAINT is know as bordering
6. By running whoami command the user can gather information about themselves in Linux OS
7. Field length does not appear when you open the table in the table design view in MS-Access
8. In Impress, F5 key used to view slide show.
9. Skype is telecommunication application software that specialize voice calls between computer.
10. Writer is full featured word processor in MS-OFFICE

V. Write short answers for the following:

(15 x 2 =30)

1. What are the major features of MS-WORD?
2. What is sound card ?
3. How can you create charts using MS-EXCEL.
4. What are the uses of forms in MS-ACCESS?
5. How do you open a file in Impress ?
6. What is primary key and what is its use in MS-Access
7. What is OpenOffice.org
8. Write about Quick Launch Tool Bar
9. What is an Open Office Impress?
10. How can you move a filed in a table in Open Office Base
11. What are the components of CPU?
12. What do you know about sorting in MS-Excel
13. How can you close an application in windows that is not responding?
14. Write any two applications using tablets.
15. What are the different types of internet Connections?

VI. Write answers in detail:

( 6 x 5 = 30 marks )

1. a. Describe about the history and generation of computers

or

b. Briefly Explain the types of computer.

2. a. Explain the functions of operating systems.

or

b. Explain the following Linux Commands: i. tail ii. Diff iii. Mv iv. more

3. a. What is meant by adding effects to the PowerPoint presentation? Briefly Explain.

or

b. Explain various types of adding graphics to the power point presentation?

4. a. Explain about working with documents in Open Office writer.

or

b. Explain the steps to create and insert charts in Open Office Calc.

5. a. What are the different ways of creating a table in MS-ACCESS database

or

b. Explain the different sections of reports in MS-ACCESS

6. a. What is auto fill in MS-EXCEL. Explain any three inserting function in MS-Excel

or

b. Write notes on i. Whatsapp ii. UC BROWSER


VIEW ANSWER

HOW TO INSTALL LINUX BOSS IN OUR SYSTEM?