ITM 215 Class 21 Apr 13

ITM 215 Class 21 Apr 13 - ITM 215 Computer Applications in...

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

View Full Document Right Arrow Icon
ITM 215: Computer  Applications in  Business Application  Development, Names 
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  Make-Up Exam 22
Background image of page 2
   New  Objectives Understanding and Using Defined  Names for cells and ranges Create validation rules for data  entry Protect the contents of worksheets  and  workbooks Add, edit, and delete comments Understanding Macros and  recording  Macros 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  Planning an Excel Application An  Excel application  is a spreadsheet  written or tailored to meet the user’s  specific needs 44
Background image of page 4
   New  Naming Cells and Ranges A defined name (often called  simply a name) is a word or  string  of characters  associated with a  single cell or a range 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  Naming Cells and Ranges 66
Background image of page 6
   New  77 Name Box Cell Reference for  the Active Cell, or  Its  “Name”
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  Advantages of Defined  Names are more descriptive  than  cell references Names can be used in formulas  (easier to understand the  formula) Moving a cell with a name keeps  the references to it valid 88
Background image of page 8
   New  99 Data Validation Data Validation command  restricts  values to be accepted  in a cell Data validation is useful in  shared  workbooks Garbage In Garbage Out (GIGO) The spreadsheet is only as good as  the data that goes into it. Data validation keeps garbage out  in  the first place
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  Validating Data Entry To ensure that correct data is entered and stored  in  a worksheet, you can use  data validation  to  create a set of rules that determine what users can  enter in a specific cell or range An  input message  appears when the cell becomes active and can be used to specify the type of  data the user should enter in that cell An  error alert message  appears if a user tries  to  enter a value in the cell that does not meet  the  validation rule 1010
Background image of page 10
   New  Validating Data Entry 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  Validating Data Data Type Reasonable Consistent Range Acceptable  Value Etc. If-Then-Else, Do Statements,  Loops
Background image of page 12
   New  Adding Worksheet  comment  is a text box that is attached  to a specific cell in a worksheet Click the cell to which you want to attach  a comment Right-click the cell, and then click Insert  Comment on the shortcut menu (or in  the Comments group on the Review  tab,  click the New Comment button) Type the comment into the comment box 1313
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  Adding Worksheet  1414
Background image of page 14
   New  Show Examples Naming Cells and Ranges Data Validation Comments 1515
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  Macro Overview Use macros to automate repetitious  tasks Macro is a set of instructions for  Excel Macro instructions are written in the 
Background image of page 16
Image of page 17
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/05/2010 for the course COM 4123 taught by Professor Ted during the Spring '10 term at SUNY Albany.

Page1 / 54

ITM 215 Class 21 Apr 13 - ITM 215 Computer Applications in...

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

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