|
Students will be able to create an Excel Spreadsheet using Excel 2010. The students will use the objectives below to help them throughout the process.
Chapter 1: Creating a Worksheet and an Embedded Chart
*Describe the Excel worksheet
*Enter text and numbers
*Use the Sum button to sum a range of cells
*Copy the contents of a cell to a range of cells using the fill handle
*Apply cell styles
*Format cells in a worksheet
*Create a Clustered Cylinder chart
*Change a worksheet name and worksheet tab color
*Change document properties
*Preview and print a worksheet
*Use the AutoCalculate area to display statistics
*Correct errors on a worksheet
Chapter 2: Formulas, Functions, and Formatting
*Enter formulas using the keyboard
*Enter formulas using Point mode
*Apply the AVERAGE, MAX, and MIN functions
*Verify a formula using Range Finder
*Apply a theme to a workbook
*Apply a date format to a cell or range
*Add conditional formatting to cells
*Change column width and row height
*Check the spelling in a worksheet
*Set margins, headers, and footers in Page Layout view
*Preview and print versions of a worksheet
Chapter 3: What-If Analysis, Charting, and Working with Large Worksheets
*Rotate text in a cell
*Create a series of month names
*Copy, paste, insert, and delete cells
*Format numbers, using format symbols
*Freeze and unfreeze rows and columns
*Show and format the system date
*Use absolute and mixed cell references in a formula
*Use the IF function to perform a logical test
*Create Sparkline charts
*Use the Format Painter button to format cells
*Create a 3-D Pie chart on a separate chart sheet
*Rearrange worksheet tabs
*Change the worksheet view
*Answer what-if questions
*Goal seek to answer what-if questions
|
