Ch1ClassNotes_sp10a

Ch1ClassNotes_sp10a - Chapter 1: Getting Started with Excel...

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

View Full Document Right Arrow Icon
Chapter 1: Getting Started with Excel 2007 Skills Practice 1. Navigate Excel using the Excel Ribbon a. Ribbon Tabs i. "Home" ii. "Insert" iii. "Page Layout" iv. "Formulas" v. "Data" vi. "Review" vii."View" viii. Context tabs b. Navigate Excel using the Quick Access Toolbar c. Add common commands to the Quick Access Toolbar d. Add other commands to the Q.A. Toolbar 2. Accessing Excel Help features 3. Create, name and save a new Excel file using various “Save” options. (Summary in Table 1-1) a. Excel workbook (the default file format, no support for macros, safer) b. Excel 97-2003 Workbook (compatible with previous versions) c. Macro-enabled Workbook d. Other Formats (we will practice with some of these later in the semester) i. Delimited text files For importing/exporting (non-Excel) data. (Topic of ch. 5) ii. PDF capability by integrating with Adobe Acrobat (also .xps which is Microsoft’s version of portable document files) iii. Web page formats iv. XML formats v. and more 4. Selecting multiple cells, rows, columns, or worksheets a. Contiguous ranges: Press Shift key while selecting b. Non-contiguous ranges: Press Ctrl key while selecting 5. Entering Excel data a. Enter versus Tab keys b. Enter same value into a contiguous block of cells, Ctrl+Shift+Enter c. Repeat a value in the next row: Ctrl+D (copy and paste in one step) d. Repeat a value in the next column: Ctrl+R (copy and paste in one step) 6. Format cell contents a. Distinguish between a cell’s content and its format i. Example Value: 5634839 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
ii. Some possible formats for the value above formats:
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Ch1ClassNotes_sp10a - Chapter 1: Getting Started with Excel...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online