Understanding Microsoft Excel: A Spreadsheet Program, Assignments of Computer science

Download Understanding Microsoft Excel: A Spreadsheet Program and more Assignments Computer science in PDF only on Docsity!

Excel – 2003Excel – 2003

Spreadsheet Spreadsheet

SpreadsheetSpreadsheet

Is a program that manipulates numbers andIs a program that manipulates numbers and string data in rows and columns. string data in rows and columns.

Microsoft Excel is an example for aMicrosoft Excel is an example for a Spreadsheet program. Spreadsheet program.

Advantages of SpreadsheetAdvantages of Spreadsheet

Allows you to perform simple row and columnAllows you to perform simple row and column arithmetic. arithmetic.

Data is stored in an easy to use format.Data is stored in an easy to use format.

SHORT DETAILS OF MS-SHORT DETAILS OF MS- EXCEL EXCEL

A, B, C........IV - COLUMN headingsA, B, C........IV - COLUMN headings

1, 2, 3 ... 65536 - ROW headings 1, 2, 3 ... 65536 - ROW headings

1. 1. Maximum Zoom size – 40%Maximum Zoom size – 40%

2. 2. Minimum Zoom size - 10%Minimum Zoom size - 10% Normal – 100%Normal – 100%

3. 3. Maximum number of rows - 636Maximum number of rows - 636

4. 4. Maximum number of columns - 256 (A …….. to ……..Maximum number of columns - 256 (A …….. to ……..

IV) IV)

5. 5. Short cut to move the last row – alt=wn arrowShort cut to move the last row – alt=wn arrow

6. 6. Short cut to move the First row - ctrl+ up arrowShort cut to move the First row - ctrl+ up arrow

7. 7. Short cut to move the last column - ctrl+ rightShort cut to move the last column - ctrl+ right

arrow arrow

8. 8. Short cut to move the first column -left arrowShort cut to move the first column -left arrow

9. 9. Default sheets -Default sheets -

10.Maximum number of sheets available in work 10.Maximum number of sheets available in work

book is – 255(insert menu book is – 255(insert menu  work sheet)work sheet)

11. 11. Maximum number of characters in sheetMaximum number of characters in sheet

name is – 3 characters (Format – Sheet – Rename) name is – 3 characters (Format – Sheet – Rename)

12. 12. To move the next sheets – Ctrl + Page DownTo move the next sheets – Ctrl + Page Down

13. 13. To move the previous sheets – Ctrl + Page upTo move the previous sheets – Ctrl + Page up

Inserting a RowInserting a Row Place the cursor at the required position.Select Insert Place the cursor at the required position.Select Insert  RowRow Inserting a Column Inserting a Column Place the cursor at the required position.Select Insert Place the cursor at the required position.Select Insert  Column. Column. Inserting a Worksheet Inserting a Worksheet Select Insert Select InsertWorksheet.Worksheet.

Selecting CellsSelecting Cells Method 1 -- Use Shift + Arrow Keys ( Method 1 -- Use Shift + Arrow Keys (  ,,  )) Method 2 – Click and drag using the mouse Method 2 – Click and drag using the mouse Method 3 – to select entire row click on the row number Method 3 – to select entire row click on the row number Method 4 – to select entire column click on the column name Method 4 – to select entire column click on the column name Formatting Cells Formatting Cells Select the cells to be formatted Select the cells to be formatted Method 1 , Right Click and select Format Cells Method 1 , Right Click and select Format Cells Method 2 , Select Format Method 2 , Select Format  CellsCells Method 3.‘Format Cells’ dialog box appears. It contains 5 tabs Method 3.‘Format Cells’ dialog box appears. It contains 5 tabs Numeric,Alignment,Font,Border,Patterns Numeric,Alignment,Font,Border,Patterns

 Defining a FormulaDefining a Formula  To perform calculations, a formula can be used.To perform calculations, a formula can be used.  A formula is a sequence of values and operators.A formula is a sequence of values and operators.  Formula in Excel begin with an equal sign (=).Formula in Excel begin with an equal sign (=).  Ex: =A1+A2+A3 is a formula to add the contents of cellsEx: =A1+A2+A3 is a formula to add the contents of cells A1,A2 and A3. A1,A2 and A3.  Method – 1Method – 1  A formula can be typed in a cell to calculate and displayA formula can be typed in a cell to calculate and display the result of the formula in that cell. the result of the formula in that cell.  Enter the formula directly in the cell.Enter the formula directly in the cell.  Ex of formulaeEx of formulae  =3544=35  =23^2=23^  (^) =C5-C3=C5-C  =D1+D2+C2+C3=D1+D2+C2+C  =S3-D644/3=S3-D644/  (^) An important and useful feature in Excel is that itAn important and useful feature in Excel is that it automatically recalculates the formula if we change some automatically recalculates the formula if we change some value. value.

Column:–Column:–

Width - increase and decrease theWidth - increase and decrease the “column width” “column width”

Min and Max width – 0 to 2Min and Max width – 0 to 2

Normal widthNormal width - 8.43- 8.

Auto fit – to fit the column width forAuto fit – to fit the column width for the contents. the contents.

Hide – it is used to hide the columnHide – it is used to hide the column (ctrl+9) (ctrl+9)

Unhide – it is used to unhide theUnhide – it is used to unhide the column (shift+ctrl+9) column (shift+ctrl+9)

1. To prepare a new table1. To prepare a new table  Exam Result forExam Result for 2003Tamil88English90Maths78Scie 2003Tamil88English90Maths78Scie nce57Social50 nce57Social 
2. Select the marks, click tools2. Select the marks, click tools menu , click scenarios menu , click scenarios 
3. click add, give any one name in3. click add, give any one name in the place “scenario name” the place “scenario name” 
4. click OK4. click OK 
5. then the selected values will be5. then the selected values will be displayed. displayed. 
6. in this place you can change the6. in this place you can change the values. values. 
7. click “summery”7. click “summery”

Auto correct:Auto correct:

It is used to automaticallyIt is used to automatically correct to the particular words. correct to the particular words.

Ex:Ex:

You can type the wordYou can type the word “ABOUT” in “A B O T U” it is “ABOUT” in “A B O T U” it is automatically changed to automatically changed to ABOUT. ABOUT.

Table:Table:  It is used to preparing aIt is used to preparing a multiplication table. multiplication table.  =F1A6( Press Enter, then it is=F1A6( Press Enter, then it is automatically changed to automatically changed to 0)12341234 0)  Select the above area click dataSelect the above area click data menu, click table, the table need the menu, click table, the table need the  Row input cellRow input cell :: F1F  Column input cellColumn input cell :: A6A  Click Ok. Then the multiplicationClick Ok. Then the multiplication table will be display. table will be display.