1. Shortcut key for printing document is?
a. ALT+P
b. Ctrl+M
c. Ctrl+P
d. Ctrl+I
Correct Answer: Ctrl+P
Explanation: Ctrl+P is the shortcut key for windows and almost all application to print..
2. .Paste Special allows some operation where you paste to new cell. Which of the following operation is valid?
a. Square
b. Percentage
c. Goal Seek
d. Divide
Correct Answer: Divide
Explanation: Excel lets you divide the selected cells with the copied cells when pasting using Paste Special Function. Please see the figure..
3. What is the quickest way to select entire worksheet?
a. Choose edit, select all from the menu
b. Click on the first column, press Ctrl, and then click on the last column
c. Click on first column, press Shift, and then click on the last column
d. Click on the rectangle box on the upper left corner where column headings and row headings meet
Correct Answer: Click on the rectangle box on the upper left corner where column headings and row headings meet
Explanation: The quick way to select entire column is to click on column heading; entire row by clicking row heading and entire worksheet by clicking on the box on intersection of row and column heading.
4. A numeric value can be treated as label value if …… precedes it.
a. Apostrophe (‘)
b. Exclamation (!)
c. Hash (#)
d. Tilte (~)
Correct Answer: Apostrophe (‘)
Explanation: Excel recognizes numbers and text and aligns numbers to the right and text to the left of cell. However, you can override this by placing an apostrophe at the beginning of number to enter it as text.
5. How to display updatable current date in MS Excel?
a. Date()
b. Today()
c. Now()
d. Ctl+;
Correct Answer: Today()
6. A function inside another function is called….
a. Nested round function
b. Sum function
c. Sum function
d. Text function
Correct Answer: Nested Function.
7. If 10/2 entered in a cell without applying any formats, excel will treat this as
a. Fraction
b. Number
c. Date
d. Text
Correct Answer: Date
Explanation: If you enter 10/2 without any format, excel will consider it as 2nd of October and enter it as date value.
8. Which of the following shortcuts can be used to insert a new line in the same cell?
a. Enter
b. Alt+Enter
c. Ctrl+Enter
d. Shift+Enter
Correct Answer:Alt+Enter
Explanation: Alt+Enter works as hard line break when you are typing inside an Excel cell..
9. Chart type to visually compare values across a few categories is …?
a. Pie
b. Column
c. Line
d. Area
Correct Answer: Pie
10. Workbook is collection of?
a. Cells
b. Worksheets
c. Workspaces
d. Projects
Correct Answer: Worksheets
Explanation: A workbook.may contain worksheets, chart sheets, module sheets.
11. Microsoft Access is a
a. RDBMS
b. OODBMS
c. ORDBMS
d. Network Database Model
Correct Answer: RDBMS
Explanation: MS Access is Relational Database Management System.
12. Which of the following is not a type of Microsoft Access Database Object?
a. Table
b. Form
c. Worksheet
d. Module
Correct Answer: Worksheet
Explanation: Access database objects are: Tables, Queries, Forms, Reports, Macro, and Module.
13. In a relational schema, each tuple is divided into fields called
a. Relations
b. Domains
c. Queries
d. All of the above
Correct Answer: Domains
Explanation: In relational terminology tables are called relations and fields are called attributes.
14. Which of the following is not an option when printing handouts?
a. Six slides per page
b. Five slides per page
c. Three slides per page
d. Two slides per page
Correct Answer: Five slides per page
15. What is a motion path??
a. A type of animation entrance effect
b. A method of advancing slides
c. A method of moving items on a slide
d. All of the above
Correct Answer: A method of moving items on a slide
Explanation: Motion path is the custom animation effect not slide transition effect. Using motion path you can define how an object will move in a slide.
16. Communication channel is shared by all the machines on the network in
a. Broadcast network
b. Unicast network
c. Multicast network
d. None of above
Correct Answer: Broadcast network
Explanation: In broadcast network all the nodes share same communication channel.
17. Which one of the following extends a private network across public networks?
a. Local area network
b. Virtual private network
c. enterprise private network
d. storage area network
Correct Answer: Virtual Private Network
Explanation: Virtual Private Network or VPN are the private networks across the public network.
18. Which of the following memories needs refreshing?
a. SRAM
b. DRAM
c. ROM
d. All of above
Correct Answer: DRAM
Explanation: DRAM is dynamic RAM which is most volatile in nature. The data in DRAM is lost after a few milliseconds even while continuous power supply is given. Thus it needs to be refreshed periodically to retain data.
19. Which of the following have low failure rate?
a. Mechanical devices
b. Electronic devices
c. Electro-mechanical devices
d. None of above
Correct Answer: Electronic devices
Explanation: Among the given kinds, electronic devices have lower failure rate because it does not have mechanical parts to break down.
20. Any data or instruction entered into the memory of a computer is considered as
a. storage
b. output
c. input
d. information
Correct Answer: Input
Explanation: Any data or instruction that goes into the computer system (here memory) is known as input and comes out from system (computer system) is output. From memory to disk is storage and from disk to memory is loading.
21. Which of the following is not an application software package
a. Redhat Linux
b. Microsoft Office
c. Adobe PageMaker
d. Open Office
Correct Answer: Redhat Linux
Explanation: Redhat Linux is operating system based on linux kernel. It is system software and not application.
22. What is compiler
a. A compiler does a conversion line by line as the program is run
b. A compiler converts the whole of higher level program code into machine code in one step
c. A compiler is a general purpose language providing very efficient execution
d. None of above
Correct Answer: A compiler converts the whole of higher level program code into machine code in one step
Explanation: The first option indicates interpreter. Option C is invalid. Thus Option B is the correct answer.
23. ASCII stands for
a. American Stable Code for International Interchange
b. American Standard Case for Institutional Interchange
c. American Standard Code for Information Interchange
d. American Standard Code for Interchange Information
Correct Answer: American Standard Code for Information Interchange
24. Computer Virus is a
a. Hardware
b. Software
c. Bacteria
d. Freeware
Correct Answer: Software
Explanation: Computer viruses are computer software developed with mal-intention.
25. The device primarily used to provide hardcopy is the
a. CRT
b. Computer Console
c. Printer
d. Card Reader
Correct Answer: Printer
26. …… allows us to organize our files so we can more easily find them
a. Navigation
b. Folder
c. Desktop
d. None of above
Correct Answer: Folder
27. The … folder is the default place that most applications want to store data files in
a. Start menu
b. Recycle bin
c. Program files
d. My documents
Correct Answer: My Documents
Explanation: Among the given options Start menu is the list of available applications and options; Recycle bin is the location to store deleted files; Program files is the folder that store executable files of applications and My documents is the folder for use files.
28. …. Tool helps to reduce the access time from disk
a. Scandisk
b. Disk defragmenter
c. Backup
d. Format
Correct Answer: Disk defragmenter
Explanation; Disk defragmenter arranges the clusters of single file contiguously so that the reading from file is quicker. Thus it reduces the access time from disk.
29. Which is not true for operating system?
a. helps to execute applications
b. performs memory management
c. solves users actual problems
d. controls all the operations of computer
Correct Answer: solves users actual problems.
Explanation: Solving uses actual problems is the job of application software.
30. In computing what is the process by which a running computer system is restarted without the need to interrupt the power?
a. Hibernate
b. Warm boot
c. Cold boot
d. Restart
Correct Answer: Warm boot
31. Which file starts MS Word?
a. winword.exe
b. word.exe
c. msword.exe
d. word2003.exe
Correct Answer: winword.exe
Explanation: winword.exe is the starter file of MS Word. You can type winword.exe in Run dialog box and start the application without accessing menu.
32. Which of the following is not a valid list tag?
a. <al>
b. <li>
c. <ol>
d. <ul>
Correct Answer: <al>
Explanation: We don’t have any tag called <al>
33. Portrait and Landscape are
a. Page orientation
b. Paper size
c. Page layout
d. All of the above
Correct Answer: Page Orientation
34. How can you remove tab stop markers from ruler?
a. Double click on the tab marker and choose clear all
b. Drag the tab stop marker out of the ruler
c. Right click the tab stop marker and choose remove
d. All of above
Correct Answer: Drag the tab stop marker out of the ruler
Explanation: Option A is to clear all the markers and option C does not work. So option B is the correct answer.
35. Which of the following is not available on the Ruler of MS Word Screen?
a. Tab stop box
b. Left indent
c. Right indent
d. Center indent
Correct Answer: Center indent
Explanation: There is nothing like center indentation
46. To autofit the width of column
a. Double click the left border of column
b. Double click the right border of column
c. Double click the column header
d. All of above
Correct Answer: Double click the right border of column
37. Which one is the correct HTML tag for the largest heading?
a. head
b. h1
c. h6
d. header
Correct Answer: H1
Explanation: H1 is the highest level of heading and it is the largest one.
48. Where can you change the vertical alignment
a. Paragraph dialog box
b. Formatting toolbar
c. Page Setup dialog box
d. Standard toolbar
Correct Answer: Page Setup Dialog Box
Explanation: You can find vertical alignment in Layout tab of PageSetup dialog box.
39. Which of the following is not the merge process
a. soft the data source records
b. merge the two files to print or create a new document
c. edit data source
d. format main document
Correct Answer: Format main document
Explanation: Formatting main document is done while document designing but it is not merge process. You may need to sort, edit data source and merge them with main document.
40. Automatically placed drop cap in the line
a. 2 lines
b. 3 lines
c. 5 lines
d. 8 lines
Correct Answer: 3 lines
Explanation: 3 lines is the default behavior for drop cap.
Send us more question, we will provide the solution.
Thank You! Stay Safe.
@missionofficer
No comments:
Post a Comment