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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
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 Right Arrow Icon
Ask a homework question - tutors are online