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

ROM stands for Read-Only Memory.

It is a type of non-volatile storage

Retains data even when power is turned off

Purpose: It holds data that is rarely changed, such as system firmware.

Function: It is crucial for starting up (booting) a computer.

..

RAM stands for random access memory

PROM stands for Programmable Read-Only Memory.

WINDOWS stands for Wide Interactive Network Development for Office work solutions

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

RAM is a volatile (or temporary) memory

That acts as a computer's primary storage for active data

RAM stands for Random Access Memory

ROM is non-volatile and permanent storage.

Explanation

To apply bold formatting to text in Microsoft Word, you can press Ctrl + B on your keyboard.

This shortcut makes the selected text bold.

• Ctrl + I is used to italicize text.
• Ctrl + U is used to underline text.
• Ctrl + S is used to save the document.

Explanation

1 byte equals 8 bits.

Additional Information

Explanation

• BIOS stands for Basic Input Output System.

Additional information:

• BIOS is a firmware stored on a computer’s motherboard.
• Initializes hardware during booting and provides runtime services.
• Acts as an interface between operating system and hardware.

Last verified on 04-02-2026

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

The shortcut key to check spelling and grammar in Microsoft Office applications (Word, Excel, PowerPoint) is F7

Additional informtion

F1

Opens the help menu when pressed with the Windows button. 

F2

Allows you to edit the selected folder or file name in Windows Explorer & Cell 

F3

Opens search feature in Windows Explorer 

F4

Alt + F4 closes window 

F5

Starts slideshow in PowerPoint

Refreshes Internet browser pages 

F6

Goes to the next page in a split screen in Microsoft Word

F8

In Excel, enables extend mode for arrow keys

F9

Refreshes document in Microsoft Word

F10

Opens menu bar

F11

Exits and enters full-screen mode in browsers

F12

Opens Save as in Word

Explanation

LAN stands for local area network

It is a collection of devices connected together in one physical location

For example"

• school
• laboratory
• university campus 
• office building.

LAN covers can be small or large from home network and enterprise network

Additional Information

WAN stands for wide area network.

MAN stands for Metropolitan Area 

WANs and MANs connect many LANs together

WANs and MANs cover a large geographical area