1.
Which is a spreadsheet package?
Correct Answer
D. All of above
Explanation
All of the options mentioned - Lotus, Excel, and Quattro Pro - are spreadsheet packages. Therefore, the correct answer is "All of above".
2.
What is the short-cut key to hide a row in Excel?
Correct Answer
A. Ctrl+9
Explanation
Ctrl+9 is the shortcut key to hide a row in Excel. This shortcut works by selecting the entire row and then hiding it. It is a quick and efficient way to hide rows that are not needed or contain sensitive information. By using this shortcut, users can easily manage and organize their data by hiding unnecessary rows without having to manually adjust the row height or delete the rows.
3.
What is the function of the network neighborhood?
Correct Answer
A. Navigate shared computers and folder in network
Explanation
The function of the network neighborhood is to navigate shared computers and folders in a network. It allows users to easily access and interact with resources that are shared on the network, such as files, printers, and other devices. This feature provides a convenient way to browse and connect to shared resources within a network environment.
4.
What is the function of Recycle Bin?
Correct Answer
A. Store deleted file
Explanation
The function of the Recycle Bin is to store deleted files. When a file is deleted from the computer, it is not permanently removed but instead moved to the Recycle Bin. This allows users to easily restore or recover accidentally deleted files. The Recycle Bin acts as a temporary storage location for deleted files until the user decides to permanently delete them or restore them to their original location.
5.
What is the shortcut key for superscript?
Correct Answer
D. Ctrl+shift++
Explanation
The correct answer for the shortcut key for superscript is Ctrl+shift++. This combination of keys allows the user to quickly format text or numbers as superscript. By pressing Ctrl+shift++ simultaneously, the selected text or number will be raised slightly above the baseline, giving it a smaller font size and appearing as a superscript.
6.
How many sheets are there in the excel workbook by default?
Correct Answer
A. 3
Explanation
By default, an Excel workbook consists of three sheets. These sheets are labeled as Sheet1, Sheet2, and Sheet3. These sheets provide the user with multiple tabs to organize and store different sets of data or information within a single workbook. Each sheet can be used for different purposes, such as storing data for different months or different departments within an organization.
7.
What is the function of a folder?
Correct Answer
A. Store files
Explanation
The function of a folder is to store files. Folders provide a way to organize and group related files together, making it easier to locate and manage them. By storing files in folders, users can maintain a structured file system, which helps in efficient file management and retrieval. Folders can be created, renamed, and deleted to suit the user's organizational needs. Additionally, folders can also be used to categorize files based on different criteria, such as project, topic, or file type.
8.
Which command is not an internal command of DOS?
Correct Answer
B. EDIT
Explanation
The command "EDIT" is not an internal command of DOS. Internal commands are built-in commands that are directly recognized and executed by the operating system. The "DIR" command is used to list the files and directories in a specified location, the "CD" command is used to change the current directory, and the "CLS" command is used to clear the screen. However, the "EDIT" command is not recognized as an internal command and is typically an external command or a third-party program used for text editing purposes.
9.
Which will be the title in Word to save summary status?
Correct Answer
A. Summary Info
Explanation
The correct answer is "Summary Info" because it is the most concise and clear option that accurately describes the purpose of saving the summary status. "Summary Information" is too long and redundant, "Summary" is too vague and lacks specificity, and "Sum Information" is grammatically incorrect and does not make sense. Therefore, "Summary Info" is the most appropriate and suitable title to save the summary status.
10.
Which of the following control is known as a drop-down list?
Correct Answer
B. Combo list
Explanation
A combo list is a control that allows users to select an option from a drop-down list. Unlike a text box, which allows users to enter any text, a combo list restricts the options to a predefined list. Therefore, a combo list is the correct answer for a control known as a drop-down list.
11.
In which O/S can you give the smallest file name?
Correct Answer
B. DOS
Explanation
DOS (Disk Operating System) allows for the smallest file name compared to the other options listed. DOS uses the 8.3 file naming convention, which means that file names can be up to 8 characters long, followed by a period, and then a 3-character file extension. This limitation in file naming allows for shorter and more concise file names compared to other operating systems.
12.
Which is the latest version of MS Word?
Correct Answer
D. Word 2010
Explanation
The latest version of MS Word is Word 2010.
13.
What is the function of Radio buttons?
Correct Answer
B. To select single option among available options
Explanation
Radio buttons are used to select a single option among the available options. Unlike checkboxes, where multiple options can be selected, radio buttons allow only one option to be chosen at a time. This makes them ideal for situations where only one choice is allowed, such as selecting a gender or choosing a preferred payment method.
14.
How do you connect the Internet to your system?
Correct Answer
A. My computer >> Dialup networking
Explanation
To connect the Internet to your system, you can use the "My computer >> Dialup networking" option. This involves setting up a dial-up connection on your computer, where you can enter the necessary information such as phone number, username, and password provided by your Internet Service Provider (ISP). This allows your computer to establish a connection with the ISP's server through a modem, enabling access to the Internet.
15.
What happens when selecting the record presses the delete key?
Correct Answer
B. Content will be deleted
Explanation
When selecting the record and pressing the delete key, the content of the record will be deleted. This means that any information or data associated with the record will be removed, leaving an empty or blank space where the record used to be. This action does not delete the entire row or move it up, it only removes the content of the selected record.
16.
Which device cannot be shared in the network?
Correct Answer
B. Keyword
Explanation
The keyword is the only option among the given devices that cannot be shared in a network. A floppy disk can be shared by physically transferring it between computers, a computer can be connected to a network and share its resources, and a printer can also be shared over a network to allow multiple users to print. However, a keyword is not a physical device and cannot be shared in a network.
17.
What is the purpose of the query?
Correct Answer
D. All of above
Explanation
The purpose of the query is to perform multiple tasks, including retrieving input data, generating output data, and sorting and filtering the data. It encompasses all of the mentioned options and serves a comprehensive purpose in handling and manipulating the data.
18.
Which port doesn't exist on the computer?
Correct Answer
D. None
Explanation
The question asks which port does not exist on the computer. The options given are USB, Parallel, Com1 / Com2, and None. USB and Parallel ports do exist on computers and are used for connecting devices. Com1 / Com2 are serial ports that also exist on computers. Therefore, the correct answer is None, indicating that all the ports mentioned in the options do exist on the computer.
19.
Database utility exists in ….. menu.
Correct Answer
B. Tools
Explanation
The correct answer is "Tools" because the question is asking where the "Database utility" exists in the menu. Among the given options, "Tools" is the only menu option listed. Therefore, the correct answer is "Tools."
20.
Which command does not exist in DOS?
Correct Answer
A. Sum
Explanation
The command "Sum" does not exist in DOS. DOS (Disk Operating System) is an operating system that does not have a built-in command called "Sum". The other three commands, Cls, Cd, and Dir, are commonly used in DOS for clearing the screen, changing the current directory, and displaying the contents of a directory, respectively.
21.
In which generation transistor was used?
Correct Answer
B. Second
Explanation
Transistors were used in the second generation of computers. The first generation of computers used vacuum tubes, while the second generation introduced transistors as a more efficient and reliable alternative. Transistors helped to make computers smaller, faster, and more affordable. They also consumed less power and generated less heat compared to vacuum tubes. This advancement in technology during the second generation of computers marked a significant milestone in the development of modern computing.
22.
Number increment is done in Access by:
Correct Answer
A. AutoNumber
Explanation
In Access, number increment is done using AutoNumber. AutoNumber is a data type that automatically generates a unique number for each record in a table. It ensures that each record has a unique identifier, which is useful for primary keys or any situation where a unique identifier is required. AutoNumber is commonly used to increment numbers in Access databases.
23.
After copying how many times you can paste the content?
Correct Answer
D. Many
Explanation
The question is asking about the number of times you can paste the content after copying it. The word "many" suggests that there is no specific limit to the number of times you can paste the content. Therefore, the correct answer is "Many."
24.
What is the function of the workspace?
Correct Answer
A. Contain multiple workbook
Explanation
The function of the workspace is to contain multiple workbooks. A workspace is a virtual area where you can organize and manage multiple workbooks in a single environment. It allows you to easily switch between different workbooks and perform tasks across them simultaneously. By having multiple workbooks in a workspace, you can efficiently work on different projects or tasks without the need to open and close individual workbooks separately.
25.
What is the name of excel files?
Correct Answer
A. Workbook
Explanation
A workbook is the correct term for an excel file as it refers to the entire file that contains multiple worksheets. Worksheets, on the other hand, are individual sheets within the workbook where data is entered and manipulated. The term spreadsheet is a more general term that can refer to any file or program used for organizing and analyzing data, while "Spread book" is not a recognized term in the context of excel files.
26.
Which is the function of a relationship?
Correct Answer
A. Relate multiple tables
Explanation
The function of a relationship is to relate multiple tables. This means that it establishes a connection between two or more tables in a database, allowing for the sharing of data and the ability to retrieve information from multiple tables simultaneously. By relating multiple tables, it becomes easier to organize and analyze data, as well as maintain data integrity and avoid data redundancy.
27.
One nibble contains…. Bits.
Correct Answer
D. 4 bit
Explanation
A nibble is a unit of digital information that consists of 4 bits. Therefore, the correct answer is 4 bit.
28.
OLE means
Correct Answer
B. Object linking and embedding
Explanation
OLE stands for Object Linking and Embedding. It is a technology developed by Microsoft that allows objects from one application to be embedded or linked to another application. This means that objects such as charts, tables, or even entire documents can be inserted into another document or application, while still maintaining a connection to the original source. This allows for dynamic updates and editing of the embedded or linked objects. OLE is commonly used in applications like Microsoft Office to enhance collaboration and integration between different programs.
29.
In which object sql is used?
Correct Answer
A. Query
Explanation
SQL (Structured Query Language) is primarily used in the context of querying databases. It is a language used to communicate with and manipulate relational databases. Therefore, the correct answer is "Query" as SQL is used to write and execute queries to retrieve data from a database.
30.
Workgroup means
Correct Answer
A. Computers in network
Explanation
Workgroup refers to a collection of computers that are connected within a network. These computers can communicate and share resources with each other. Therefore, the correct answer is "Computers in network" as it accurately defines the term workgroup.
31.
Outline view is used to
Correct Answer
D. All of the above
Explanation
The outline view is used to display chapter-wise headings, headings, and content. It provides a structured and organized overview of the document or content being viewed. By showing chapter-wise headings, it allows the user to easily navigate through different sections of the document. Additionally, it displays the headings, which helps in understanding the hierarchy and structure of the content. Lastly, it also shows the content itself, allowing the user to read and review the information. Therefore, the correct answer is "All of the above."
32.
What happens when you cut in excel?
Correct Answer
A. The content of cell will be removed after paste
Explanation
When you cut in Excel, the content of the cell is removed from its original location and stored in the clipboard. Therefore, when you paste the cut content elsewhere, it will no longer be present in the original cell.
33.
What should you use to create a newspaper style column?
Correct Answer
A. Columns from Format menu
Explanation
To create a newspaper-style column, you should use the "Columns" option from the Format menu. This feature allows you to divide your document into multiple columns, similar to how a newspaper is laid out. By selecting this option, you can specify the number of columns you want, adjust their width, and customize other formatting settings to achieve the desired newspaper-style layout. The other options mentioned, such as Bullet & Numbering and Tab, are not specifically designed for creating columns in a newspaper-style format.
34.
Which data type doesn't exist in access?
Correct Answer
B. Picture
Explanation
The correct answer is "Picture" because in Microsoft Access, there is no specific data type called "Picture". Access does not have a dedicated data type for storing images or pictures. However, images can be stored in Access by using the "Attachment" data type or by storing the file path of the image in a text field.
35.
Synonym can be reviewed with:
Correct Answer
B. Thesaurus
Explanation
A thesaurus is a tool that provides synonyms for words. It helps in reviewing and finding alternative words with similar meanings. By using a thesaurus, one can expand their vocabulary and enhance their writing or speaking skills. Therefore, a thesaurus is an appropriate tool to review and explore synonyms.
36.
Which device will process data?
Correct Answer
B. CPU
Explanation
The CPU, or Central Processing Unit, is responsible for processing data in a computer system. It performs calculations, executes instructions, and manages the flow of data between different components of the computer. RAM, or Random Access Memory, is a type of computer memory that temporarily stores data that the CPU needs to access quickly. While RAM plays a crucial role in the overall performance of a computer, it is the CPU that actually processes the data and performs the necessary operations. Therefore, the CPU is the correct answer to the question.
37.
In which data will be erased as the power supply is off?
Correct Answer
A. RAM
Explanation
RAM stands for Random Access Memory, which is a type of computer memory that is volatile, meaning it requires a constant power supply to retain data. When the power supply is turned off, the data stored in RAM is erased. Therefore, in this scenario, the data will be erased as the power supply is off.
38.
Data can be stored in:
Correct Answer
D. All
Explanation
Data can be stored in various forms such as floppy disks, hard disks, and tapes. Each of these storage mediums has its own advantages and disadvantages. Floppy disks were commonly used in the past but are now considered outdated due to their limited storage capacity. Hard disks are the most commonly used storage medium in modern computers, offering large storage capacities and fast access times. Tapes are often used for backup purposes due to their high storage capacity but slower access times. Therefore, the correct answer is "All" as data can indeed be stored in all of these options.
39.
Which files is (are) most essential in every computer?
Correct Answer
D. All
Explanation
All of the files mentioned (Io.sys, Msdos.sys, and Command.com) are essential in every computer. These files are part of the operating system and are necessary for the computer to boot up and function properly. Io.sys is responsible for managing input and output operations, Msdos.sys contains configuration information for the MS-DOS operating system, and Command.com is the command interpreter for MS-DOS. Therefore, all of these files are crucial for the computer's operation.
40.
Paper orientation can be changed from:
Correct Answer
A. Page Setup >> Paper Size
Explanation
The correct answer is "Page Setup >> Paper Size" because in the Page Setup menu, there is an option to change the paper size, which determines the orientation of the paper. By selecting this option, users can change the orientation of the paper to either portrait or landscape mode. The other options mentioned, such as "Property," "Print >> Layout," and "Print Preview," do not specifically allow for changing the paper orientation.
41.
The category is written in ……
Correct Answer
A. X-axis
Explanation
The correct answer is X-axis because the question is asking about the category that is written on the X-axis. The X-axis is the horizontal axis on a graph, and it is typically used to represent the independent variable or the category being measured or compared. Therefore, the correct answer is X-axis.
42.
What is there in the record?
Correct Answer
A. Collection of fields
Explanation
The correct answer is "Collection of fields" because a record is typically made up of multiple fields, each representing a specific piece of information. These fields are organized together to form a record, which can then be stored or retrieved from a database. Therefore, a record is a collection of fields that hold different types of data such as text, numbers, dates, or images.
43.
Which command is used to create a directory?
Correct Answer
C. Mkdir
Explanation
The correct answer is "Mkdir". Mkdir is the command used to create a directory in various operating systems, including Unix, Linux, and Windows. It is a short form of "make directory" and is commonly used in command line interfaces to create new directories or folders within a file system.
44.
What operation is not permitted by query?
Correct Answer
B. Entry
Explanation
The operation that is not permitted by the query is "Entry." This means that the query does not allow for the deletion, modification, or creation of an entry in a table. It is likely that the query only allows for the retrieval or viewing of data, but not any changes to the data itself.
45.
Which is not related to the database?
Correct Answer
D. Macro
Explanation
A macro is not directly related to a database. In the context of databases, a macro is a sequence of instructions that can be executed to automate repetitive tasks. It is a feature commonly found in spreadsheet programs like Microsoft Excel, but it is not a fundamental component of a database system. Tables, queries, and forms, on the other hand, are all essential elements of a database, used for organizing, retrieving, and presenting data.
46.
What is the full form of ISP?
Correct Answer
B. Internet service provider
Explanation
The correct answer is "Internet service provider." An ISP, or Internet service provider, is a company that provides individuals and organizations with access to the internet. They offer various services such as internet connectivity, email services, web hosting, and more. ISPs connect users to the internet through different technologies like dial-up, DSL, cable, or fiber-optic connections. They play a crucial role in enabling users to access and utilize the vast resources available on the World Wide Web.
47.
Which is the web browser?
Correct Answer
A. Netscape navigator
Explanation
The correct answer is Netscape Navigator because it is a web browser that was widely used during the early days of the internet. Windows Explorer is a file management program, Outlook Express is an email client, and Google.com is a search engine.
48.
Which of the following is a search engine?
Correct Answer
A. Google.com
Explanation
Google.com is a search engine because it is a website that allows users to search for information on the internet. It has a vast index of web pages and uses algorithms to provide relevant search results to users based on their queries. Users can enter keywords or phrases into the search bar on Google.com and it will return a list of web pages that match the search criteria. Google.com also offers various additional features such as image search, news search, and maps.
49.
What will do by filter?
Correct Answer
A. Display the records that meet the criteria
Explanation
Filtering is a process used to display only the records that meet specific criteria. By using a filter, you can narrow down a large dataset and display only the records that match certain conditions or criteria. This allows for easier analysis and manipulation of data as only the relevant records are displayed. Therefore, the correct answer is "Display the records that meet the criteria."
50.
Which command allows you to reduce fragments of files and optimize the performance of the disk?
Correct Answer
D. Defrag
Explanation
The command "Defrag" allows you to reduce fragments of files and optimize the performance of the disk. Fragmentation occurs when files are stored in non-contiguous locations on the disk, leading to slower access times. The "Defrag" command rearranges the fragmented files, placing them in contiguous blocks, which improves the overall performance of the disk by reducing the time it takes to read and write data.