ITM 215 Class 15 Mar 16

ITM 215 Class 15 Mar 16 - ITM 215: Computer Applications in...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style ITM 215: Computer Applications in Excel Basics & Formatting
Background image of page 1

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel Objectives Understand the use of spreadsheets and Excel Learn the parts of the Excel window Scroll through a worksheet and navigate between worksheets Create and save a workbook file Enter text, numbers, and dates into a worksheet Resize, insert, and remove columns and rows 22
Background image of page 2
New Perspectives on Microsoft Office Excel Objectives Select and move cell ranges Insert formulas and functions Insert, delete, move, and rename worksheets Work with editing tools Preview and print a workbook 33
Background image of page 3

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel Introducing Excel Microsoft Office Excel 2007 (or Excel) is a computer program used to enter, analyze, and present quantitative data A spreadsheet is a collection of text and numbers laid out in a rectangular grid. Often used in business for budgeting, inventory management, and decision making What-if analysis lets you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values 44
Background image of page 4
New Perspectives on Microsoft Office Excel Introducing Excel 55
Background image of page 5

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel Exploring Excel 66
Background image of page 6
New Perspectives on Microsoft Office Excel Navigating a Worksheet Excel provides several ways to navigate a worksheet 77
Background image of page 7

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel Planning a Workbook Before you begin to enter data into a workbook, you should develop a plan Planning analysis sheet 88
Background image of page 8
New Perspectives on Microsoft Office Excel 99 Active Cell Heavy Boarder Around a Cell Indicates it is the Active Cell - the One You are Currently Working on.
Background image of page 9

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel 1010 Formula Bar The Contents of the Active Cell are Displayed in the Formula Bar
Background image of page 10
New Perspectives on Microsoft Office Excel Entering Text, Numbers, and Dates Text data is a combination of letters, numbers, and some symbols Number data is any numerical value that can be used in a mathematical calculation Date and time data are commonly recognized formats for 1111
Background image of page 11

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel 1212 Name Box Cell Reference for the Active Cell, or Its “Name”
Background image of page 12
New Perspectives on Microsoft Office Excel 1313 Status Bar At the Bottom of the Worksheet. Keeps You Informed as to What is Happening; Displays Information about Selected Command or
Background image of page 13

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel 1414 Screen Tip Point to a Button and Its Name or Function is Displayed
Background image of page 14
New Perspectives on Microsoft Office Excel 1515 Cell Reference Column and Row Designation, For Example A9 is Column A Row 9
Background image of page 15

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel Excel Stores Date & Time as serial integers January 1, 1900 is “1” Right now we are in the 39,000 range 1616
Background image of page 16
Examples Show Examples of: Active Cell Name Box
Background image of page 17

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

View Full DocumentRight Arrow Icon
Image of page 18
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 62

ITM 215 Class 15 Mar 16 - ITM 215: Computer Applications in...

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

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