Explanation

In MS Excel, the SQRT(number) function is used to calculate the square root of a given number.

Example: =SQRT(25) will return 5.

Explanation

In Microsoft Excel, the divide symbol is a forward slash (/).

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

****

SH31-07-23

ND30-4-2023

Explanation

A function inside a function is called a Nested function.

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

Goal Seek, Solver, and Scenario Manager are all tools in Excel used for What-If Analysis.

It helping to analyze different possible outcomes.

Goal Seek adjusts a single input to reach a desired result.

Solver handles complex optimizations.

Scenario Manager compares multiple data scenarios.