1. Which generation of programming languages make use of compilers and interpreters ?
Explanation: Third generation programming languages (3GLs) use compilers and interpreters to translate instructions into machine language. 3GLs are high-level languages that can be platform independent. Examples of 3GLs include: BASIC, COBOL, Pascal, Fortran, C, C++, Perl, Ada.
2. What is the full form of DHCP with respect to computer networking ?
Explanation: Dynamic Host Configuration Protocol (DHCP) is a network protocol that configures devices to communicate on an IP network. DHCP uses client-server architecture to automatically assign IP addresses and other attributes to an IP host.
3. What is the full form of WiFi with respect to computer networks ?
Explanation: Wi-Fi is a wireless networking technology that uses radio waves to provide high-speed internet access. It's a trademarked phrase that refers to IEEE 802.11x standards.
4. A ___ is a part of Operating System that handles the core functions like CPU sechudling and memory management etc. of the OS.
Explanation: A kernel is a computer program that is the core of a computer's operating system. It acts as a bridge between the hardware and software, managing system resources such as memory, CPU, and input/output devices. The kernel also provides a layer of abstraction between the hardware and higher-level software components.
5. A scanner may have an ADF to feed pages for scanning. What is the full form of ADF in this statement ?
Explanation: ADF stands for Automatic Document Feeder. It is a feature found on devices like printers, fax machines, scanners and photocopiers. ADFs are handy when you have multiple sheets of paper to deal with and can be a crucial element of document management.
6. How many bytes are there in 1 MiB ?
Explanation: 1 KiB = 210, 1MiB = 220, 1GiB = 230.
7. Which of the following is the correct order of the memory capcity units in increasing order ?
Explanation: Computer memory units, from smallest to largest, is: Bit, Byte, Kilobyte (KB), Megabyte (MB), Gigabyte (GB), Terabyte (TB), Petabyte (PB), Hexabyte(HB), Zettabyte (ZB).
8. The term 'hit' and 'miss' are associated with which memory ?
Explanation: The terms "hit" and "miss" are associated with cache memory. When a processor needs data, it first checks the cache. If the data is found, a cache hit occurs, and the data can be accessed quickly. However, if the data is not found, a cache miss occurs, and the data must be fetched from the main memory, which is slower.
9. Which type of printer contains a fuser assembly ?
Explanation: The fuser assembly is a critical part of laser printers, copiers, and laser fax machines. It uses heat and pressure to fuse toner powder onto the page to create a print.
10. By using _____ option while printing multiple copies of a multi page document, the printer will print all papes of each copy before printing the next copy.
Explanation: Collate is a printing feature that arranges multiple sets of printed documents in a specific order. When collate is enabled, the printer organizes pages so that they appear in their correct, readable order as part of a set.
11. The _____ provides mobile users with positioning., navigatiom and timing serviceCs.
Explanation : GPS stands for Global Positioning System. It's a satellite navigation system that provides distance, time, and position measurements. GPS helps people and vehicles navigate different terrain.
12. Image _____ is the process of reoving the unwanted outer areas from the image.
Explanation: Cropping is one of the most basic photo manipulation processes, and it is carried out to remove an unwanted object or irrelevant noise from the periphery of a photograph, change its aspect ratio, or improve the overall composition.
13. Amazon Web Services (AWS) is a/an ______ Service platform offering various laaS and PaaS solutions.
Explanation: AWS stands for Amazon Web Services. It is a cloud computing platform that offers over 200 services from data centers around the world. AWS provides servers, storage, networking, remote computing, email, mobile development, and security.
14. Which of the following is not a product of Adobe Inç. ?
Explanation: Adobe Inc. is a software company that develops multimedia and creativity software products. Some of their products include: Creative Cloud, Document Cloud, Acrobat Pro, Photoshop, Illustrator, Acrobat, Lightroom, XD, Premiere Pro, After Effects, InDesign.
15. Who among the following is the developer of 'C' language ?
Explanation: The C programming language was created by Dennis Ritchie at Bell Laboratories in 1972.
16. Which of the following is the correct pairing of networking terms and their inventors ?
Explanation:
17. Which of the following generations of computers used integrated circuits ?
Explanation: The third generation of computers, from 1964-1977, used integrated circuits (ICs). ICs are tiny electronic components made of silicon chips that contain multiple transistors, resistors, and capacitors.
18. Who among the following invented the CD-ROM ?
Explanation: CD-ROM was invented by James Russell . A CD-ROM (Compact Disc Read-Only Memory) is a compact disc that can only be read, not written to. It's a digital storage medium that can hold large amounts of data, including text, images, and audio.
19. Who among the following is the inventér of USB ?
Explanation: Ajay Bhatt, an Indian-born American computer architect, invented the Universal Serial Bus (USB) in 1995.
20. What is the shortcut key to open the Font dialog box in Microsft Word ?
Explanation: To open the Font dialog box in Microsoft Word, you can use the keyboard shortcut Ctrl+D. This shortcut focuses on the Font combo box.
21. Font sizes are generally measured in points which is equal to ____ of an inch.
Explanation: A font's size is usually measured in points (pt). One point is equal to 1/72 of an inch. The point size determines how large or small the text appears on a page or screen.
22. MS-Word has tab stops set at every ____ inch by default.
Explanation: Microsoft Word's default tab stops are set at every half-inch. However, you can create your own tab stops or change the location of existing tab stops.
23. Which of the following is not a type of section breaks in MS-Word?
Explanation: The different kinds of section breaks include next page, continuous, even page, and odd page breaks.
24. Which of the following tabs in MS-Word contains the option to insert footnotes ?
Explanation: The References tab in Microsoft Word contains the option to insert footnotes.
25. How can you use different page orientations in the same word document ?
Explanation: To use different page orientations in the same Microsoft Word document, you can insert a section break.
26. What is the shortcut key to set the paragraph line spacing to 1.5 in MS-Word
Explanation: In Microsoft Word, pressing Ctrl + 5 changes a line, paragraph, or all highlighted text to have 1.5 spaces per line.
27. Which of the following features of MS-Word lets you create personalized letters to a number of recipients with different names and addresses ?
Explanation: Mail merge is a feature in most data processing applications that allows users to send a similar letter or document to multiple recipients. It combines mail and letters and pre-addressed envelopes or mailing labels for mass mailings from a form letter.
28. What is the key combination used to insert a new line character in the text of a cell in MS-Excel worksheet ?
Explanation: To insert a new line in an Excel cell, you can use the keyboard shortcut Alt + Enter.
29. An array formula can be entered in a cell in MS-Excel by entering formula and pressing ___
Explanation: To enter an array formula in a cell in MS-Excel, you need to press Ctrl+Shift+Enter after entering the formula. This will automatically enclose the formula between curly braces.
30. Consider the following data in MS-Exeel worksheet
What will be the value of the array formula {=SUM(A1:DI*A2:D2)} ?
Explanation: The Excel formula =SUM(A1:DI*A2:D2) multiplies the values in cells A1 through DI by the values in cells A2 through D2, and then adds all of the products together. For example, if cell A1 contains the value 2 and cell A2 contains the value 3, then the product of these two cells would be 6. The formula would then add 6 to the product of the values in cells B1 and B2, and so on. The final result would be the sum of all of the products.
31. Consider the following data in MS-Excel worksheet
What will be the value of the formula = LARGE(A1:E2,1)+LARGE(A1:E2,2) ?
Explanation : The formula =LARGE(A1:E2,1)+LARGE(A1:E2,2) returns the sum of the first and second largest values in the range A1:E2. The LARGE function returns the nth largest value in a range of data. The syntax for the LARGE function is =LARGE(array,k), where array is the range of data and k is the position of the largest value to return.
32. Which of the following features is not found in MS-Excel ?
Explanation:
33. Assume that you have full names of the employees in one column of MS-Excel sheet. The option _____ let you spilt the full names into columns first names and last nanmes.
Explanation: The Text to Columns tool in Excel can split the contents of a cell into adjacent columns. To access the Text to Columns tool, you can:
Select the cell, range, or column that contains the text values you want to split
Go to the Data tab
In the Data Tools group, click Text to Columns
Follow the instructions in the Convert Text to Columns Wizard
34. Which of the following options in MS-Excel lets you restrict the value of a cell from a list of values ?
Explanation: The Data Validation feature in Excel allows you to restrict the value of a cell from a list of values. Here are the steps to restrict the value of a cell from a list of values:
Select the cell you want to restrict
Go to Data > Validation
In the Allow dropdown, select List
In the Source text box, enter the values you want to restrict
Separate additional options with a comma
35. Assume that in an MS-Excel sheet, cell Al contains the value 10% and the cell A2 contains the value 5%, then what will be the value of formula =A1*A2?
Explanation: Cell A1 contains "10%", which is equivalent to the decimal value 0.10.
Cell A2 contains "5%", which is equivalent to the decimal value 0.05.
So, the formula =A1*A2 will be calculated as 0.10 * 0.05, resulting in 0.005.
36. Which of the following is correct formula in MS-Excel to round a number in the cell Al to the nearest multiple of 10 ?
Explanation: The syntax for Excel's ROUND function is ROUND(number; num_digits). This function has two required parameters: the number to round and the number of decimals to which to round it. For example, to round 1.932 to two decimals, you can use the formula ROUND(1.932; 2) = 1.93.
37. Which of the following features of MS-Excel can be used to highlight the marks obtained by the students if the marks are below 10 ?
Explanation: Conditional formatting in Excel applies formatting to data that meets one or more conditions. It can highlight and differentiate data by changing cells' fill color, font color, and border styles.
38. Which of the following is not a valid cell address in MS-Excel ?
Explanation: Excel has three types of cell references: relative, absolute, and mixed. Each type has a specific purpose.
Relative A relative reference is one without a dollar sign in the row and column coordinates.
Absolute An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.
Mixed A mixed reference has dollar signs attached to either the letter or the number in a reference but not both
39. Which of the following functions in MS-Excel is used to search a value in the leftmost column of a table and returns the corresponding value fronm another column in the same row ?
Explanation: VLOOKUP is a built-in Excel function that searches for a value in the first column of a table range and returns a corresponding value from another column in the same row. It stands for "Vertical Lookup" and is commonly used for data retrieval and analysis tasks.
40. Which of the following is the correct cell format to display only the month name of the date entered in a cell ?
Explanation: In the "Type" box, type "MMMM" or "MMM."
"MMMM" will display the full month name, such as "January" or "December."
"MMM" will display the abbreviated month name, such as "Jan" or "Dec."
41. A ____ is a tool in MS-Excel to calculate, summarize and analyze data to study patterns and trends in the data.
Explanation: Pivot tables in Excel are a powerful tool for summarizing, sorting, reorganizing, grouping, counting, totaling, and averaging data. They can also be used to analyze numerical data and identify trends and patterns.
42. Which feature in MS-Excel lets you quickly insert consecutive odd numbers in a column of the sheet ?
Explanation: To insert consecutive odd numbers in a column in Microsoft Excel, you can use the Fill Handle or the Fill Series feature:
Enter the number 1 in cell A1 and 3 in cell A2.
Select both cells.
Drag the fill handle down to Row 10.
AutoFill will recognize the pattern and populate the cells with odd numbers.
43. Assume that in an MS-Excel sheet, cell Al and A2 contain values 5 and 5% respectively, then what will be the value of the formula =Al+A2 entered in cell A3 of that sheet?
Explanation: Cell A1 contains the value "5".
Cell A2 contains "5%", which is equivalent to the decimal value 0.05 (5% is 5/100).
The formula =A1+A2 will be calculated as 5 + 0.05, resulting in 5.05.
Therefore, the value of the formula =A1+A2 entered in cell A3 will be 5.05.
Now convert it into percetage which is 505%.
44. Which of the following charts in MS-Excel shows numerical data as slices of a single circle ?
Explanation: A pie chart, also known as a circle chart, is a circular chart that displays numerical data as slices of a single circle. The slices represent different percentages of the entire.
45. Which of the following features in MS-Excel lets you record a sequence of keystrokes and play them again when required ?
Explanation: A macro in Excel is a series of instructions that automates manual tasks. For example, you can use a macro to automate repetitive tasks like cell formatting, summation, and information copying.
46. What is the full form of UDP with reference to TCP/IP ?
Explanation: UDP stands for User Datagram Protocol. It's a communication protocol that makes it easy for different computing devices on a network to exchange messages.
47. In which of the following network topologies, all the nodes are connected to a central connection point (like a hub or a switch) ?
Explanation: Star topology is a network topology where all nodes are connected to a central connection point, like a hub or switch. In a star topology, each device only needs one link and one I/O port to connect to any other devices.
48. Which of the following transmission media make use of four pairs of insulated copper wires ?
Explanation: Unshielded twisted pair (UTP) cables are transmission media that use four pairs of insulated copper wires. UTP cables are used in ethernet cables, telephone wires, and LANs.
49. Which of the following Internet services is responsible for transiation of domain names into corresponding IP addresses ?
Explanation: The Domain Name System (DNS) is responsible for translating domain names into IP addresses. DNS is a network protocol that allows the internet to function smoothly.
50. Which of the following networks, the problem of hidden terminal arises ?
Explanation: The hidden terminal problem occurs in wireless local area networks (WLANs). It's a transmission problem that happens when two or more stations that are out of range of each other transmit simultaneously to a common recipient.