Explanation

• The main window in a computer spreadsheet is called a workbook
• while 
• The title bar in MS Excel displays the name of the  worksheet
• **
• In Excel, when we create a new document, we always select a blank workbook, as you already have done in the previous chapter.
• When this blank workbook opens up, an interface you see is called a workbook window.
  

Explanation

After = symbol you can enter either a calculation or functions

*****

*********

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

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

Ms. Excel is a Spreadsheet program

MS Excel is based on WINDOWS

shortcut key in  MS Excell:

which key is used for help in MS excel?

 F1

The Right answer is Ctrl + ;

***

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

Which key is used for the GO TO tab in Ms. Excel?

 F5 

Which key is used for excel column highlight?

CTRL + space

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M