ITM%20215%20Class%2020%20Apr%205(1)

ITM%20215%20Class%2020%20Apr%205(1) - ITM215:Computer...

Info iconThis preview shows pages 1–16. 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  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 22
Background image of page 2
   New  Planning an Excel Application An  Excel application  is a spreadsheet  written or tailored to meet the user’s  specific needs 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  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 44
Background image of page 4
   New  Naming Cells and Ranges 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  66 Name Box Cell Reference for  the Active Cell, or  Its  “Name”
Background image of page 6
   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 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  88 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 8
   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 99
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 1010
Background image of page 10
   New  Validating Data Data Type Reasonable Consistent Range Acceptable  Value Etc. If-Then-Else, Do Statements,  Loops
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  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 1212
Background image of page 12
   New  Adding Worksheet  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  Show Examples Naming Cells and Ranges Data Validation Comments 1414
Background image of page 14
   New  Macro Overview Use macros to automate repetitious  tasks Macro is a set of instructions for  Excel Macro instructions are written in the  Visual Basic for Applications (VBA) 
Background image of page 15

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

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

Page1 / 53

ITM%20215%20Class%2020%20Apr%205(1) - ITM215:Computer...

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

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