Microcomputer Applications

1
Microcomputer Applications
MIS 1503 -- Spring 2004

• Excel Displays Formulae

Instructor John Seydel, Ph.D.
2
Administrative Stuff

• Today
• Return stuff
• Quiz / comments
• Word exercises (forthcoming)
• Partly completed
• Full points for reasonable efforts
• Noting items for correction
• Project 4
• Lessons
• Challenge
• Any questions?
• Excel
• Other . . . ?

3
Summary of Objectives

• Create Good Displays
• Format numbers (and remove formats)
• Align cell contents
• Change font and font size
• Apply bold, italic, and underline
• Add color
• Add borders
• Use format painter
• Work with Formalae
• Work with operators and order of precedence
• Use type and/or point to enter formulae
• Compare absolute and relative cell references
• Create and copy formulae with absolute or
  relative cell references
• Freeze and split the worksheet display
• Hide and unhide rows and columns
• Display formulae instead of formula results

4
Formatting Examples
Good Example
Not a Good Example
5
Center Versus Merge and Center
Centering aligns data within its own cell. Great
for column headings.
Merge and Center allows centering across a
selection of cells. Great for titles on a
worksheet.
6
Order of Precedence

• Parentheses are figured first (23)
• Brackets are figured next 3(46)
• Multiplication and division are next, from left
  to right 68
• Addition and subtraction are last, from left to
  right 5-3

• Examples
• 323 (32)3
• 36 9 53 15
• 35(42)/2
• 356/2
• 330/2
• 90/2 45

7
Types of Formula Errors

• Forget the equal sign at the beginning of the
  formula
• Type the formula incorrectly
• Forget a comma
• Attempt to divide by zero
• Use an incorrect function name
• Use an invalid cell reference
• Use the wrong type of operand or argument in
  formula

8
Type-and-Point
Type-and-point makes typing a formula much
easier since you do not need to know the cell
references before beginning.
Enter
9
Absolute vs. Relative References

• C15
• C15
• If copied down one row
• C15
• C15

• Relative Reference
• Absolute Reference
• C16
• C15

10
Displaying Formulas

• Why we might want to display formulae rather than
  the results
• To figure out an error in the calculations
• To print the formulae for future reference, in
  case something happens to the original
• As a reference for someone else, especially users
  with little experience

11
Summary of Objectives

• Create Good Displays
• Format numbers (and remove formats)
• Align cell contents
• Change font and font size
• Apply bold, italic, and underline
• Add color
• Add borders
• Use format painter
• Work with Formalae
• Work with operators and order of precedence
• Use type and/or point to enter formulae
• Compare absolute and relative cell references
• Create and copy formulae with absolute or
  relative cell references
• Freeze and split the worksheet display
• Hide and unhide rows and columns
• Display formulae instead of formula results

12
Appendix
13
Organizing Your Files

• Desktop (or floppy drive root folder)
• Misc
• HomePage.txt
• HomePage.htm
• astate_logo.jpg
• Day1
• FirstExcel.xls
• Access
• Excel
• revenues.xls
• . . .
• PowerPoint
• Word
• ProposalLetter-WB2L.doc
• AddressLabels-WB2L.doc
• OfficeSoftware-WB3L.doc
• . . .

14
Copying Desktop to a Floppy

• Open Windows Explorer (should already be open)
• Scroll to top in Folders panel and click on
  Desktop
• In Contents panel select the folders youve
  created
• Click on first
• While holding down the Ctrl key, click on the
  other folders
• Click on Edit on the Menu bar
• Scroll to and click on floppy disk in Folders
  panel
• Click on Paste on the Menu bar

15
Setting up Windows Explorer

• Start by setting the view to details
• Click on View in the menu bar
• Select Details
• Then make extensions visible
• Click on Tools in the menu bar
• Then select Folder Options
• Click on the View tab
• Uncheck the Hide extensions . . . box
• Click on OK
• Make the settings universal
• Click on Tools and then Folder Options
• Click on the View tab
• Click the Apply to All Folders button