Apemag

  • About
    • Open Source
    • Examples of Student Work
    • Mr. V
      • Contact
    • Grading
      • Participation
      • Participation: How To
    • Scope
    • Bells
    • Hand Outs
  • Photo
    • Photo I
    • Photo II
    • Genre
    • Expression
    • Research
    • Concepts
    • MVP
    • PVA
  • See
    • How To
    • PS CC
    • Rolland Cut Studio
    • PS CS4
    • Adobe Capture
    • Process
  • AI
    • Screen Printing
    • AI Toolbox
  • PS
    • PS Lessons 1-4
      • Photoshop Paint Bucket Lessons
      • Photoshop Basic Tools Lessons
      • Photoshop Paint Brush Lessons
      • Photoshop Layers Lessons
    • PS Lessons 5-10
      • Photoshop Free Transform Lessons
      • Photoshop Clone Stamp Lessons
      • Photoshop Healing Brush Lessons
      • Photoshop Selection Tools Lessons
      • Photoshop Light Adjustment Lessons
      • Photoshop Hue Saturation Lessons
    • PS Lessons 11-14
      • Photoshop Text Lessons
      • Photoshop Blur Effect Lessons
      • Photoshop Green Screen Lessons
      • Photoshop Water Mark Lessons
    • PS Lessons 15-18
      • Photoshop Filters Lessons
      • Photoshop Line Drawing Lessons
      • Photoshop Opacity Lessons
      • Photoshop Advertisement Lessons
  • Tools
    • Photo Collections
    • Photoshop CC Tutorials
    • Photoshop Toolbox
    • Photoshop CS4 Tutorials
    • Photoshop Assessments
    • Photoshop Advanced Lessons
    • Templates
  • GA
    • Vinyl
    • Screen Printing
    • Logo
    • Animation (PSCC)
    • Animation (PS4)
    • Advanced Graphic Arts
    • Visual Media (Photoshop)
    • Graphic Arts Concepts
    • Photoshop Advanced Lessons
    • Visual Media (Microsoft Word)
    • Wood Concepts
  • ENG
    • English 10
      • English 10 Vocab
      • Domains of Writing
      • Mood Tone and Theme
      • Essays
      • English 10 Files
      • English Tools
      • AudioBooks
      • More Eng Vids
      • Figurative Language
      • Propaganda
      • English 10: Persuasive Essay and Research
      • E10 Mid Term
        • Mid Term Study Guide
        • Mid Term Study Guide Answers
    • English 11
      • Career Research
      • English 11 Vocab
      • English 11 Files
      • English 11 Audiobooks
      • English 11 Ideas
      • English 11 Videos
    • Essays
      • Fear Essay
      • Mobile Device Essay
      • Overload Essay
    • MLA
    • Independent Reading
      • IR Visual Guidelines
      • IR Essay Guidelines
  • Biz
    • Personal Finance
      • Simulation Tutorials
    • Computer Applications
    • Excel
  • Draft
    • Drafting Tutorials
    • Drafting (All)
    • Moyer’s Google Page

Excel 12

Excel

Hint – Page 151 – Assessment 5 – Paradigm Text

HINTS: #2. =SUM(Hourly Wage*Hours)+(Hourly Wage*Overtime*$Overtime$Rate) #6. Highlight A3-A17 before applying a Sort Filter #7. -Page Layout Tab -Scale To Fit Menu – Margins Tab -Center on Page -CHECK “Horizontally” -CHECK “Vertically” Don’t Forget to add the appropriate footer with: Name, Page #, and Assignment #. Look at your assignment in Print Preview, ensure that it looks […]

Excel

Hint – Page 150 – Assessment 4 – Paradigm Text

Look on Project 4B on page 54 for help “Writing a Formula with Nested IF Conditions”. Here is how the “nested IF” begins:  IF(E4>99999,”10% This assignment will not be printed, rather graded on your computer.

Excel

Hint – Page 150 – Assessment 3 – Paradigm Text

This assignment will not be printed, rather graded on your computer.

Excel

Hint – Page 150 – Assessment 2 – Paradigm Text

HINT:  Don’t forget to divide the interest rate by 12. Why? If you were paying an annual interest rate of 10% you would need to divide that interest rate by 12 in order to find out the monthly interest rate.  In this case: (.10/12) Fit the assignment to one page, apply the appropriate footer, print and submit assignment.

Excel

Hint – Page 149 – Assessment 1 – Paradigm Text

HINT: When calculating the percentages in the C4 “If statement” be sure and key the percentage as a decimal. This assignment will not be printed, rather graded on your computer.

Excel

Hint – Page 146 – Case Study Part 2 – Paradigm Text

In Part 2 on Page 146 You are asked to: Insert in cell C6 a formula that calcualtes the future value of an investment. TIP: Here is that formula for cell C6:  =FV($C$5,B6,-$D$3) You will printing two documents for this assignment. 1. With a contribution of $2000 2. With a contribution of $3000 PRINT: Scale […]

Excel

Hint – Page 145 – Case Study Part 1 – Paradigm Text

Case Study Part 1 asks to “In column G, insert a formula using the PMT function (enter the Pv as a negative).” TIP 1: Don’t forget to enter the Pv as a negative. Why a negative? Because that is the amount to BORROW. TIP 2: When entering the interest rate (E7), make sure and divide […]

Excel

Hint – Page 143 – Assessment 2 – Paradigm Text

Instruction #6 on p. 143, Assessment 2, states: Specify the column row titles (A3 through A22) are to print on each page. HINT: 1. Goto the Page Layout Tab 2. Click on the Print Titles Icon 3. Set the Columns To Repeat at Left to A3:A22

Excel

HINT – Excel – Pg. 104 – Paradigm Text

Midterm Assessment: #2 Page: #104 Filename: YourLastname_L1_C3_A2_p.104.xsl What does a “DATE” function look like? EXAMPLE:    =DATE(2011,4,10)

Excel

Hint – Page 64 – Assessment 6

Remember to type on the spreadsheet: -Your Name -Your Class Period -The Day (Odd/Even) -Remember to Display Formulas before printing.  (Control + ~) -See page 55 Project 4C for help with the IF Formula. Your spreadsheet should look something like this:

Excel

Hint – Page 63 – Assessment #4

Example from – p.54 4B =IF(E16>89,”A”,IF(E16>79,”B”,IF(E16>69,”C”,IF(E16>59,”D”)))) Hint for – p.63 Assessment #4 C4 =IF(B4>X, “Platinum”,IF(B4>100000,”X“, IF(B4>75000,”X“,IF(B4>X, “X“)))) D4 =IF(C4=”Bronze”,”None”,IF(C4=”X“,3000,IF(C4=”X“,X,IF(X=”X“,X

Excel

Excel – Course Objectives

Microsoft Excel 2007 Level 1 & 2 Rutkosky, Seguin, Rutkosky 2008 by Paradigm Publishing, Inc Chapter 1 Pages 7-36 • Identify the various elements of an Excel Workbook • Create, Save, and print a workbook • Enter data in a workbook • Edit data in a workbook • Insert a formula using the Sum button […]

Photography
  • 31 Days to a Better Photo
  • Kyle Dempsey (Instagram)
  • SmugMug Films
  • Trout and Coffee (YouTube)
Photoshop Links
  • 1001 Fonts
  • Anderson Frye
  • Cathy Pierson Basics
  • distans exercises
  • Ms. Loke
  • Simple Photoshop Tools
  • TinaAvalon
Visual Media
  • Jerry Travis
  • Tonya Skinner
English Tubes
  • Alexander Clarkson
  • Bob Ahlersmeyer
  • Eric Odegaard
  • Tim Mcgee
Photoshop Tubes
  • Blue Lightning TV
  • Wes Robinson (DTown)
Technology Education Links
  • Technology Student (WATT)
  • Twin Valley Technology Education
Teacher Links
  • DRC
  • M-Socrative
  • Poll Everywhere
  • Take The Poll
More Teacher Links
  • E Reading Worksheets
  • English For Everyone
  • News ELA
  • Read Write Think
  • SAS
  • Teaches Pay Teachers
  • Thomas Jefferson Quotes
  • Web English Teacher
Design
  • Illustration Friday
  • Jim Howard CYHS
  • Jim Howard on Sk8Crit
  • Mr. Eagen
  • Mr. Ratkevich
  • Preston High
  • ReWired
  • Strathhaven
English Goods
  • 100 Persuasive Essay Topics
  • 101 Persuasive Essay Topics
  • 10th Grade Lesson PLans
  • BNW (Mrs. Berry's)
  • Brave New World (Spark Notes)
  • Brave New World Study Guide 1
  • English for Everyone
  • Jefferson English Links
  • Plot
  • SAT Vocabulary Lists
  • The Pearl PDF
  • The Race to Save Apollo 13
  • TWC Soft Rainns (.ppt)
  • TWC Soft Rains (pics)
  • Words of Sympathy
2018 © Education Monkey
 

Loading Comments...