Docstoc

Excel Review You may bring a single page cheat sheet with notes in front and back of the sheet

Document Sample
Excel Review You may bring a single page cheat sheet with notes in front and back of the sheet Powered By Docstoc
					1   Excel Review
    Excel exam on 10/24/2011
    You may bring a single page cheat sheet with
    notes in front and back of the sheet




                               CS150
    Create a Worksheet
2


    Plan and develop an efficient format for a
     worksheet
    Enter labels and values
    Develop formulas and use basic built-in functions
     (e.g., SUM, AVERAGE, MIN, MAX, PMT, VLOOKUP)
    Print a worksheet




    CS150
    Edit, Format and Enhance a
3
    worksheet
    Insert and delete rows and columns
    Change column width and row height
    Align text within cells
    Center text across columns
    Use Format painter
    Add and remove borders
    Use relative, absolute, and mixed cell references
    Rename worksheets and rearrange worksheet order
     within a workbook
    CS150
    Edit, Format and Enhance a
4
    worksheet
    Work with workbook documentation
    Add comments in text boxes
    Add custom header, footer
    Print worksheet with formulas
    Develop and format column, bar, line and pie charts
    Move, copy, and delete sheets
    Use sort and filter
    Use Hide, Freeze panes

    CS150
    Other Features
5


    Understand limitations compared to database
     management systems
    Understand and perform “what-if” analysis
    Use the Goal Seek tool
    Link Excel to Word
    Know about available add-in programs




    CS150

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:11/11/2013
language:
pages:5