Spreadsheet Production
Assignments
Table of Contents:
Daily Assignments
|
Required Exercises |
Assignments Completed
Daily Assignments:
2/14/12, Tue: More
Functions and Formulas
Interactive
demonstration and discussion on mathematical operators, insert functions, AutoCalculate, manual calculation, and define names. (p. 131-137)
Exercise on order of precedence
(order of operations)
2/10/12, Fri: Review
of Spreadsheet Features
Complete the Spreadsheet I
Final Exam, compare and correct the results, and email to your instructor.
Discussion of features that
need review.
Interactive demonstration and
discussion on mathematical operators & insert functions
2/9/12, Thu: Course
Introduction
Syllabus
Spreadsheet I Final Test as an
assignment to determine what you know. Compare your results with
Asgmt Final Exam - KEY.pdf
Required Exercises
Printer friendly version: Spreadsheet I
Assignments
The exercises underlined below are required.
Compare each completed exercise with its solution (found in the Blue
Solutions book). Any errors that you find should be corrected before
emailing to your instructor. See
How to Turn In Exercises. Successful completion of these exercises is
necessary to doing well on tests. Exercises must be turned in prior to
the quiz that covers those skills.
Exercises:
Underlined = Required Exercises
Extra Credit = any assignments
previously approved by your instructor
Chapter 7: MORE FUNCTIONS AND
FORMULAS.........................................
Exercise 9
PRACTICAL FORMATTING AND CHARTS
.................................................
Exercise 10
PASTE SPECIAL FEATURES
......................................................................
Exercise 11
SALESCONT
&
ORGANIC
3-D FORMULAS & DUPLICATE WINDOWS
................................................
Exercise 12
CHIPCOSTS
& PAYROLL
Chapter 9: WORKING WITH
DATA RANGES.............................................
Exercise 13
SUMIF AND COUNTIF FUNCTIONS
...............................................
Workbook Provided
CGISALES
BUDGET Worksheet
PIVOT TABLES
.............................................................................
Workbook Provided
