1.
Filter is available on?
Correct Answer
B. Data menu
Explanation
The filter is available on the Data menu. This menu is typically found in software applications that deal with data manipulation and analysis. The filter function allows users to sort and organize data based on specific criteria, making it easier to find and analyze specific information within a dataset. By placing the filter option under the Data menu, it is easily accessible and intuitive for users who are working with data.
2.
When inserting a column in excel previous column moves on:
Correct Answer
D. Right most side
Explanation
When inserting a column in Excel, the previous column moves to the right side. This means that the column being inserted will be placed as the rightmost column, shifting all the other columns to the right. This is the default behavior in Excel when inserting columns.
3.
Function of filter is:
Correct Answer
D. All of above
Explanation
The function of a filter is to perform a selection of numbers, special characters, and characters. Therefore, the correct answer is "All of above" as it encompasses all the mentioned functions of a filter.
4.
We can run PowerPoint slide in another computer program.
Correct Answer
A. Pack and go
Explanation
"Pack and go" is the correct answer because it refers to the feature in PowerPoint that allows users to package a presentation along with any linked files and fonts, making it easy to transfer and run the presentation on another computer. This feature ensures that all the necessary files and resources are included, eliminating any compatibility issues that may arise when running the presentation on a different computer program.
5.
Font folder is located on:
Correct Answer
C. Control Panel folder
Explanation
The font folder is located in the Control Panel folder. This is where all the system fonts are stored and managed. Users can access this folder to install or uninstall fonts on their computer. The Control Panel folder is a central location for various system settings and configurations, and the font folder is one of the components found within it.
6.
Which short-cut key is used to column break?
Correct Answer
C. Ctrl+Shift+Enter
Explanation
Ctrl+Shift+Enter is the correct answer because it is the shortcut key used to insert a column break in Microsoft Word. A column break is used to end the text flow in one column and start a new column within the same page. This shortcut is useful when working with multiple columns in a document, allowing for better organization and formatting of content.
7.
What is the short-cut key in PowerPoint to start slide show?
Correct Answer
D. F5
Explanation
The correct answer is F5. In PowerPoint, pressing the F5 key is the shortcut to start the slide show. This key activates the slide show mode and allows the presenter to display the slides in full screen. By pressing F5, the presenter can begin the presentation without having to navigate through the menus or use the mouse.
8.
To insert a new slide in PowerPoint presentation, use short-cut key.
Correct Answer
C. Ctrl+M
Explanation
To insert a new slide in PowerPoint presentation, the shortcut key is Ctrl+M. This key combination allows the user to quickly add a new slide to their presentation without having to navigate through the menu options. This shortcut is commonly used by PowerPoint users to save time and increase efficiency when creating presentations.
9.
In Access which wildcard is not mostly used?
Correct Answer
A. !
Explanation
The wildcard character "!" is not commonly used in Access. The "!" character is typically used in SQL queries to represent the logical NOT operator, rather than as a wildcard character. The wildcard characters commonly used in Access are "#" to represent a single digit, "?" to represent a single character, and "*" to represent any number of characters.
10.
Which application program is called data base program?
Correct Answer
D. Access
Explanation
Access is the correct answer because it is an application program specifically designed for managing and manipulating databases. It allows users to create, edit, and organize data in a structured manner, making it an essential tool for data management and storage. Unlike Excel, Word, and PowerPoint, which are primarily used for other purposes such as spreadsheets, documents, and presentations respectively, Access focuses solely on database functionality.
11.
Which one is not relationship type?
Correct Answer
B. Many to one
Explanation
The relationship types mentioned in the options are Many to many, Many to one, One to many, and One to one. Among these options, Many to one is not a relationship type. Many to one refers to a relationship where multiple instances of one entity are associated with a single instance of another entity. This type of relationship is commonly found in database design, where multiple records in one table can be linked to a single record in another table.
12.
What is the function of form?
Correct Answer
D. All of above
Explanation
The function of a form is to perform various operations on records, including adding, deleting, and modifying them. Therefore, the correct answer is "All of above" as all the mentioned functions are performed by a form.
13.
Which one is not database object?
Correct Answer
D. Datasheet
Explanation
A datasheet is not considered a database object. In a database, a form is used to display and enter data, a table is used to store data, a report is used to present data in a formatted manner, but a datasheet is not a distinct object in a database. It is a view or display option within a table that allows users to view and manipulate data in a tabular format.
14.
Table is …
Correct Answer
A. Row & column
Explanation
The correct answer is "Row & column" because a table is typically organized into rows and columns. Rows represent individual records or data entries, while columns represent different attributes or fields. This structure allows for easy organization and comparison of data in a tabular format.
15.
In how many ways you can save a document?
Correct Answer
B. 3
Explanation
There are three possible ways to save a document: by clicking on the save icon, using the keyboard shortcut Ctrl+S, or going to the File menu and selecting the save option.
16.
To save a document in different location use.
Correct Answer
B. Save as
Explanation
Save as is the correct answer because it allows the user to save a document in a different location by giving them the option to choose a specific folder or directory to save the file in. The other options, Save and Save as web page, do not provide the ability to choose a different location and instead save the document in its current location or as a web page respectively. Therefore, Save as is the most appropriate option for saving a document in a different location.
17.
How many steps are there to create a form letter?
Correct Answer
A. 4
Explanation
To create a form letter, there are typically multiple steps involved. These steps may include designing the layout and format of the letter, writing the content, inserting placeholders for personalized information, and testing the letter before finalizing it. Therefore, the correct answer is 4, as there are four steps involved in creating a form letter.
18.
The arrangement of elements such as title and subtitle text, pictures, tables etc. is called?
Correct Answer
A. Layout
Explanation
The term "layout" refers to the organization and placement of various elements, such as text, images, tables, etc., within a document, webpage, or any other visual medium. It involves determining the structure and arrangement of these elements to create a visually appealing and easy-to-read composition. Therefore, "layout" is the correct answer as it accurately describes the arrangement of elements in a design.
19.
To move slide from one computer to another, the operation is
Correct Answer
A. Pack and go
Explanation
The correct answer is "Pack and go". This operation allows users to transfer a slide from one computer to another by packaging all the necessary files and resources into a single folder. This ensures that the slide can be easily moved and opened on another computer without any missing elements or formatting issues.
20.
What do you mean by dialog box?
Correct Answer
D. All of above
Explanation
A dialog box refers to an interactive message box that presents a group of options and a set of controls to the user. This means that all of the options mentioned in the question - interactive message box, group of options, and set of controls - are correct explanations for what a dialog box is.
21.
The information of cell gives on:
Correct Answer
A. Formula bar
Explanation
The formula bar is the correct answer because it is the location in a spreadsheet program where users can view and edit the contents of a selected cell. It displays the formula or text entered into the cell, allowing users to make changes or perform calculations. The other options listed (Name bar, Name box, and Formatting bar) do not provide this specific function of displaying and editing cell contents.
22.
Where is footnote placed?
Correct Answer
B. Bottom of the page
Explanation
Footnotes are typically placed at the bottom of the page. This allows for easy reference and provides additional information or citations without disrupting the flow of the main text. Placing footnotes at the bottom of the page also helps to maintain the overall visual organization and readability of the document.
23.
We create new document from:
Correct Answer
B. File/New
Explanation
To create a new document, we use the "File/New" option. This option allows us to start a new document from scratch. The other options mentioned, such as "File/New tab" and "Format/New option," do not specifically refer to creating a new document. Therefore, the correct answer is "File/New."
24.
The technology is used in CD-ROM
Correct Answer
A. Optical
Explanation
Optical technology is used in CD-ROMs because it uses laser beams to read and write data on the disc's surface. The laser beam reflects off the pits and lands on the disc, which represent the 0s and 1s of the digital data. This technology provides high data storage capacity, fast data access, and durability. Optical technology is also used in other devices like DVD players and Blu-ray drives.
25.
Which one is not the capacity of floppy?
Correct Answer
A. 1.24 MB
Explanation
The capacity of floppy disks is typically measured in kilobytes (KB) or megabytes (MB). The options given are 24 MB, 1.44 MB, 360 KB, and 720 KB. All of these capacities are commonly associated with floppy disks except for 1.24 MB, which is not a standard capacity for floppies.
26.
Which code is used in keystroke?
Correct Answer
A. ASCII
Explanation
ASCII is the correct answer because it is a widely used code that represents characters as numbers. It is commonly used in computer systems to encode keystrokes and other characters. ANSI is a character encoding standard that is compatible with ASCII, but it is not specifically used for keystrokes. Therefore, the correct answer is ASCII.
27.
Which of the following information a Chart holds?
Correct Answer
D. All of the above
Explanation
A chart holds all of the above information because it typically includes a legend, which explains the colors or symbols used in the chart, a data table that provides the numerical values associated with the chart, and axes that represent the variables being measured on the chart. Therefore, all of these elements are commonly found in a chart.
28.
SVGA is related with:
Correct Answer
B. Monitor
Explanation
SVGA stands for Super Video Graphics Array, which is a display standard used for computer monitors. It provides a resolution of 800x600 pixels or higher, allowing for high-quality graphics and images on the monitor screen. Therefore, SVGA is directly related to monitors and not printers or CPUs.
29.
Which is a popular secondary storage device?
Correct Answer
A. Disks
Explanation
Disks are a popular secondary storage device because they offer large storage capacity and are relatively inexpensive. They are commonly used in computers and other devices to store and retrieve data. Disks can be easily accessed and provide a reliable means of long-term data storage. CD and RAM are not secondary storage devices, as CD is a type of optical storage and RAM is a type of primary storage. Therefore, the correct answer is disks.
30.
Www stands for?
Correct Answer
A. World Wide Web
Explanation
The correct answer is "World Wide Web." This is a commonly used term that refers to the system of interconnected documents and other resources, linked by hyperlinks and URLs, that can be accessed via the internet. It was developed in the late 1980s and early 1990s and has since become an integral part of the internet, allowing users to navigate and access information from various websites.
31.
Which is database application?
Correct Answer
B. Access
Explanation
Access is a database application because it is a software program that allows users to create and manage databases. It provides tools and features for creating tables, queries, forms, and reports, which are essential components of a database system. Excel and Spreadsheet, on the other hand, are spreadsheet applications primarily used for data analysis and calculations, while "All" is not a specific database application. Therefore, Access is the correct answer as it is specifically designed for database management.
32.
Which one is used for database management system?
Correct Answer
A. Jet Engine
Explanation
The correct answer is "Jet Engine." A Jet Engine is a database management system used to manage and manipulate databases. It is a software component that provides the necessary tools and functionality to store, organize, retrieve, and manipulate data in a structured manner. Jet Engine is commonly used in Microsoft Access to handle the underlying database operations.
33.
Merge Cell option is placed on?
Correct Answer
A. Alignment
Explanation
The Merge Cell option is placed on the Alignment tab. This option allows users to combine multiple cells into one, creating a larger cell that spans across multiple columns or rows. By merging cells, users can create a more organized and visually appealing layout for their data or content.
34.
Command is associated with,
Correct Answer
B. Shortcut key
Explanation
The correct answer is "Shortcut key" because a command is typically associated with a specific key or combination of keys on a keyboard that can be used to quickly execute the command. This allows users to perform tasks more efficiently by bypassing menus or toolbars and directly accessing the desired functionality.
35.
The fastest printer is
Correct Answer
A. Laser printer
Explanation
A laser printer is the fastest printer compared to the other options mentioned. Laser printers use a laser beam to create an electrostatic image on a drum, which attracts toner and transfers it onto paper. This process is much faster than the mechanisms used in dot matrix and inkjet printers. Dot matrix printers use a matrix of pins to strike an inked ribbon and create characters, while inkjet printers spray tiny droplets of ink onto the paper. Both of these methods are slower than the laser printing process, making the laser printer the fastest option.
36.
Word
processing is
Correct Answer
A. 32 bit
Explanation
Word processing is typically done using 32-bit software. This means that the software is designed to work with computers that have a 32-bit processor. A 32-bit processor can handle larger amounts of data and perform more complex calculations compared to an 8-bit or 16-bit processor. This allows for more advanced features and functionality in word processing software, such as the ability to handle large documents, perform spell checking, and format text. Additionally, 32-bit software is compatible with both 32-bit and 64-bit operating systems, providing flexibility for users.
37.
What
is the function of info super highway?
Correct Answer
B. Link other part of the world through broadband information network
Explanation
The function of the info super highway is to link other parts of the world through a broadband information network. This means that it allows for the connection and communication between different locations and individuals worldwide, facilitating the exchange of information and data. The info super highway enables the rapid flow and gradual development of multimedia services by providing a platform for the transmission and sharing of various forms of media content. Therefore, the correct answer is "Link other part of the world through broadband information network."
38.
To
delete cell, press
Correct Answer
C. Delete
Explanation
To delete a cell in a document or spreadsheet, the correct key combination or action is to press the "Delete" key. This key is commonly used to remove selected content or cells from a document or spreadsheet. The other options listed, including Ctrl+d, Alt+d, and Esc, are not typically used for this purpose and may perform different functions depending on the software or context.
39.
To
view comment
Correct Answer
C. View menu
Explanation
The correct answer is "View menu" because the question is asking for the menu where the comment can be viewed. The other options are not relevant to viewing comments.
40.
Which
is ROM software?
Correct Answer
B. Firmware
Explanation
Firmware is the correct answer because it refers to a type of software that is permanently stored in a computer's ROM (Read-Only Memory). It provides essential instructions for the hardware components to function properly and allows the device to boot up and operate. Unlike regular software, firmware cannot be easily modified or deleted by the user.
41.
Which
is used in binary code?
Correct Answer
A. EBCDIC
Explanation
EBCDIC is used in binary code.
42.
To restrict access to database to other users, we use:
Correct Answer
A. Exclusive mode
Explanation
Exclusive mode is used to restrict access to the database to other users. In this mode, only one user at a time is allowed to access the database, ensuring that no concurrent access or modifications can occur. This helps maintain data integrity and prevents conflicts that may arise from multiple users accessing the database simultaneously.
43.
Which DOS command requires additional file to execute?
Correct Answer
B. External DOS command
Explanation
An external DOS command requires an additional file to execute. Internal DOS commands are built-in commands that do not require any additional files. Primary commands are not a recognized category of commands in DOS. Therefore, the correct answer is that an external DOS command requires an additional file to execute.
44.
The box which is by default appear at right side of chart is called
Correct Answer
A. Legend
Explanation
The box that appears by default at the right side of a chart is called the legend. It provides a key to understanding the different elements or series represented in the chart. The legend typically uses different colors or symbols to differentiate between the various data sets or categories in the chart. It helps the viewer easily identify and interpret the information presented in the chart.
45.
In Access to insert picture the data type is used:
Correct Answer
A. OLE
Explanation
In Access, the data type used to insert a picture is OLE (Object Linking and Embedding). OLE allows users to insert objects such as pictures, graphs, and documents into a database. By using the OLE data type, users can store and view images directly within the Access database. This provides a convenient way to include visual elements in the database, enhancing the overall user experience and making it easier to manage and organize image data.
46.
In Access table, which components exist?
Correct Answer
C. Column and row
Explanation
In an Access table, the components that exist are columns and rows. Columns represent the different fields or attributes of the data, while rows represent the individual records or instances of the data. Each cell in the table represents a specific intersection of a column and a row, containing the actual data values.
47.
Which is database program?
Correct Answer
A. Oracle
Explanation
Oracle is a database program. It is a widely used relational database management system that provides a secure and scalable platform for storing and managing large amounts of data. It offers various features such as data integrity, concurrency control, and data security. Oracle allows users to create, modify, and query databases using SQL (Structured Query Language). It is commonly used in enterprise-level applications for its robustness and reliability. Word and Excel, on the other hand, are not database programs but rather word processing and spreadsheet software respectively.
48.
Which device connects the CPU and users?
Correct Answer
A. PeripHeral devices
Explanation
Peripheral devices are the devices that connect the CPU (Central Processing Unit) and the users. These devices include input devices, such as keyboards and mice, as well as output devices, such as monitors and printers. They act as intermediaries between the CPU and the users, allowing users to interact with the computer system and providing input and output capabilities. Therefore, peripheral devices are the correct answer as they facilitate the connection between the CPU and users.
49.
Where does text box lies?
Correct Answer
A. Drawing toolbar
Explanation
The correct answer is Drawing toolbar because the text box is a feature that allows users to insert text into a document, and the Drawing toolbar is where users can find various drawing tools and features, including the text box option.
50.
In which menu we can add footnote?
Correct Answer
A. Insert menu
Explanation
The correct answer is Insert menu because footnotes are typically added to a document to provide additional information or references. The Insert menu in most word processing software usually contains options for adding elements such as tables, pictures, headers, and footers. Since footnotes are a type of footer, it makes sense that the option to add footnotes would be located in the Insert menu.