TASK10

AIM: Demonstration and Practice of various features Microsoft Excel Assignment:

Software Requirement: MS-EXCEL

Hardware Requirement: Personal computer

THEORY:

Gridlines:

1.     Click the work sheet

2.     On the file menu, click page set up and the click the sheet tab.

3.     Click grid lines.

4.     Select the sheets on which you want to change the grid lines color.

5.     On the Tools menu click options click the color you want in the color box.

6.     To use the default grid lines color click automatic.

7.     Lines you can add to a chart that make it easier to view and evaluate data. Grid lines extend from the tick marks on an axis across a plot area.

        Format Cell:

1. Change the font and font size.

2. Change the text color.

3. Makes elected text or numbers bold, italic or underlined.

4. Create a new style.

        Auto fit:

1.  Combine cells horizontally or vertically to make one large cell.

2. Add borders to cells.

3. Shade cells with colors.

4. Change the column width and row height

5. Change the font, font size or colors of text.

6. Align text vertically at the top, center and bottom of cell.

 

 

Formatting the text:

1.               Select the text you want to format.

2.               On the format menu click cells and then click number tab.

3.               In the catalog box click text.

4.               Enter the numbers in the formatted cells.

5.               Click ok.

6.               Then press enter and reenter the data.

PROCEDURE:

First click start button of the screen on status bar. Click on programs and then Microsoft excel. To get a new blank work sheet go to programs and then click on excel sheet. On the file menu click page setup and then click sheet tab click gridlines. In this way do the required changes using format cell, make the required changes using formatting text also make the required changes. Enter the data in the data in the worksheet consisting of week name person name and timings 7 a.m.to3p.m.Make all the above changes to the text.

Formulae in Excel:

First click on start button at the bottom of the screen on status bar. Click on programs and the non Microsoft excel. Then open a new document. Give the main heading and subheading by changing the size so that they look in block letters. Enter the data. To calculate go to Insert menu in the menu bar and then click on function and then ok. Then select the data to which you want to calculate mean. Then you get the required answer. In same way, sample means standard deviation lower count limit and upper count limit. Go to insert menu and click on function and select the required operation to be done and select the data and calculate. Formulas for all the above are given below.

Mean = (s1 +s2+s3+ s4 +s5)/5;

Sample mean = avg (mean) Standard deviation=(mean, sample, mean)

Sample standard deviation=avg (Standard deviation)

Lower count limit = sample mean – sample standard deviation. Upper count limit=Sample mean + Sample Standard deviation

ASSIGNMENTS:

1.Creating a scheduler:

2)Calculating GPA

3.     3) Calculating Total, average of marks in various subjects and ranks of students based on marks: