WHAT IS EXCEL l Excel is a tool

WHAT IS EXCEL? l Excel is a tool to organize, calculate, and display numerical data. l Excel is kind of like a combination of WORD and a high-tech calculator (that produces graphs and charts for you).

WHY USE EXCEL? l Excel lets us enter information into the worksheet and then it can do calculations for us. This can be especially useful for budgeting or calculating grades, for example. l Excel can also translate the data into all sorts of graphs and charts. These can be great visual aids to any information you want to display to students or share with colleagues

ROWS & COLUMNS The number of rows and columns is a by-product of the binary number system. l 256 is 2, raised to the eight power (2^8), which is the maximum value that can be stored using eight bits. l The number of rows in a worksheet is 65, 536, which is 2^16. Older versions of excel contained only 16, 384 rows, which is 2^14 power. l

HOW MUCH DATA? l If you multiply the rows by the columns (256 columns X 65, 536 rows), you get 16, 777, 216 cells in each worksheet! l And remember, there are 3 worksheets in every “workbook”. That is a lot of cells to enter data in!

Microsoft Excel 7. 0 (95) l · Maximum Sheet Size: 16, 384 rows by 256 columns · Column Width: 0 to 255 characters · Maximum length of cell contents (text): 255 characters

Microsoft Excel 8. 0 (97) l· Maximum Sheet Size: 65, 536 rows by 256 columns · Column Width: 0 to 255 characters · Maximum length of cell contents (text): 32, 000 characters

Microsoft Excel 2000 l · Worksheet size: 65, 536 rows by 256 columns · Column Width: 255 characters · Length of cell contents (text): 32, 767 characters. Only 1, 024 display in a cell; all 32, 767 display in the formula bar.

EXCEL-WORD FEATURES

EXCEL-NEW FEATURES

EXCEL-WHAT’S NEW l Menu: new item Data. l Standard toolbar: New buttons l Formatting bar: New buttons

EXCEL-WHAT’S NEW l Formula bar l Document body: all numbered rows and lettered columns. l Document window: tabs at the bottom and a new set of arrows beside them.

EXCEL-MISSING l Missing: The Styles box other Word buttons the rulers

The Excel Window

EXCEL-SPREADSHEET l spreadsheet Document that is entirely made up of rows and columns. Used to list and analyze data. To add to the confusion in the world, people tend to use the word spreadsheet in two ways: – the entire Excel workbook file – an individual worksheet

EXCEL-WORKBOOK l Workbook The basic document for Excel. Its filename uses the extension xls, from Excel spreadsheet. A workbook usually contains several worksheets.

EXCEL-WORKBOOK WINDOW l workbook window The document window in an Excel window.

EXCEL-CELL l Cell Intersection of a row and a column on a worksheet

EXCEL-SHEET TAB l sheet tab Each worksheet has a tab at the bottom of the workbook window with the name of the worksheet on it.

EXCEL-ACTIVE WORKSHEET l active worksheet The worksheet that receives your keystrokes and commands. It has a white tab and its name is bold.

EXCEL-WORKSPACE l Workspace The area below the toolbars that holds your documents

EXCEL-WORKBOOK l The default workbook is named Book 1. l It contains three worksheets, named Sheet 1, Sheet 2, Sheet 3.

The Worksheet & Formula Bar

EXCEL-COLUMNS & ROWS l Columns Named with letters in the following pattern: A, B, C, …Z, AA, AB, AC, …AZ, BA, BB, BC, …BZ, CA, …IA, IB, …IV, which is the last possible column. l Rows Named with numbers from 1 to 65, 536.

EXCEL-HEADINGS l headings The gray buttons at the top of columns and at the left end of rows l cell reference or relative reference The usual way we refer to a cell, using the letter of the cell’s column followed by the number of the cell’s row, like B 3 or AD 345.

EXCEL-NAME BOX l Name Box At the top left above the sheet. Used to display cell references and to give and display cell names.

EXCEL-FORMULA BAR l Formula bar Shows the contents of a selected cell, whether it is plain text, numbers, or a calculation formula. Sometimes the whole bar that contains the Name Box and the formula text box is called the Formula bar. Sometimes just the formula text box is meant.

EXCEL-ABSOLUTE REFERENCE l absolute reference When you don’t want the cell reference to change as things are moved around, you must use an absolute reference, by putting a $ in front of both the column letter and the row number, like $B$3 or $AD$345.

EXCEL-ACTIVE CELL l active cell Has a dark border around it and the row and column headers are raised, like buttons. This is the cell that receives your keystrokes and commands. You make a cell the active cell when you select it, by clicking it or by moving into it with keys. The TAB or the arrow keys are handy for moving from cell to cell.

EXCEL-RANGE l range A rectangular set of cells, referred to by using the upper left and lower right cell references with a colon between them, Eg. like A 1: B 2

EXCEL-ABSOLUTE REFERENCE l The absolute reference for the range would be $A$1: $B$2. l You select a range by dragging, for example from the upper left cell to the lower right cell. l As you drag, the Name Box shows the number of rows and columns that are selected. l Once you quit dragging, the Name Box displays the upper left cell.