Feb 9, Excel Week 5

Feb 9, Excel Week 5 - ExcelWeek5 Spreadsheets...

This preview shows pages 1–4. Sign up to view the full content.

Excel Week 5 09/02/2008 12:59:00 Spreadsheets Worksheets o o columns labeled with letters of alphabet A to Z, AA to AZ, BA to BZ, etc o Rows labeled with numbers o Max size of worksheet depends on memory available Workbooks o Each c an contain up to 256 worksheets Desktop o Standard menus and bars o Formula bar Cell address Contents of the current cell o Sheet tables Click to activate different worksheets in a workbook Data Entry Three types of data o Text

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
o Values o Formulas Text o Left aligned o Can format Font, size, bold, underline, etc. Values o Quantities Right aligned in cell Converted to scientific notation if wider than cell Negative numbers as -99 or (99) Can include \$ and, Can enter fractions 2 ¼ (note space) or 0 5/16 can enter .12 or 12% Dates and Times o Can be used in formulas 5:46 M, 17:46 5:46:29 PM, 17:46:19 September 21, 1994 9/21/94, 9-21-94
21.Sep-94, 9-Sep, Sep-94 Formula o = to start o displayed on formula bar o no spaces o computed result displayed in cell o result changes if changes in cells referenced by formula o contain +, -, *, / and ^ o calculated from left to right o mathematical order of operations o

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/08/2009 for the course TEFLER ADM1300 taught by Professor Koppel during the Fall '09 term at University of Ottawa.

Page1 / 10

Feb 9, Excel Week 5 - ExcelWeek5 Spreadsheets...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online