Apps-B

DAY #4 – EXCEL PROJECT #2 – FORMULAS, FUNCTIONS, AND FORMATTING

ASSIGNMENTS
CLASS WORK:  OLIVIA’S ART SUPPLY SALARY REPORT
APPLYING YOUR KNOWLEDGE:  PROXIMITY BUS COMPLETE (FORMULA COPY ONLY)
PROJECT:  LAB 1 – AYLIN INSURANCE PREMIUM ANALYSIS
PROJECT:  LAB 2 – INTERNATIONAL MOVING COMPANY REPORT

PRINTING:

Enter a FOOTER – Click the INSERT TAB – Select the Header & Footer Button – Scroll to BOTTOM OF PAGE – Type Your Name, Bob Gleamin Budget, Period # Today’s Date

DO NOT USE QUICK PRINT

DISPLAY COPY – Tap or Click the FILE Tab – Tap or Click the PRINT tab – SELECT the HP Color LaserJet 3800 – Tap or Click the PORTRAIT ORIENTATION button and select LANDSCAPE – Tap or Click the NO SCALING BUTTON and select ‘FIT SHEET ON ONE PAGE – Tap or Click the PRINT button

FORMULAS COPY – Hold down the CTRL KEY and hit the ACCENT KEY ( ~ ) to display the formula’s copy – Tap or Click the FILE Tab – VERIFY that LANDSCAPE ORIENTATION and FIT SHEET ON ONE PAGE is STILL Selected – Tap or Click the PRINT button.

REVIEW QUESTION WORD LIST: 
Page Layout, division, Page Layout, subtraction, Margins, pixel, warmer, Best fit, fill handle, formula, ESC, Hiding cell, circular reference, mm/dd/yyyy