Page 17 - MCON 140 Syllabus Test

SAM Excel Homework Assignment #2
EXCEL MODULE THREE Working with Large Worksheets, Charting, and What-If Analysis
● Rotating Text & Using the Fill Handle to Create a Series
● Copying a Range of Cells to a Nonadjacent Destination Area
● Inserting & Deleting Cells in a Worksheet
● Absolute vs. Relative Addressing
● Making Decisions - the IF Function
● Adding & Formatting Sparkline Charts
● Formatting the Worksheet
● Adding a Clustered Column Chart to the Workbook
● Organizing the Workbook
● Changing the View of the Worksheet
● What-If Analysis (Goal Seek Function)
● Insights
SAM Excel Homework Assignment #3
EXCEL MODULE FOUR Financial Functions, Data Tables, and Amortization Schedules
Excel
● ● ● ● ● ●
Creating Cell Names
Using a Data Table to Analyze Worksheet Data Creating an Amortization Schedule
Printing Sections of the Worksheet
Protecting and Hiding Worksheets and Workbooks Formula Checking
SAM Excel Homework Assignment #4
SAM Excel Capstone Project
POWERPOINT MODULE THREE Inserting WordArt, Charts, and Tables
● Adding a Chart to a Slide and Formatting
● Adding a Table to a Slide and Formatting
● Inserting and Formatting a Text Box
● Inserting and Moving Slides
● Inserting Pictures and Adding Effects
PowerPoint
Excel
17