Application software - computer awareness questions - 2
Q1. What will you use if you want to keep track of addresses, phone numbers, parent/guardian names, class attendance, average and grades? Every so often you want to send reports home that select failing grades and excessive absences.
1. Access
2. Excel
3. PowerPoint
4. Word
View Answer / Hide AnswerQ2. What is the basic unit of worksheet into which you enter data in excel called?
1. Range
2. Cell
3. Tab
4. Box
View Answer / Hide AnswerQ3. The option which can be used to create charts in excel is
1. Pie chart
2. Bar chart
3. Chart wizard
4. Pivot table
View Answer / Hide Answer Q4. Who is the specialist incharge of the database of an organization?
1. DBMS
2. Database management
3. Database administrator
4. None of the above
View Answer / Hide AnswerANSWER: Database administrator
Q5. In a presentation, the transition effects for all slides can be best viewed by using
1. Outline view
2. Notes page view
3. Slide sorter view
4. Slide view
View Answer / Hide AnswerANSWER: Slide sorter view
Q6. The tool that enables you to add text to a slide without using the standard placeholders is
1. Auto shapes tool
2. Line tool
3. Drawing tool
4. Text tool box
View Answer / Hide AnswerQ7. To input data into database the devices that can be used is
1. Mouse
2. Keyboard
3. Touch screen
4. All of the above
View Answer / Hide Answer Q8. Which of the following is an additional set of commands that the computer displays afte you make a selection from the main menu?
1. Submenu
2. Menu selection
3. Dialog box
4. All of the above
View Answer / Hide AnswerQ9. In a presentation, the font size of text for all the notes in notes master view can be modified by
1. Modifying the slide design
2. Modifying the text within the body placeholder
3. Modifying the notes master layout
4. All of the above
View Answer / Hide AnswerANSWER: Modifying the text within the body placeholder
Q10. In a database a treelike structure of records is called
1. Multidimensional database structure
2. Sequential database structure
3. Hierarchical database structure
4. Relational database structure
View Answer / Hide AnswerANSWER: Hierarchical database structure
Q11. What do you mean by cell address A$4 in a formula?
1. Absolute cell reference
2. Mixed cell reference
3. Relative cell reference
4. None of the above
View Answer / Hide AnswerANSWER: Mixed cell reference
Q12. Where is the taskbar located?
1. On the start menu
2. At the top of the screen
3. On the quick launch toolbar
4. At the button of the screen
View Answer / Hide AnswerANSWER: At the button of the screen
Q13. For indexing the statement which is not valid is
1. It stores the corresponding record number
2. It maintains the alphabetically order
3. It duplicates the database file
4. It stores the index fields
View Answer / Hide AnswerANSWER: It duplicates the database file
Q14. Which one of the following options is correct to create uniform appearance by adding a background image to all slides?
1. Edit the slide master
2. Use the autocorrect wizard
3. Create a template
4. All of the above.
View Answer / Hide AnswerANSWER: Edit the slide master
Q15. In word how would you force a page break?
1. By positioning cursor at appropriate place and pressing F1 key
2. By positioning cursor at appropriate place and pressing ctrl + enter
3. By changing font size of the document
4. By using the insert/section break
View Answer / Hide AnswerANSWER: By using the insert/section break
Q16. The term used for creating, editing, formatting, storing, retrieving and printing a text document is
1. Database management
2. Web design
3. Presentation generation
4. Word processing
View Answer / Hide AnswerANSWER: Database management
Q17. What do you mean by cell address $A4 in a formula?
1. Absolute cell reference
2. Mixed cell reference
3. Relative cell reference
4. None of the above
View Answer / Hide AnswerANSWER: Mixed cell reference
Q18. Speaker note pages that show slides, related notes and your company logo on each page can be created by
1. Editing the handout master to include your company logo and one slide per page with additional note space.
2. Editing the notes master and add your company logo
3. Editing the slide master and insert your company logo and note space.
4. All of the above
View Answer / Hide AnswerANSWER: Editing the handout master to include your company logo and one slide per page with additional note space.
Q19. When is the enter key pressed when entering text within a document?
1. At the end of every word
2. At the end of every sentence
3. At the end of every line
4. At the end of every paragraph
View Answer / Hide AnswerANSWER: At the end of every paragraph
Q20. In excel, how would you bring together copies of workbooks that other users have worked on independently?
1. Compiling
2. Merging
3. Copying
4. Pasting
View Answer / Hide AnswerQ21. Each slide of a power point presentation can be displayed as a thumbnail and is useful for rearranging slides using
1. Notes page
2. Slide sorter
3. Slide master
4. Slide show
View Answer / Hide AnswerQ22. The header and footer button in power point can be found on the insert tab in
1. Tables group
2. Text group
3. Illustration group
4. Object group
View Answer / Hide AnswerQ23. Other than the cell where can the cell entry be edited?
1. Formula bar
2. Function bar
3. Edit menu
4. Menu bar
View Answer / Hide Answer Q24. What do you mean by cell address A4 in a formula?
1. Absolute cell reference
2. Mixed cell reference
3. Relative cell reference
4. None of the above
View Answer / Hide AnswerANSWER: Relative cell reference
Q65. We can plot only one data series in the
1. Column chart
2. Pie chart
3. Line chart
4. Bar chart
View Answer / Hide AnswerQ26. How will you select the entire worksheet?
1. Ctrl + shift
2. Ctrl + X
3. Ctrl + W
4. Ctrl + A
View Answer / Hide AnswerQ27. What is the shortcut key to open a new file in MS-Word?
1. Ctrl + N
2. Ctrl + A
3. Ctrl + F
4. Ctrl + S
View Answer / Hide AnswerQ28. The sign that is used for creating an absolute cell reference is
1. #
2. $
3. @
4. %
View Answer / Hide AnswerQ29. What is the letter and number of the intersecting column and row called?
1. Cell address
2. Cell location
3. Cell contents
4. Cell position
View Answer / Hide AnswerQ30. When an excel worksheet is saved, then the default extension of this is
1. .XML
2. .XLL
3. .XIS
4. .XLS
View Answer / Hide Answer