Apps-T

DAY #4: EXCEL PROJECT #3 – WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS

ASSIGNMENTS
CLASS WORK:  KAITLYN’S ICE CREAM SHOP FINANCIAL PROJECTION
APPLYING YOUR KNOWLEDGE (PART #3 ONLY):  ABSOLUTE CELL REFERENCE (FORMULAS ONLY!)
PROJECT:  LAB 1 AND LAB #1 PART #2 – AUGUST ONLINE TECHNOLOGY EIGHT YEAR FINANCIAL PROJECTION

PRINTING:  PRINT DISPLAY AND FORUMULAS UNLESS NOTED – ALWAYS ADD A FOOTER ON BOTTOM RIGHT OF DOCUMENT – ALL PAGES MUST FIT ON ONE SHEET

WORD LIST – CH #3 QUESTIONS
#REF!, absolute, Assumptions, Copy Cells, drag and drop, Fill Formatting Only, Fill Months, Fill Series, Fill Series, Fill Without Formatting, freeze, IF, keyboard shortcuts, SPARKLINE TOOLS DESIGN tab, what-if