Apps-B
DAY #3 – 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