Search Previous Year Questions

The correct option is (3)

In banded rows/columns, even and odd rows/columns are displayed with another color.

Key Points

• Banded rows signify that after one row, another row will be in a different color, and so on.
• In MS Word, the banded column feature is used to differentiate the formatting of even columns from topic columns.
• Your worksheet's data may be easier to scan if you use color banding, which is the practice of adding a different color to alternate rows or columns.
• You can quickly apply a pre-made table format to format different rows or columns. When rows and columns are added using this technique, alternative row or column shading is automatically applied.
• When an Excel sheet contains a lot of data, color banding makes it simpler for the human eye to distinguish between rows and columns.
• Rows and columns can be banded together to create alternating bands of colored or textured rows and columns.
• To select something, tap anywhere on the table. To choose a whole row or column, drag the selection handle after tapping once more to select the first cell in the row or column.

The correct option is (4)

Digital subscriber line

Key Points

• A communication method known as Digital Subscriber Line (DSL) is used to transmit internet traffic via copper-wired telecommunications lines and telephone networks.
• DSL (Digital Subscriber Line) is a technology that uses standard copper telephone lines to deliver high-bandwidth information to homes and small businesses.
• The Digital Subscriber Line (DSL) internet service is only available in some locations and has a restricted operating range due to the limitations of the telephone network.

Additional Information Leased line:- A leased line is a two-way phone line that has been rented for exclusive usage in communications, data exchange, or voice.

Ethernet:- Ethernet is still a widely used type of network connection and is used to connect devices in a network. Ethernet is utilized for local networks because of its high speed, security, and dependability in places where it is specifically needed, including company offices, campuses of educational institutions, and hospitals.

Digital signal line:- A digital signal is one that can only take on one of a limited number of discrete values at any given time, representing data as a sequence of discrete values.

The correct option is (1)

Drop cap

Concept:-

Drop cap expands the first letter of a paragraph to multiple lines.

Key Points

• The first letter of a paragraph is called a drop cap, and it is significantly larger than the remaining conventional text.
• A huge capital letter known as a drop cap (sometimes known as a dropped capital) is used as a decorative element at the start of a paragraph or section. A drop cap is often two or more lines in length.

Additional Information Autocorrect:- A sort of software program known as auto-correct recognizes misspelled words, applies algorithms to determine the words that were most likely intended, and then fixes the text as necessary. 

Subscript and Superscript:- A character (such as a number or letter) that is slightly below or above the typical line of type is referred to as a subscript and superscript, respectively. Usually, it is less substantial than the rest of the text. Superscripts are above the baseline, while subscripts are at or below it.

The correct option is (3)

Static

Concept:-

SRAM stands for static random access memory.

Key Points

• As long as power is being provided, SRAM (static RAM), a form of random access memory (RAM), keeps data bits in its memory.
• A particular kind of memory found in semiconductors is known as static random-access memory. SRAM is immobile. It can function without a human periodically refreshing it.
• N registers are contained in a static random access memory (SRAM), and each is addressed by log N address bits A. Due to the fact that the underlying flip-flops are "static," they are what gives SRAM its moniker.
• Flip-flops, a bistable circuit made up of four to six transistors, make up static RAM (SRAM). Until the opposite value is put in a flip-flop, the bit it previously stored is retained.

Additional Information Symmetric:- A balanced and proportionate likeness between two halves of an object is referred to as symmetry. It implies that one half is the other's mirror image.

Synchronous:- Synchronous learning entails virtually attending a weekly class meeting at the same time as your instructor and classmates, even though you will be learning from a distance.

The correct option is (4)

ARPANET

Concept:-

The first network created by the internet was the ARPANET.

Key Points

• The first wide-area packet-switched network with distributed controversy was the Advanced Research Projects Agency Network (ARPANET).
• The first open packet-switched computer network was the U.S. Advanced Research Projects Agency Network (ARPANET).
• In 1989, it was ultimately deactivated after being put into use in 1969. The primary applications of ARPANET were in academia and research.
• The TCP/IP protocol suite was first used in early packet-switching networks like ARPANET.

Additional Information

• Option 1 – NSFNET: ❌ Developed later in the 1980s as a successor to ARPANET for academic and research purposes.
• Option 2 – ASAPNET: ❌ Not a recognized early computer network.
• Option 3 – CNNET: ❌ Refers to China's early networking efforts, much later than ARPANET.
• Option 4 – ARPANET: ✅ Correct. It is the earliest and foundational network that led to the development of the Internet.

The correct option is (1)

TCP

Concept:-

Several protocols are included at the application layer, including Telnet, FTP, TFTP, SMTP, SNMP, DNS, and DHCP.

Key Points

• An application protocol for distributed, collaborative, and hypermedia information systems is the Hypertext Transfer Protocol (HTTP).
• Transmission Control Protocol/Internet Protocol (TCP/IP) connections can be used to send files between computers using the FTP (File Transfer Protocol) network protocol.
• FTP is regarded as an application layer protocol within the TCP/IP family of protocols.
• Programs that emulate terminals and let you connect to distant hosts frequently use TELNET.
• TELNET, however, can also be utilized for interprocess communication and terminal-to-terminal communication.
• Other protocols (like FTP) can also establish a protocol control channel using TELNET.

Additional Information

• A trustworthy, full-duplex, connection-oriented data transmission service is offered by the transport-layer protocol TCP. TCP is used by most Internet applications.
• The top layer of the Open Systems Interconnection (OSI) communications paradigm, Layer 7, is where the application layer is located.

The correct option is (3)

#N/A

Concept:-

#N/A:- "No value available" or "not available" are the meanings of this error. It means that the formula is unable to locate the value that we had assumed it would. Consider using Excel's VLOOKUP, HLOOKUP, and MATCH functions.

 Key Points

• The formula or the cells that it references have a problem. Microsoft acknowledges that this error value is ambiguous and that determining its cause can be challenging.
• formula-filled cells that produce errors: The anticipated syntax, parameters, or data types are not used in a formula. #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE! are examples of error values.
• Each of these erroneous values has a unique cause and a unique method of correction.

Additional Information #NULL!:- #NULL! Error-values happen when there is an accidental or improper space used in a formula to separate two or more cell references.

#NUM!:- When an Excel calculation can't be done, the #NUM! error appears.

#NAME?:- When you encounter the #NAME? mistake in your calculation, fix it since it indicates that the syntax has to be fixed.

The correct option is (2)

I-Node

Concept:-

Each file or directory has a unique identifier that is typically referred to as an I-Node, as well as its name and the directory in which it is located.

Key Points

• An I-Node is a type of data structure used by UNIX operating systems to store crucial data about files in a file system.
• Because they contain information that is always required, such as ownership and protection, I-Nodes are found on discs and are always valid.
• A predetermined number of I-Nodes are also created when a file system is formed in UNIX. The I-Node table typically receives 1% of the entire file system's disc capacity.

Additional Information

• A kernel memory object called Vnode operates similarly to the UNIX file interface, opening, reading, writing, and closing files.
• On an operating system that is similar to Linux or Unix, a PID is an acronym for a process identification number.
• Every newly formed process is given a PID by default.
• On a system similar to Unix, a process is nothing more than a running instance of a program, and each process has a distinct PID.

The correct option is (1)

Computer-Aided Design

Key Points

• Computer-aided design, or CAD, is the process of using computer-based software to help with design processes. Engineers and designers of all stripes regularly utilize CAD software.
• Architects, construction managers, and engineers now use CAD design in favor of manual drafting.
• In addition to assisting users in visualizing buildings in either 2D or 3D, it also enables the development, modification, and optimization of the design process.
• Using specialized software, computer-aided design (CAD) produces two- and three-dimensional representations and animations of projects for use in manufacturing, advertising, and technical manuals.
• Using computers (or workstations) to help with the creation, revision, analysis, or optimization of a design is known as computer-aided design (CAD).

The correct option is (1)

26

Explanation:-

Here given excel formula

=2+16/2^1*3

The value of 2^1 stands for 2¹ which results in a value of 2.

The 16 is divided by 2 the result is 8 and 8*3 = 24 then 2+24=26

∴ the value of =2+16/2^1*3 = 26

Key Points

• Initialize the formula in an excel cell using the =(equal to )sign.
• MS Excel formula is an expression that operates on value in a range of cell addresses and operators.
• The operator " ^ (caret)" raises a number to a power.