Excel functions
-IF statements (use the dialogue box) just click underneath the header for the true and false statements.
-use logical operators for the final exam (<, <=, >=,)
-click and under the functions (more functions) if more than one condition needs to be met.
=Insurance Premiums, bonuses, awards.
=A 4% raise is awarded to employees working from home or working full-time, all other employees will receive a 2.5 increase.
=Pay grade 1 has a starting bonus of 2,500, pay grade 2 has 5,000, and pay grade 3 has a bonus of 7,500. All other pay grades are invalid pay grades.
-Something in red - definite mistake
-range and criteria have to be connected.
-name ranges = help as absolute values