1 / 8

Spring Final Review

Spring Final Review. Excel and PowerPoint. Excel Functions – IF. computer chooses between alternatives = if ( condition, true section, false section ) condition statement can be true or false use 2 cells compared with operators ( >, <, =, >=, <=, <> )

gratiana-hamsey
Download Presentation

Spring Final Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spring Final Review Excel and PowerPoint

  2. Excel Functions – IF • computer chooses between alternatives • = if ( condition, true section, false section ) • condition statement can be true or false • use 2 cells compared with operators ( >, <, =, >=, <=, <>) • A2 >= B2 can be true / false depending on numbers in cells • true or false section chosen according to condition • section result displayed in cell

  3. Excel Functions – PMT • Calculates loan payments given: • interest rate – annual / 12 – aka rate • number of payments – years * 12 – aka nper • loan amount – aka pv • =PMT( A2/12, B2*12, C2) • returns monthly loan payment as negative number

  4. Excel Addresses – relative / absolute • copied formulas are more useful if they are applied to new cells • applying to new cells requires address changes • sometimes you don’t want an address to change • relative = address change / absolute = no change • $ attached to address part  part absolute • addresses have 2 parts – column letter and row number Absolute address applied to row number

  5. PowerPoint – Outline tab • title above is 1st level, • this line and the line above are 2nd level • this line 3rd level • this line is 4th level • demote – move from higher to lower level • use tab • promote – move from lower to higher level • use shift+tab • return – create new entry at current level • to create new slide repeat shift+tab until at top level

  6. PowerPoint – Master Slide • controls to “look” of all slides • change Master to change all slides • format settings – fonts, text color, etc. • images/backgrounds appear on all slides • access Master • View .. Master .. Slide Master

  7. PowerPoint – Action Buttons Jump Back • controls to use while the show is running • place button by: • choose Slide Show.. Action Buttons • a set of predefined buttons appears • select button • click and drag to draw on slide • action settings • pops up as button created or choose Slide Show .. Action Settings • select hyperlink to and choose slide to jump to • option of show and return if jumping to custom slide show

  8. PowerPoint –Custom Slide Shows • allow slides to be grouped for separate showings • to create • choose Slide Show .. Custom Show • dialog box pops up choose new • enter name for show • choose slides to add to show

More Related