Excel for Marketing Managers

Table of Contents

• Calculation Basics Preface.......................................................................................e
  
  
  • Using the Touch-Typing Method (Addition)
  
  
  • Using the Mouse Method (Subtraction)
  
  
  • Using the Arrow Key Method (Addition and Subtraction)..............................................
  
  
  • Entering Multiplication Problems
  
  
  • Entering Division Problems...........................................................................................
  
  
  • Entering Fraction Problems
  
  
  • Using Parentheses to Control the Order of Operations
  
  
  • Calculating Squares, Cubes, Square Roots, Cube Roots
  
  
  • Adding a Column of Numbers.......................................................................................
  
  
  • Calculating an Average
  
  
  
  


• Printing Grid Paper
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application.................................................................................................................
    
    
    • Adding Gridlines
    
    
    • Configuring Print Settings
    
    
    • Saving the Document....................................................................................................
    
    
    • Printing the Grid Paper..................................................................................................
    
    
    
    
  
  
  • Excel Extras
    
    
    • Making Larger Grids
    
    
    • Isometric Grid Sheets....................................................................................................
    
    
    
    
  
  
  
  


• Cartesian Coordinate Grids
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application.................................................................................................................
  
  
  • Excel Extras
    
    
    • Grids with Points or Lines
    
    
    • Handout Sheet...............................................................................................................
    
    
    
    
  
  
  
  


• Multiplication Tables ii Excel for the Math Classroom
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
    
    
    • Using the Fill Handle to Extend a Series
    
    
    • Copying a Range on its Side
    
    
    • Entering a Single Formula for Many Cells
    
    
    
    
  
  
  • Using the Application.................................................................................................................
  
  
  • Excel Details................................................................................................................................
    
    
    • Simplifying Dollar Sign Entry in Absolute and Mixed References
    
    
    • More Cool Fill Handle Tricks
    
    
    
    
  
  
  
  


• Math Exercise Sheets
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
    
    
    • Basic Math Facts: Adding Two Terms with an Answer Under 10................................
    
    
    
    
  
  
  • Using the Application.................................................................................................................
    
    
    • Keeping the Worksheet from Changing
    
    
    • Adapting for Multiplication............................................................................................
    
    
    • Creating an Answer Key
    
    
    
    
  
  
  • Excel Details................................................................................................................................
    
    
    • Subtracting with Two-Digits Without Regrouping
    
    
    • Expressing Problems That Go Across the Page
    
    
    • Avoiding Duplicate Problems
    
    
    
    
  
  
  
  


• Arithmetic Facts Quiz................................................................
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application.................................................................................................................
  
  
  • Excel Extras
  
  
  
  


• Homework Checker
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application.................................................................................................................
  
  
  • Excel Details................................................................................................................................
    
    
    • Adding Color Based on a Result
    
    
    • Where Did They Go Wrong?
    
    
    
    
  
  
  
  


• Magic Squares
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application.................................................................................................................
  
  
  • Excel Extras
  
  
  
  


• Coordinate Grid Matching.......................................................... Excel for the Math Classroom iii
  
  
  • Opportunity..................................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  • Excel Extras
  
  
  
  


• Math Art
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
    
    
    • String Art ......................................................................................................................
    
    
    • Tessellations................................................................................................................
    
    
    
    
  
  
  • Using the Application..............................................................................................................
  
  
  
  


• Candy Bar Fractions
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  
  


• Math Facts Game
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  
  


• Secret Code Maker..................................................................
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  • Excel Extras
  
  
  
  


• Probability with Coins or Dice
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution – Tossing a Coin................................................................................
  
  
  • Using the Coin Toss Application............................................................................................
  
  
  • Creating the Solution – Rolling a Die
  
  
  • Using the Roll the Die Application
  
  
  • Excel Extras
  
  
  
  


• Demonstrating and Comparing Fractions with Charts............... iv Excel for the Math Classroom
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
    
    
    • Making a Worksheet Not Look Like Excel..................................................................
    
    
    • Customizing a Chart
    
    
    
    
  
  
  • Using the Application..............................................................................................................
  
  
  • Excel Extras
    
    
    • Pie Chart with Only One Section Filled in
    
    
    • Pie Charts Showing Difference between Two Fractions............................................
    
    
    
    
  
  
  
  


• Finding Maximum Area and Volume
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview – Farmer’s Fence
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  • Excel Extras
  
  
  • Solution and Overview – Popcorn Box
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  
  


• Solving Systems of Equations..................................................
  
  
  • Opportunity...............................................................................................................................
  
  
  • Solution and Overview
  
  
  • Creating the Solution
  
  
  • Using the Application..............................................................................................................
  
  
  • Excel Extras
  
  
  
  


• Index