CS150 Final Exam Review

1. CS150 Final Exam Review CS150

2. What you can bring with you • The paper (cheat sheet) that you used on the excel exam CS150

3. Exam date/Place • 10:00 – 10:50 session: • April 30th, 8-11 am at MP 130 • 11:00 – 11:50 session: • April25th, 12-3 pm at MP 130 CS150

4. Structure of exam • Four parts: you will have to submit all files on BlackBoard • Word: • Instructions on a hard copy • A word document that you will need to modify • Excel: • Instructions on a hard copy • An excel spreadsheet that you will need to modify • Powerpoint: • Instructions on a hard copy • An powerpoint presentation you will need to modify • General questions (multiple choice)

5. Word • Edit and format a document: • Align text • Format paragraphs • Change line spacing • Add bullets and numbers • Use tools for spelling and grammar check CS150

6. Word • Enhance a document • Add headers, footers, and footnotes • Insert and format tables • Format text into columns • Insert page, section, and column breaks • Insert symbols and special characters • Insert a table of contents, index, and bibliography CS150

7. Word • Track changes for better collaboration: • Add comments • Format comments • Create a new header style • Customize tabs • Use filters and equations with tables • Insert password, keywords • Change document properties CS150

8. Excel • Enter labels and values • Develop formulas and use basic built-in functions (e.g., SUM, AVERAGE, MIN, MAX, PMT, VLOOKUP, IF) • Print a worksheet • Insert and delete rows and columns • Change column width and row height • Align text within cells • Center text across columns • Use Format painter

9. Excel • Add and remove borders • Use relative, absolute, and mixed cell references • Rename worksheets and rearrange worksheet order within a workbook • Add comments in text boxes • Add custom header, footer • Print worksheet with formulas • Develop and format column, bar, line and pie charts CS150

10. Excel • Move, copy, and delete sheets • Use sort and filter • Use Hide, Freeze panes • Link Excel to Word, powerpoint CS150

11. Powerpoint • Create a Presentation • Begin with a template or a blank presentation • Create a title slide • Add additional slides in Slide View and Outline View • Work with slides with various AutoLayouts • Use promote and demote for bulleted slides • Use the AutoContent Wizard to select a presentation • Modify presentation in slide view and outline view • Select or change a design template • Modify individual slides and masters (e.g., slide and title) CS150

12. Powerpoint • Rearrange order of slides • Create and print slides, handouts, notes pages, and outline views • Edit, Format and Enhance a Presentation • Use copy, duplicate, delete, and hide slide options • Use transitions and slide animations including builds • Add hyperlinks • Insert multimedia including animations, sounds, and videos • Insert slides from other presentations CS150

13. Powerpoint • Master view • Modify a design using master view • Modify different slide layouts • Animation • Use advanced animation features (triggers, time line etc.) • Insert: • Table • Header/Footer • Charts from excel CS150

14. General Questions • About the Internet • Webpages • Packet transfer • Social networks • History of internet • About the cloud: • What is the cloud • Why is it useful • Applications of the cloud CS150

15. Delayed HW assignments • Delayed homework assignments will be accepted until April 24th • You have to notify me with e-mail if you submit an assignment and you do not see any updates on your grade CS150