Application software - computer awareness questions - 1
Q1. If you use shortcut key F11 to create a chart on chart sheet then it creates
1. Three dimensional line chart
2. Three dimensional column chart
3. Two dimensional bar chart
4. Two dimensional column chart.
View Answer / Hide AnswerANSWER: Two dimensional column chart.
Q2. The popular DOS based spreadsheet package is
1. Word
2. Lotus1-2-3
3. Smart cell
4. Excel
View Answer / Hide AnswerQ3. A slide-title master pair is
1. A slide master and title master for a specific design template
2. A title area and text area of a specific slide
3. A slide master and title master merged into single slide.
4. None of the above
View Answer / Hide AnswerANSWER: A slide master and title master for a specific design template
Q4. How to select one hyperlink after another during a slide presentation?
1. Press Alt + shift
2. Press ctrl + H
3. Press Tab
4. Press ctrl + K
View Answer / Hide AnswerQ5. What can you print?
1. An entire worksheet
2. A single worksheet
3. A range of cells by range name
4. All of the above
View Answer / Hide AnswerQ6. Motion path is a
1. Method of moving items on a slide
2. Method of advancing slides
3. Type of animation entrance effect
4. All of the above
View Answer / Hide AnswerANSWER: Method of moving items on a slide
Q7. How can one create only horizontal page break?
1. By first selecting a row below the row where you want the page break to occur.
2. By selecting a cell in column A.
3. By selecting a cell in row1.
4. Both 1 and 2
View Answer / Hide Answer Q8. How can you link excel worksheet data to a word document?
1. With a hyperlink
2. With a copy and paste buttons on the standard toolbar.
3. With a right drag method
4. With a copy and paste special command
View Answer / Hide AnswerANSWER: With a copy and paste buttons on the standard toolbar.
Q9. Trigger in the context of animation is nothing but
1. An item on the slide that performs an action when clicked.
2. The name of a motion path
3. An action button that advances to the next slide.
4. None of the above
View Answer / Hide AnswerANSWER: An item on the slide that performs an action when clicked.
Q10. In what way the material that consists of text and numbers be best presented?
1. A bullet slide
2. A title slide
3. A table slide
4. None of the above
View Answer / Hide AnswerQ11. Choose the correct answer for the statement “You can create hyperlinks from excel work book to”
1. A web page on the internet
2. A web page on company internet
3. Other office 97 application documents
4. All of the above
View Answer / Hide AnswerQ12. The toolbar that provide different options in various master views is
1. Formatting toolbar
2. Drawing toolbar
3. Standard toolbar
4. Common task toolbar
View Answer / Hide AnswerANSWER: Common task toolbar
Q13. If a person wants to have a same look of all the slides in the presentation then he/she should use
1. Add a slide option
2. A presentation design template
3. The slide layout option
4. Outline view
View Answer / Hide AnswerANSWER: A presentation design template
Q14. How can you edit an embedded organization chart object?
1. By double clicking the organization chart object.
2. By right clicking the chart object, then clinking edit MS-organization chart object.
3. By clicking edit object
4. Both 1 and 2
View Answer / Hide Answer Q15. What is the advantage of using a spreadsheet?
1. Automatic calculations
2. Calculations are automatically updated if data is changed.
3. More flexibility
4. All of the above
View Answer / Hide AnswerQ16. We can add two kinds of sound effects files to the presentation of Microsoft PowerPoint and they are
1. .wav and .jpg
2. .wav and .gif
3. .wav and .mid
4. .jpg and .gif
View Answer / Hide AnswerQ17. The shortcut key to select more than one slide in a presentation is
1. Shift + click each slide
2. Shift + drag each slide
3. Ctrl + click each slide
4. Alt + click each slide
View Answer / Hide AnswerANSWER: Shift + click each slide
Q18. In an electronic database, when the words or phrases is being searched and if found then it is called
1. IT
2. Bug
3. Hit
4. Default
View Answer / Hide AnswerQ19. To a PowerPoint show one can add the file with extension
1. .jpg
2. .giv
3. .wav
4. All of the above
View Answer / Hide AnswerQ20. What do you mean by auto clipart?
1. That scans presentation for incorrect spelling in word arts objects
2. That scans presentation for incorrect spelling in your words on each slide
3. That automatically places clipart in your presentation
4. All of the above
View Answer / Hide AnswerQ21. Data are organized in a spreadsheet with the help of
1. Lines and spaces
2. Rows and columns
3. Layers and planes
4. Height and width
View Answer / Hide AnswerQ22. In a presentation, if special effects are used to introduce slides then it is called
1. Transitions
2. Effects
3. Custom animations
4. Present animations
View Answer / Hide AnswerQ23. During the slide show the shortcut menu can be shown by
1. Right clicking the current slide
2. Clicking an icon on the current slide
3. Clicking the shortcut button on the formatting
4. All of the above
View Answer / Hide AnswerANSWER: Right clicking the current slide
Q24. ____________is usually located below the title bar that provides categorized options.
1. Scroll bar
2. Status bar
3. Menu bar
4. Tool bar
View Answer / Hide Answer Q25. How the database gets updated when a customer makes an online hotel booking?
1. In pseudo real time
2. In batch mode
3. In 2 days
4. In 3 working days
View Answer / Hide AnswerANSWER: In pseudo real time
Q26. If you want to format text in word then the grouping that will be used is
1. Paragraphs, indexes and sections
2. Characters, sections and paragraphs
3. Indexes, characters and tables
4. Tables, paragraphs and indexes
View Answer / Hide AnswerANSWER: Characters, sections and paragraphs
Q27. What would you do to select all the boxes of an organization chart?
1. Click and edit select all
2. Press and hold the shift key and click each box.
3. Right click the chart background and then click select all
4. All of the above
View Answer / Hide AnswerQ28. What do you mean by DBMS?
1. Set of programs to update data
2. Collection of data
3. Set of programs to access data
4. All of the above
View Answer / Hide AnswerQ29. Which of the following is the centralized multi-user database?
1. Organ donor database
2. Barclays bank customer accounts
3. Airline reservations
4. All of the above
View Answer / Hide AnswerANSWER: Airline reservations
Q30. In order to add times to the slides in a presentation you can use
1. Rehearse timing button
2. Slide transition button
3. Slide show menu
4. All of the above
View Answer / Hide AnswerANSWER: Rehearse timing button
Q31. What do you call a database that contains tables linked by common fields?
1. Flat file database
2. Centralized database
3. Relational database
4. None of the above
View Answer / Hide AnswerANSWER: Relational database
Q32. Why do you use count command?
1. To count the number of records in an active database file
2. To count the number of data fields in an active database file
3. To count the records which are updated
4. To count the number of data files that are active
View Answer / Hide AnswerANSWER: To count the number of records in an active database file
Q33. What will happen if text was highlighted and ‘edit’ ‘copy’ was clicked?
1. Text would be removed from the document and placed in the clipboard
2. Text would be copied from the document and placed in the clipboard.
3. All of the above
4. None of the above
View Answer / Hide AnswerANSWER: Text would be copied from the document and placed in the clipboard.
Q34. A deleted footer placeholder in master view can be quickly reinstated by
1. Creating the new slide master
2. Reapplying the slide layout
3. Reapplying the footer placeholder
4. All of the above
View Answer / Hide AnswerANSWER: Reapplying the footer placeholder
Q35. When we cut and paste the item then where is the item that is cut will be temporarily stored?
1. RAM
2. Clipboard
3. ROM
4. Hard drive
View Answer / Hide AnswerQ36. Why to use copy structure command?
1. To copy all records of an active database to disk.
2. To copy contents of an active database to a new file
3. To copy structure of an active database to a new file.
4. To copy contents of an active database to disk.
View Answer / Hide AnswerANSWER: To copy structure of an active database to a new file.
Q37. In normal view, to quickly change to handout master view which one of the following is correct?
1. Press the shift key and click the handout master view button
2. On the view menu click slide sorter and click handouts
3. Click the outline tab and select handout master view.
4. None of the above
View Answer / Hide AnswerANSWER: Press the shift key and click the handout master view button
Q38. _________________ of a word document can be displayed in colour
1. Only text
2. All elements (if you have a colour printer)
3. Only graphics
4. None of the above
View Answer / Hide AnswerANSWER: All elements (if you have a colour printer)
Q39. In MS Access, to invoke the spell checker use the shortcut key
1. F7
2. F2
3. F10
4. Alt + F11
View Answer / Hide AnswerQ40. You are brought to the first slide in your presentation by using the command
1. Ctrl + End
2. Ctrl + Home
3. Page up
4. Next slide button
View Answer / Hide Answer