Tuesday, May 8, 2012

For the cs88 final


walkenbach:
ch 9 (database functions) (dsum, dcount), which are based on Criteria ranges. Advanced filtering.
ch 17 (advanced charts). that there is something called a SERIES formula, and how to manipulate it.
appendix C (custom formatting). and recall that can also use these in the TEXT function.
ch 16: intentional circular references. recall that you may need to use a seed.
ch 19: conditional formatting and data validation. recall that in Custom, you can validate data (or color values in cond formatting) based on a formula.

In Grauer:
ch 7 - 11

Sample exam:
1) using database functions, give me the name of the salesman who sold the most widgets.
2) For extra credit, do this without using a range on the spreadsheet.
3) Show a chart which will encompass all salesmen and their widgets sold, which dynamically grows.
4) Show me, using fractions, the percentage of sales that this max salesman brought in. If it is less than 50 percent, color it red. Otherwise, color it Green. Do this using appendix C.
5) Do the same using conditional formatting.
6) give me the all time max and min.
7) Within the salesman table, color any salesman who has less sales than the saleman above red; otherwise, blue.
8) VBA question returning an array. Give me the sum of two arrays.

No comments:

Post a Comment