TASK 5

TASK 5:

Creating a Scheduler:-Features to be covered: - Gridlines, Format Cells, Summation, auto fill, Formatting Text

AIM: To maintain a shift schedule with specifications

Hardware Requirements: Personal Computer

Software Requirements: Operating System, MS Office Package (MS- Excel Application)

 Theory:

Microsoft Excel is a proprietary commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

           

Tool Bars

         

      

 

 Grid lines:

1. Click the worksheet.
2. On the file menu, click page Layout and the go to sheet options.
3. Click gridlines.

 Format Cell:

1. Change the font and font size.
2. Change the text color.
3. Make selected 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. to 3 p.m. Make all the above changes to the text.

Result: Creating a MS- Excel sheet is completed by inserting grid lines, formatting text options.

Viva Questions:

1) What do you mean by a spread sheet?

Ans: It allows organizing information in rows and columns.

2) What is the Auto Fill?

Ans: It allows to quickly filling cells with repetitive or sequential data such as date or numbers or text.

3) What is a grid line?

Ans: Grid lines are the border lines of the cells within a spread sheet.