Explanation

• SDLC stands for Software Development Life Cycle.
• SDLC is a structured process for developing software efficiently.
• It defines stages from planning to maintenance.
• Ensures software is high-quality, cost-effective, and meets requirements.
• Common phases: Requirement Analysis → Design → Implementation → Testing → Deployment → Maintenance.

Last verified on 07-02-2026

Explanation

• NIC stands for Network Interface Card.
  • It connects a computer to a network or internet.
  • It can be wired (Ethernet) or wireless (Wi-Fi).
  • Every NIC has a unique MAC address.
  • It enables data communication between devices.

Last verified on 07-02-2026

Explanation

The AutoSum feature, activated by clicking the Sigma AutoSum button on the Home/Formulas tab or pressing Alt + =,

It is the fastest way to automatically total a column or row in Excel.

It uses the SUM function to intelligently select and sum adjacent numerical data. 

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

The ALU (Arithmetic and Logic Unit) performs the computer's data processing functions.

As a primary component of the CPU, the ALU handles all arithmetic, logic, and shifting operations on data. 

Explanation

1 byte equals 8 bits.

Additional Information

Explanation

The primary key to take a screenshot on Windows is PrtScn (Print Screen)

PrtScn: Captures the full screen to the clipboard.

Windows Key + PrtScn: Saves the full screen automatically to Pictures > Screenshots.

Explanation

• In Microsoft Word, hyperlinks are shown as blue underlined text by default.
• The blue color helps users easily identify clickable links.
• After clicking, the link color may change, but the default is blue.

Explanation

• Bps (Bits per second) measures the rate at which data is transferred from one device to another.
• It is commonly used for network speed, internet speed, and bus transfer rates.

Additional information:

• Modern systems often use Mbps (Million bps) or Gbps (Billion bps) for high-speed data networks.

Last verified on 28-01-2026

Explanation

 The BIOS (Basic Input/Output System) is firmware that contains a computer's startup instructions.

It resides on a motherboard chip, initializes hardware, and performs a power-on self-test (POST) to ensure components function properly before loading the operating system.

Explanation

• Short key use for Date and Time 
• Date: Ctrl+;
• Time: Ctrl+ Shift+ ;

Additional information

shortcut key in  MS Excell:

Which key is used to help in MS Excel?

F1

***

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;