MS EXCEL 2007
Spreadsheet Package:- This is a general purpose application software. Spreadsheet is a made up Rows and columns. You can use Spreadsheet for mathematical calculation, creating chart, accounts etc.
EXCEL:- Microsoft Excel is an electronic spreadsheet. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly. Spreadsheets are made up of
columns
rows
and their intersections are called cells
In each cell there may be the following types of data
text
number data
formulas (mathematical equations that do all the work)
Note:- In 2003 Excel there are 256 columns (A to IV) and 65,536 rows (1 to 65,536). In 2007 excel, there are 16384 columns (A to XFD) i.e 64 times of 2003 excel columns and 10,48,576 rows ( 1 to 10,48,576) i.e 16 times of 2003 excel rows.
STARTING EXCEL
You can start excel by:- Double clicking on Microsoft Excel application icon. This application is usually in a fold called Excel. An icon appears on the desktop of the computer.
Double clicking on the icon of any Excel document. When you double click an Excel document, Excel open with the document already loaded.
In Excel 2007, how a window displays depends on the size of your window, the size of your monitor, and the resolution to which your monitor is set. Resolution determines how much information your computer monitor can display
THE MICROSOFT OFFICE BUTTON
The Microsoft Office Button:-You can find button in the left corner of the Excel 2007. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks.
The Quick Access Toolbar:- Quick access toolbar is next to the Microsoft button of the excel. The Quick Access toolbar provides save, undo, redo button and edit shape. You can use Save to save your file, Undo to rollback an action you have taken, and Redo to reapply an action you have rolled back.
The Title Bar:- You can find the title bar next to the Quick Access toolbar. The Title bar displays the title of the document on which you are currently working.
Worksheet of EXCEL:- Workbook of Excel is made up of Worksheet. Each worksheet contains columns and rows. The columns are named as A to Z then continuing with AA, AB, AC and so on: the rows are numbered 1 to 1,048,576.
The combination of a column and a row make a cell address. For example, the address of cell is like A1 means A is a column and 1 is the row, and you can see the address of the cell in the name box just above the A column headings.
Standard Toolbar of Excel 2003:-
The Standard toolbar, located below the menu bar, has buttons for user to perform tasks like adding a column of numbers, printing, sorting, and other operations. The Standard Excel XP toolbar given in the figure below.
Formatting Toolbar Excel 2003:-
The formatting toolbar, located below the Standard toolbar bar, has buttons for various formatting operations like changing text size or style, formatting numbers and placing borders around cells.
Formula Bar Excel 2003:-
the formula bar is located below the toolbar at the top of the Excel worksheet. Use the formula bar to enter and edit worksheet data. The contents of the active cell always appear in the formula bar. When you click the mouse in the formula bar, an X and a check mark appear. You can click the check icon to confirm and completes editing, or the X to abandon editing.
Formula Bar Excel 2007
If the Formula bar is turned on, the cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar.
Cell entries display on the right side of the Formula bar. If you do not see the Formula bar in your window, perform the following steps:
Choose the View tab
Click Formula Bar in the Show / Hide group. The Formula bar appears.
Note: The current cell address displays on the left side of the Formula bar.
The Status Bar
The Status bar appears at the very bottom of the Excel window and provides such information as the sum, averge, minimum, and maximum value of selected numbers.
You can change what displays on the Status bar by right-clicking on the Status bar and delecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected. A figure is given below:-
Menu of the Ribbon:- There are so many menu available on the ribbon same as Word 2007. these are:-
Home:- This is the first menu available on the Ribbon. With the help of Home menu you can create, format and edit the spreadsheet.
Insert:- This is the second menu of the on the ribbon. With the help of this menu you can insert tables, pictures, shapes link, charts, heder and footer.
Page Layout:- This is the third menu on the ribbon. With the help oif this menu you can set the layout of the spreadsheet, apply a theme to set the overall look, set the margins, orientations, size and backgrounds.
formulas:- This is the fourth menu of the ribbon. With the help of this menu you can use different formulas and functions.
Data:- This is the fifth menu of the ribbon. With the help of this menu you can import, query, view data from external sources, sort, filter or mange data.
Review:- This is the sixth menu available on the ribbon. With the help of this menu you can add comments, protect sheet, protect worksheet, share workbook etc.
View:- This is the last menu of the ribbon. With the help of this menu you can change the display the worksheet area.
Move Around the Worksheet
The Down Arrow Key:- Press the down arrow key several times. Note that the cursor moves downward one cell at a time. If you will press shift +down arrow key then you can move to last row of the worksheet.
The Up Arrow Key:- Press the up arrow key several times. Note that the cursor moves upward one cell at a time. If you will press shift +up arrow key then you can move to first row of the worksheet.
The Right Arrow Key:- Press the right arrow to move left right side of the cell. Note that the cursor moves right one cell at a time. If you will press shift +right arrow key then you can move to first row of the worksheet.
The left Arrow Key:- Press the left arrow key to move to the left side of the cell. Note that the cursor moves left one cell at a time. If you will press shift +left arrow key then you can move to first column of the worksheet.
The Tab Key:-
Move to cell A1.
press the Tab key several times. Note that the cursor moves to the right one cell at a time.
The Ctrl-Home key
Move the cursor to column J.
Stay in column J and move the cursor to row 20.
Hold down the Ctrl key while you press the Home key. Excel moves to cell A1.
Go To Cells Quickly
The following are shortcuts for moving quickly from one cell in worksheet to a cell in a different part of the worksheet.
Press F5 :- The F5 function key is the "Go to" key. Steps are given below to move on to desired cell
Press F5. The Go To dialog box opens.
Type J3 in the Reference field.
Press Enter. Excel move to cell J3.
Press Ctrl+G:- There is a another way to go to a specific cell.
Hold down the Ctrl key while you press "g" (Ctrl+g). The Go To dialog box opens.
Type C4 in the Reference field.
Press Enter. Excel moves to cell C4.
The Name Box:- This is the third way to go to the specific cell. Just type the cell you want to go to in the Name box and then press Enter.
Minimize and Maximize The Ribbon:- Follow the step to maximize and minimize the ribbon which is given below:-
Right click anywhere in the main menu.
Select the Minimize the Ribbon in the menu that appears. This will toggle the Ribbon ON and OFF.
In the available option you can choose the option as per your choice.
Add Command to Quick Access ToolBar: To add command with the help of Quick access ToolBar follow the following steps:-
Click the arrow to the right of the Quick Access ToolBar
Select the command which you want to add from the available menu. Then command will appear in the toolbar.
Change Page View:- There are so many view available on EXCEL.You can change view from the Page View option available in the bottom of the worksheet. These view options are:-
Normal:- This is the default view
Page Layout:- This is very helpful from printing point of view, When you select this view, then you can be able to see the margin, vertical and horizontal rulers and column and row headings.
Page Break:- This is very important view. This view can determine where the page will break when you are trying to print an excel sheet that spanjs multiple pages.
Select Cells
If you wish to perform a function on a group of cells, you have to first select those cells by highlighting them.
Follow the step to select the cell to select cells A1 to E1:
Go to cell A1.
Press the F8 key. after pressing f8 then you will be in "Extend Selection" appears on the Status bar.
Click in cell E10 to select A1 to E10.
Press Esc and click anywhere on the worksheet to clear the highlighting.
Another method: Select Cells by Dragging:- You can also select an area by holding down the left mouse button and dragging the mouse over the area. In addition, you can select noncontiguous areas of the worksheet by doing the following:
Goto cell A1
Hold down the Ctrl key.
Press the left mouse button.
While holding down the left mouse button, use the mouse to move from cell A1 to C5.
Continue to hold down the Ctrl key, but release the left mouse button.
Using the mouse, place the cursor in cell D7.
Press the left mouse button.
While holding down the left mouse button, move to cell FI0. Release the left mouse button.
Release the Ctrl key. Cells A1 to C5 and cells D7 to F10 are selected.
Press Esc and click anywhere on the worksheet to remove the highlighting.
Enter Data: To enter data into your worksheet. First, place the cursor in the cell in which you want to start entering data. Type some data, and then press Enter. Ifyou need to delete, press the Backspace key to delete one character at a time.
Edit a Cell:- After you enter data into a cell, you can edit the data by pressing F2 while you are in the cell you wish to edit.
Move to cell A1.
Press F2.
Use the Backspace key to delete the character
Press Enter
Wrap Text:- When you type text that is too long to fit in the cell, the text overlaps the next cell. If you do not want it to overlap the next cell, you can wrap the text.
Delete a Cell Entry:- To delete an entry in a cell or a group of cells, you place the cursor in the cell or select the group of cells and press Delete.
Save a File:- To save your file:
Click the Officebutton. Amenu appears.
Click Save. The Save As dialog box appears.
Goto the directory in which you want to save your file.
Type Lessonl in the File Name field.
Click Save. Excel saves your file.
Close Excel:- Close Microsoft Excel.
Click the Office button. A menu appears.
Click Close. Excel closes.
Shortcut key:- Microsoft Excel shortcut keys
F2
Edit the selected cell.
F5
Go to a specific cell. For example, C6
F7
Spell check selected text and / or document.
F11
Create chart.
Ctrl + Shift + ;
Enter the current time.
Ctrl + ;
Enter the current date.
Alt + Shift + F1
Insert New Worksheet
Shift + F3
Open the Excel formula window.
Shift + F5
Bring up search box.
Ctrl + A
Select all contents of the worksheet.
Ctrl + B
Bold highlighted selection.
Ctrl + I
Italic highlighted selection.
Ctrl + K
Insert link.
Ctrl + U
Underline highlighted selection.
Ctrl + 5
Strikethrough highlighted selection.
Ctrl + P
Bring up the print dialog box to begin printing.
Ctrl + Z
Undo last action.
Ctrl + F9
Minimize current window.
Ctrl + F10
Maximize currently selected window.
Ctrl + F6
Switch between open workbooks / windows
Ctrl + Page up
Move between Excel work sheets in the same Excel document.
Ctrl + Page down
Move between Excelwork sheets 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 + Shift + !
Format number in comma format
Ctrl + Shift + $
Format number in currency format.
Ctrl + Shift + #
Format number in date format.
Ctrl + Shift + %
Format number in percentage format.
Ctrl + Shift + ^
Format number in scientific format.
Ctrl + Shift + @
Format number in time format.
Ctrl + Arrow key
Move to next section of text.
Ctrl + Space
Select entire column.
Shift + Space
Select entire row.