COM S 113 Exam 1 Guide 2026: Intro to Excel – Formulas, Charts & Functions (100% Q&A)

EXCEL EXAM COMING UP? Memorize THIS and walk out with 100%! Do you freeze up when the professor asks about the difference between Relative, Absolute, and Mixed Cell References? Does VLOOKUP vs. HLOOKUP make your head spin? Stop stressing. I have compiled ALL of COM S 113 Exam 1 2026 Questions and Verified Answers into a single, cheat-sheet style PDF. This is the EXACT high-yield content you need to pass—no fluff, no 800-page textbook. Here is exactly what you will master: Cell References: Absolute ( A A1) vs. Relative (A1) vs. Mixed ( A 1 o r A A1orA1) – know which one "breaks" when you copy a formula! Charts Decoded: Clustered Column vs. Stacked Column vs. 100% Stacked Column vs. Line vs. Pie (including what "Exploding" a pie slice means). Lookup Functions: VLOOKUP, HLOOKUP, and the dreaded "Column Index" explained in plain English. ️ Critical Functions: AVERAGE, COUNT, COUNTA, MAX, MIN, MEDIAN, FREQUENCY, SUBTOTAL, PMT (loan payments), NOW, and TODAY. Conditional Formatting: Data Bars, Color Scales, Icon Sets, Highlight Cell Rules, and Top/Bottom Rules. ️ Excel Databases: Sorting (text A→Z, values smallest→largest, dates oldest→newest), Filtering, and Structured References. Format: Question on the left → VERIFIED answer on the right. Perfect for active recall, flashcards, or last-night cramming. Don't lose points because you forgot the Order of Precedence (PEMDAS) or what a Breakpoint is. Download this guide, spend 2 hours with it, and ACE Exam 1.