Explanation

In 2003 and earlier versions - From Format Cells dialog box click on Merge Cells check box

In 2007 and subsequent versions - Merge & Center icon on the Home ribbon.

Explanation

The Title Bar is a horizontal bar placed at the top of a window.

Explanation

Doctor’s symbol (Big Plus) indicates we that we can make selection to cell.

Explanation

Data form  effective ways to record time of data entry in Excel

****

ND20-1-2023

Explanation

• Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)
***

• The Average function calculates the average, or arithmetic mean, of its arguments.
• The Max function finds the maximum value.
• The Min function finds the minimum value.
• The Sum function calculates the sum of its arguments.
  
  

Explanation

To removes a sheet from workbook select the sheet, then choose Edit > Delete Sheet these options available in excel 2003 and earlier version.

Explanation

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.

Explanation

In Excel, to calculate the product of numbers, the function used is =PRODUCT().

This function multiplies all the numbers provided as arguments and returns the result.

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

***

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

ND11-3-2023

Explanation

There is no option to set page border in Excel.