Ronald ross p. G. College (mba) koheda road, mangalpally (V) ibrahimpatnam (M), R. R. (Dist) 505510

RONALD ROSS P.G. COLLEGE (MBA)

KOHEDA ROAD, MANGALPALLY (V)

IBRAHIMPATNAM (M), R.R. (Dist) - 505510

This is to certify that Mr./Ms. ____________________of MBA I Year I Semester, bearing Hall Ticket Number ____________ has successfully completed his/her practical record work on Information Technology Lab(IT Lab) in the academic year 2008-09.

Internal External Head of the

Examiner Examiner Department

INDEX

1. 
   Ms Excel
   

• 
  Introduction to Ms Excel
  
• 
  Functions
  
• 
  Charts
  
• 
  Data Filter
  
• 
  Macros
  

2. 
   Ms Access
   

• 
  Introduction to Ms Access
  
• 
  Tables
  
• 
  Queries
  
• 
  Forms
  
• 
  Reports
  

MS Excel

The Excel Screen

Objective To identify the parts of the Excel screen, and know how to use them effectively.

Instructions You will learn the parts of the Excel screen by observation and try out some common Excel tasks.



Activity 2.1 Familiarise yourself with the Excel worksheet window. If the worksheet is displayed on part of the screen, you can enlarge the worksheet window by clicking on the Maximise box to the right of the Title Bar.



Activity 2.2 The columns are labelled by letters and the rows by numbers. At the intersection of a row with a column is a box called a cell. Cells are referenced by both their column label and their row number.

Click on the cell D7 using the mouse. A black box appears around the cell. This is called the cell highlight and it's presence denotes a selected range. Move the mouse slowly over the black border. Notice that the cursor changes from a thick white crosshair when over the main part of the cell to a white arrow when it is over the black border, and a black crosshair when it is over the little black box in the bottom right hand corner of the cell highlight.

Activity 2.3 Now look at the formula bar. This has three areas. The lefthand area will have the text D7 in it. Excel can only edit the contents of one cell at a time, even when a range is selected. The editable cell is called the active cell. It is always highlighted and it's reference will be displayed in the left-hand area of the formula bar.

The right-hand area of the formula bar will display the contents of the active cell, and in here the contents can be changed. The middle area of the formula bar is used when the cell is being edited to confirm or cancel the changes.

Microsoft Excel is an electronic spreadsheet program.

The Workbook

Most of the Excel screen is devoted to the display of the workbook. The workbook consists of grids and columns. The intersection of a row and column is a rectangular area called a cell.

Cells

The workbook is made up of cells. There is a cell at the intersection of each row and column. A cell can contain a value, a formula, or a text entry.

Rows, Columns, and Sheets

The Excel worksheet contains 16,384 rows that extend down the worksheet, numbered 1 through 16384.

The Excel worksheet contains 256 columns that extend across the worksheet, lettered A through Z, AA through AZ, BA through BZ, and continuing to IA through IZ.

The Excel worksheet can contain as many as 256 sheets, labeled Sheet1 through Sheet256. The initial number of sheets in a workbook, which can be changed by the user is 16.

Cell References

Cell references are the combination of column letter and row number. For example, the upper-left cell of a worksheet is A1.

Formulas

Formulas are entered in the worksheet cell and must begin with an equal sign "=". The formula then includes the addresses of the cells whose values will be manipulated with appropriate operands placed in between.

Basic Functions

Functions can be a more efficient way of performing mathematical operations than formulas. For example, if you wanted to add the values of cells D1 through D10, you would type the formula "=D1+D2+D3+D4+D5+D6+D7+D8+D9+D10". A shorter way would be to use the SUM function and simply type "=SUM(D1:D10)". Several other functions and examples are given in the table below:

Function	Example	Description
SUM	=SUM(A1:100)	finds the sum of cells A1 through A100
AVERAGE	=AVERAGE(B1:B10)	finds the average of cells B1 through B10
MAX	=MAX(C1:C100)	returns the highest number from cells C1 through C100
MIN	=MIN(D1:D100)	returns the lowest number from cells D1 through D100
SQRT	=SQRT(D10)	finds the square root of the value in cell D10
TODAY	=TODAY()	returns the current date (leave the parentheses empty)

Function Wizard

View all functions available in Excel by using the Function Wizard.

• 
  Activate the cell where the function will be placed and click the Function Wizard button on the standard toolbar.
  
• 
  From the Paste Function dialog box, browse through the functions by clicking in the Function category menu on the left and select the function from the Function name choices on the right. As each function name is highlighted a description and example of use is provided below the two boxes.
  

• 
  Click OK to select a function.
  
• 
  The next window allows you to choose the cells that will be included in the function. In the example below, cells B4 and C4 were automatically selected for the sum function by Excel. The cell values {2, 3} are located to the right of the Number 1 field where the cell addresses are listed. If another set of cells, such as B5 and C5, needed to be added to the function, those cells would be added in the format "B5:C5" to the Number 2 field.
  

• 
  Click OK when all the cells for the function have been selected.