Application software - computer awareness questions - 2

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 Answer


Q2. 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 Answer


Q3. 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 Answer


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 Answer


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 Answer


Q7. 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 Answer


Q9. 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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


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 Answer


Q21. 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 Answer


Q22. 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 Answer


Q23. 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 Answer


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 Answer


Q26. How will you select the entire worksheet?

1. Ctrl + shift
2. Ctrl + X
3. Ctrl + W
4. Ctrl + A

View Answer / Hide Answer


Q27. 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 Answer


Q28. The sign that is used for creating an absolute cell reference is

1. #
2. $
3. @
4. %

View Answer / Hide Answer


Q29. 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 Answer


Q30. 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