Transcript Excel

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 ( >, <, =, >=, <=, <>)
A2 >= B2 can be true / false depending on numbers in cells
true or false section chosen according to condition
section result displayed in cell


A
B
1
Age
Voting Age
2
17
18
3
22
4
19
C
=if(A2>=B2,”Y”,”N”)
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

A
B
C
D
1
Annual Rate
Years
Loan Amount
Monthly Payment
2
5.5%
5
12999
=PMT( A2/12, B2*12, C2 )
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
A
B
1
Age
Voting Age
2
17
18
3
22
4
19
C
=if(A2>=B$2,”Y”,”N”)
Absolute address applied to row number
PowerPoint – Outline tab


title above is 1st level,
this line and the line above are 2nd level

this line 3rd level


demote – move from higher to lower level


use tab
promote – move from lower to higher level


this line is 4th level
use shift+tab
return – create new entry at current level

to create new slide repeat shift+tab until at top level
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
PowerPoint – Action Buttons


controls to use while the show is running
place button by:

choose Slide Show.. Action Buttons




Jump Back
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
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