ITM%20215%20Class%2018%20Mar%2029

ITM%20215%20Class%2018%20Mar%2029 - ITM215:Computer...

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

View Full Document Right Arrow Icon
ITM 215:  Computer  Application in  Business
Background image of page 1

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

View Full DocumentRight Arrow Icon
 7/19/2007  New Perspectives  Last Day to drop course and  receive a “W” Last Day to opt for S/U  grading or return to A-E  grading Drop & Grading:  Mar 30 
Background image of page 2
 7/19/2007  New Perspectives  Format and edit multiple worksheets  at once Create cell references to other  worksheets Consolidate information from multiple  worksheets using 3-D references Create a link to data in another  3 Objectives
Background image of page 3

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

View Full DocumentRight Arrow Icon
 7/19/2007  New Perspectives  Learn how to edit links Create and use an Excel  workspace Insert a hyperlink in a cell Create a custom template 4 Objectives
Background image of page 4
 7/19/2007  New Perspectives  Using multiple worksheets makes it  easier to group and summarize data 5 Using Multiple Worksheets
Background image of page 5

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

View Full DocumentRight Arrow Icon
 7/19/2007  New Perspectives  A worksheet group is a collection of  two or more selected worksheets Use the Shift Key to select a contiguous group of sheets Use the Control Key to select a  non- contiguous group of sheets To ungroup the worksheets, click the   6 Grouping and Ungrouping 
Background image of page 6
 7/19/2007  New Perspectives  You can copy sheets from  one workbook to another 7 Copying Worksheets  to Another Workbook
Background image of page 7

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

View Full DocumentRight Arrow Icon
 7/19/2007  New Perspectives  8 Worksheet References Allows you to reference cells in other  worksheets in the same workbook Requires using the name of the  worksheet before the cell range Exclamation point separates worksheet  and cell reference =Atlanta!B3 +Boston!B3+Chicago!B3 Worksheet reference is absolute Cell reference can be absolute, relative, or mixed
Background image of page 8
 7/19/2007  New Perspectives  Click the cell where you want to enter the  formula Type = and enter the formula. To insert  a  reference from another worksheet, click  the sheet tab for the worksheet,  and then  click the cell or select the  range you  want to reference When the formula is complete, press the  9 Entering a Formula That 
Background image of page 9

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

View Full DocumentRight Arrow Icon
 7/19/2007  New Perspectives  10 Referencing Other  SheetName!CellReference If the Sheet Name  Contains  Spaces, enclose the Name  in  Single Quotation Marks ‘Year End Summary’!CellReference
Background image of page 10
 7/19/2007  New Perspectives  11 3-D Workbook Electronic equivalent of a 3 ring binder Tabs at bottom display worksheet  names Scrolling buttons allow easy  movement among worksheets Window menu allows for tiling,  cascading options for multiple 
Background image of page 11

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

View Full DocumentRight Arrow Icon
 7/19/2007  New Perspectives  A 3-D reference refers to the  same   cell  or range in multiple worksheets in the  same workbook Click the cell where you want to enter  the formula Type = to begin the formula, type the  name of the function, and then type 12 Using 3-D References to Add 
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 49

ITM%20215%20Class%2018%20Mar%2029 - ITM215:Computer...

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

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