Explanation

• The value '01-01-2020 11:30' includes both date and time.
• The Date & Time datatype is best suited to store and manipulate such information in databases or spreadsheets.

Last verified on 10-02-2026

Explanation

• In MS Excel, all formulas and functions start with the equal sign (=).
• This tells Excel to perform a calculation instead of treating the input as plain text.

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

• In MS Excel, a single page where data is entered is called a worksheet.
• Multiple worksheets make up an Excel workbook.
• Worksheets contain cells arranged in rows and columns for data entry and calculations.

Last verified on 09-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