1 / 21

Lesson No:10 Intro. to Excel 2000, Managing & Formatting Worksheet

CHBT-01 Basic Micro process & Computer Operation. Lesson No:10 Intro. to Excel 2000, Managing & Formatting Worksheet. Intro. Excel 2000, Managing & formatting worksheet. Excel Screen:. Name Box / Address Box. Column D. Cell B5. Row #13.

Download Presentation

Lesson No:10 Intro. to Excel 2000, Managing & Formatting Worksheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CHBT-01 Basic Micro process & Computer Operation Lesson No:10 Intro. to Excel 2000, Managing & Formatting Worksheet

  2. Intro. Excel 2000, Managing & formatting worksheet Excel Screen: Name Box / Address Box Column D Cell B5 Row #13

  3. Intro. Excel 2000, Managing & formatting worksheet Spreadsheet – An Introduction Numbers are an important part of out\r day-to-day life. Almost everything that we do is in some way associated with numbers. Starting with our age, the marks we et in school, the money we earn, how much we spend, what is the area of this house The list can be endless. To get more out of these nos. one often needs to arrange them in a manner that is most convenient to read and understand. The best way of doing this is to arrange them in the form of a table made up of row and columns i.e. tabular form In MS-Excel a spreadsheet is provided with rows and columns. Any grid or array of numbers and/or text in rows and columns to write down numbers and calculate them easily is called Spreadsheet

  4. Intro. Excel 2000, Managing & formatting worksheet • Advantages of an Electronic Spreadsheet • Entering data is very faster and easier • Making changes is simpler • Extracting meaningful information is easy • Large spreadsheet can be stored effortlessly on the computer • Calculation is very fast and errorless • Automatic recalculation • Graphics facility for data • Terms • Rows : Rows are Horizontal. Row numbers identify rows • Columns :Columns are Vertical. They are named from A to Z,AA,AB,…AZ,….IA,…,IV. • Cell: An intersection of row and columns each & every cell has unique cell address. Like F7

  5. Intro. Excel 2000, Managing & formatting worksheet • Excel file is known as Work book or Spreadsheet • The Extension name of workbook is .XLS or .XLW • Workbook contains max. 255 sheets • Each sheet contains 256 Columns ( A to IV ) and 65536 Rows • Intersection area of Row and Column is known as a Cell • Main parts of Excel 2000 • 1. Spreadsheet • 2. Database Excel • 3. Graphics

  6. Intro. Excel 2000, Managing & formatting worksheet Inserting Row, Column, worksheet Insert Row Column Worksheet

  7. Intro. Excel 2000, Managing & formatting worksheet Formatting worksheet Data Select data .Then click on Format Cell Option It will display the following dialog box. Choose appropriate option.

  8. Intro. Excel 2000, Managing & formatting worksheet Conditional Formatting Click on Format Conditional Formatting Type proper condition and apply formatting option

  9. Column Heading Cell Row Heading • Cell:- It is the intersection of row and column used to enter data in it. • Row:- It is the horizontal block formed by group of cells. 65536 rows present in a worksheet. • Column:- It is the vertical block formed by group of cells. 256 columns are present in a worksheet. TERMINOLOGY

  10. Formula Bar Cell Address Worksheet • Worksheet:- It is the main working area consists of rows and columns. By default, three worksheets are opened. • Formula Bar:- This bar is provided to alter the cell ingredients and to enter formula in a cell. • Cell address:- It is formed by the combination of column and row number. • Workbook:- It is the Excel file opened when application is started by name book1, book2…..

  11. Text data Numeric data Date type data • Entering text:- It can be seen in the figure that text type data is aligned by Excel automatically to left side. • Entering numbers:- It can be seen in the figure that numeric data is aligned by Excel automatically to right side. • Entering date:- It can be seen in the figure that date type data is organized by Excel automatically in date format. ENTERING DATA IN A CELL • Deleting data:- Data can be easily deleted by selecting cell or cell range and just pressing Delete key.

  12. Drag:- Any cell can be selected by mouse and dragged to anywhere. • Drop:- Any cell can be dragged and drop anywhere in worksheet. Click & Drag Drag & Drop • Auto fill:- Auto fill is very powerful facility of Excel. You can see the fill handle provided when combination of cell selected. This handle is dragged to destination and data will be filled automatically in subsequent cells. Date, numbers, weekdays can be filled automatically. Fill handle Drag, Drop and Auto fill

  13. FORMATTING • Cell:- Cell formatting can be done by cell option of Format menu. Cell format can be any type like general, number, currency, date, text….etc. • Alignment:- Texts can be aligned horizontally and vertically by this option. Text can also be controlled by wrapping, shrinking and by merging cells. Text direction can be controlled to any direction.

  14. Font:- Fonts can be formatted by this option. Font style, size, underline style, colors and effects can be applied by this option. • Borders:- Borders of different styles can be applied to a cell or to group of a cell. Colors can be changed from normal black to any other. • Patterns:- Pattern or colors can be applied to background of cell or group of cells. Different pattern stock can be accessed by pattern option.

  15. Inserting/Deleting Row,Column,Worksheet or Cell0 • Insert Row or Column:- Rows or columns can be inserted any where in worksheet by Row/Column option of insert menu. • Insert Worksheet:- Worksheets can be added in current workbook by this option. • Insert Cell:- Cell can be inserted to any where in worksheet. The data entered in that cell can be shifted to left/right/down/ up from originally located. • Delete:- Complete row/column is selected by their heading and then delete key is used to delete.

  16. Working with Worksheet • Insert:- Worksheet can also be inserted by right clicking on sheet tab. • Delete:- Worksheets can be deleted by clicking on delete option. • Rename:- Name of sheet can be changed by this option. • Move or Copy:- Sheet can be moved physically to any where or copy of sheet can be moved to any where. • Select all:- All sheets can be selected at once by this option.

  17. General Functions • Auto sum:- This tool is used for summation of selected cell range. Tool shown in figure. • & text operator:- This operator is used to join two strings differently entered in two cells. e.g. =A1&B1 • Sum:- This function is used to sum any selected range or cell address separated by commas. e.g. =SUM(A1:E1) or =SUM(A1,C1,E1) • Average:- This function is used to find an average of selected cell range or cells separated by commas. e.g. = AVERAGE(A1:E1) or =AVERAGE(A1,C1,D1)

  18. General Functions • Auto sum:- This tool is used for summation of selected cell range. Tool shown in figure. • & text operator:- This operator is used to join two strings differently entered in two cells. e.g. =A1&B1 • Sum:- This function is used to sum any selected range or cell address separated by commas. e.g. =SUM(A1:E1) or =SUM(A1,C1,E1) • Average:- This function is used to find an average of selected cell range or cells separated by commas. e.g. = AVERAGE(A1:E1) or =AVERAGE(A1,C1,D1)

  19. General Functions • Max:- This function is used to find maximum value among the selected range. e.g. =MAX(A1:E1) or =MAX(A1,C1,E1) • Min:- This function is used to find minimum value among the selected range or . e.g. =MAX(A1:E1) or =MAX(A1,C1,E1) • Len:- This function is used to find the length of text string. It will return the number of character in string. e.g. =LEN(A1) • SQRT:- This function is used to find square root. e.g. =SQRT(A1) or =SQRT(49)

  20. Page Setup • Page:- Page orientation, scaling, paper size and print quality can be set by this option. Print setup, print preview and print option can also be set by this option. • Margins:- Page margin and header footer margin can be set by this option. Horizontal and vertical center can be adjusted by this option too.

  21. Header/Footer:- Page header and footer can be set by this option. Standard header/footer and custom header/footer can be inserted. • Sheet:- This tab is used to set print area, print titles, page order etc. Print options are also provided in this tab. Row or Column repeat option can be set by this option.

More Related