XLS faculty.fuqua.duke.edu

Excel Basics PracticeThis file provides hands-on exercises to accompany the document named "A Review of Excel Basics". Naming Ranges Exercise 1 Name a Range (method 1)Exercise 2 Name a Range (method 2)Exercise 3 Name a Range (method 3)Exercise 4 Display Range NamesExercise 5 Add a Cell CommentFormattingExercise 6 Merge and CenterExercise 7 Apply FormattingExercise 8 Apply BordersExercise 9 Create a Text BoxExercise 10 Use the Format PainterBasic EditingExercise 11 Edit FillExercise 12 Use Excel Custom ListsExercise 13 Copy and Paste a FormulaExercise 14 Convert Formulas to ValuesExercise 15 Transpose DataFormulasExercise 16 Relative ReferencesExercise 17 Absolute ReferencesExercise 18 Use Built-in FunctionsExercise 19 Using Logical FunctionsExercise 20 Using Formula Auditing ToolsData TablesExercise 21 The One-Input Data TableExercise 22 The Two-Input Data TableChartingExercise 23 Generate a Quick ChartExercise 24 Use the Chart WizardExercise 25 Create an XY Chart ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download