​*ABOUT MS EXCEL*

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS.

 

It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

 

The intersection of a row and column is called a Cell.

 

The cell in which we are currently working is known as Active Cell.

 

Microsoft Excel’s native file formats are denoted either by a .xls or .xlsx file extension.

A Worksheet is made of columns and rows, wherein columns run Vertically and rows run Horizontally.

 

Up to Excel 2003, the standard amount of columns has been 256 and 65,536 rows.

Excel 2007 onwards, the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384.

 

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations
 

The letter and number of the intersecting column and row is the Cell Address.

 

Short cut key to insert a new worksheet in MS-Excel is ALT + Shift + F1 + or F11.

 

Sheet tab is the tab at the bottom of the worksheet window that displays the name of the worksheet.

 

A Microsoft office document that contains one or more worksheets is known as aWorkbook.

 

Shortcut Keys of MS-Excel

Key

Description

F2

Edit the selected cell

F5

Go to a  specific cell

F7

Spell check selected text and/or document

F11

Create  chart

Ctrl + Shift + ;

Enter the current time

Ctrl + ;

Enter the current date

Shift + F3

Open the Excel insert function window

Shift + F5

Bring up Find and Replace box.

Ctrl + A

Select all contents of the worksheet

Ctrl + B

Bold highlighted selection

Ctrl + I

Italic highlighted selection

Ctrl + U

Underline highlighted selection

Ctrl + P

Bring up the print dialog box to begin printing

Ctrl + Z

Undo last action

Ctrl + F9

Minimise current workbook

Ctrl + F10

Maximise currently selected workbook

Ctrl + F6

Switch between open workbooks/window

Ctrl + page up

Move between Excel worksheet in the same Excel document.

Ctrl + Page Down

Move between Excel worksheets in the same Excel document

Ctrl + Tab

Move between two or more open Excel files

Alt + =

Create a formula to sum all of the above cells

Ctrl + ’

Insert the value of the above cell

into cell currently selected.

Ctrl + Arrow key

Move to next section to text

Ctrl + Space

Select entire column

Shift + Space

Select entire row