Explanation

 To insert the current date into an Excel cell, use the TODAY() function.

Simply type =TODAY() in the cell and press Enter. 

Explanation

Delete a record

• Open the table in Datasheet View or form in Form View.
• Select the record or records that you want to delete. To select a record, click the record selector next to the record, if the record selector is available. 
• Press DELETE, select Home > Records > Delete, or press Ctrl+Minus Sign (-).

Explanation

The "Edit, Clear" command in spreadsheet software (like Microsoft Excel) allows you to remove different elements from selected cells, such as:

• Contents (values/data)

• Formats (cell formatting)

• Comments/Notes

However, it does not delete the cells themselves—it only clears their contents or attributes.

Explanation

The function key to quickly navigate to a specific cell in MS Excel is F5 or Ctrl+G.

These keys open the "Go To" dialog box, where you can enter the cell reference (e.g., B3) and press Enter to jump to that cell

Explanation

Filtering in Excel enables you to display rows that meet certain criteria, hiding the others.

This Excel feature allows you to display only the rows that meet specific conditions while hiding the others.

Explanation

COUNT function counts only numerical values in a selected range.

It ignores text, blank cells, and logical values (TRUE/FALSE).

Explanation

• A worksheet is an electronic spreadsheet that lets users to Calculate, Enter & Analyze data.
  

  A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form.

  
  

Explanation

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

***

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

SUM

***

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

Explanation