Explanation

A trendline is added to a chart to show patterns or trends in the data.

It helps in analyzing data over time or predicting future values.

Explanation

From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

Explanation

Explanation

Explanation

The current active cell can be identified as being the one that has a darker black border around it.

Explanation

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Select View > Freeze Panes > Freeze Panes.

Explanation

 IN MS Excel, the "IF" function is used to check the particular condition.

It will return differently depending on whether the result of the condition was TRUE or FALSE.

***

ND18-1-2023 

The correct syntax for an IF statement in Excel is: A =IF(LogicalTest, TrueResult, FalseResult) This syntax states that if the logical test is true, the function will return the TrueResult, and if the logical test is false, the function will return the FalseResult. The other options are not correct.

Explanation

 press Ctrl ( Control key ) + A together if we want to select all the cells in the document .

This feature is different in MS Word where we need to press Ctrl + A in order to select the entire document .

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

To zoom an Excel worksheet, you can use:

• The mouse pointer in Print Preview: Click and drag the mouse pointer in the lower right corner of the Print Preview window to zoom in or out.
• The zoom button on the Print Preview toolbar: Click the zoom button (magnifying glass icon) to zoom in or out.
• The zoom command on the View menu: Select View > Zoom > Zoom In/Out or use the shortcuts Ctrl+Plus sign (+) to zoom in or Ctrl+Minus sign (-) to zoom out.