Explanation

ASCII stand for American Standard Code for Information Interchange.

It is a character encoding standard that assigns numerical values (0-127) to English letters, numbers, punctuation marks

Work on the ASCII standard began in May 1961

Definitive version published in 1968

Last updated 15-feb-2026

Explanation

Linux is the most prominent example of an open-source operating system. 

Linux: Created by Linus Torvalds in 1991,

It is a Unix-like operating system that relies on a community-driven development model.

Last updated 15-feb-2026

Explanation

An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both.

A dollar symbol ($) is used before the coordinates to correct them.

For instance, $D$2 is an absolute reference to cell D2

Last updated 15-feb-2026

Explanation

• Cache memory acts as a buffer between the CPU (Central Processing Unit) and the main memory (RAM).
• It is a small, high-speed memory that stores frequently used data and instructions that the CPU is likely to need next.
• This allows the CPU to access the data and instructions it needs quickly, without having to wait for the slower main memory to respond.

Last verified on 10-02-2026

Explanation

• Microsoft Excel is Microsoft's spreadsheet program that can be used to organize, format, and calculate data.
• Microsoft Excel is a spreadsheet application used for calculations, charts, and data analysis

Last verified on 10-02-2026

Explanation

1 Kilobyte (KB) = 1024 bytes

One Megabyte (MB) = 1024 Kilobytes (KB

One Gigabyte (GB) =  1024 Megabytes MB

One Terabyte (TB)= 1024 gigabytes (GB).

The size of information in the computer is measured in:

Kilobytes (KB)

Megabytes (MB)

Gigabytes (GB)

Terabytes (TB)

Last verified on 08-02-2026

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

WWW stands for World Wide Web

Additional information related to WWW

• It is an information system.
• Creator: Conceived by Tim Berners-Lee in 1989.
• Year started: 1989
• First published: 6 August 1991
• Founder: Tim Berners-Lee in 1989.
• Birthplace: CERN near Geneva, Switzerland.

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