INF2080

=__INF2080: Spreadsheet 2__=
 * Level:** Intermediate
 * Prerequisite:** INF1060: Spreadsheet 1

====Module Assignment Site (Start Modules from Project 3) ====

>
 * When you complete this module, you should be able to:[[image:office-suites-iwork-numbers1.png width="448" height="330" align="right" caption="Students can use Microsoft Excel or iWork Numbers"]]**
 * Create and manipulate data by
 * Using fill
 * Changing worksheet views
 * Using templates
 * Format data and content by modifying rows and columns (Height, width, hiding, alignment, functions)
 * Create and modify formulas
 * Use functions to create average, minimum and maximum; e.g., AVERAGE, MIN, MAX
 * Use functions to count numbers, and count both text and numbers; e.g., COUNT, COUNTA
 * Use functions to calculate interest rates, monthly payments and present value; e.g., PMT
 * Use conditional logic in a formula; e.g., IF
 * Summarize data using subtotals
 * Format and modify text using formulas
 * Look up data using a formula
 * Protect formulas using lock and unlock
 * Create and format charts including 2-D column, pie, scatter, clustered column graph.
 * Inserting, moving and sizing graphics from an outside source; e.g., the Internet
 * Sort and filter data including:
 * Two component simple sort
 * Two component filter sort
 * Outline data
 * Save and publish workbooks and worksheets as Web pages and other formats