Advanced Productivity Tools for Business (CS88)

Monday, December 22, 2008

A list of homeworks

1) In this other book, available here, on page 104, perform exercises 41 through 44, as well as 49. See if you can do exercise #50. Throughout, gives names to the input cells. Hint for #50: The most straightforward way to approach this is with a text formula, from chapter 5 in the book. Sign the Excel spreadsheet.

Submit it through Blackboard or, barring that, email it to me.

2) In the online book, page 289, questions 23 - 27.

3) Implement the database as described in the video here:

4) Modify earlier example using match and offset to allow a primary key, rather than just relying on Order.

5) Homework:
a) Do relational database with MATCH and INDEX.
b) Given a field containing someone's firstname middlename lastname, extract the middle name.
c) Let us say that a sentence can contain up to 5 words. Combining IF with SEARCH, write a formula which will tell you how many words exist.
d) Write a UDF which returns X squared.

6)
a) Generate the ASCII chart using the code function.
b) Using the pattern in the book as a template, write a formula which will make a letter uppercase.
c) Write a statement using the AND function and CODE function which tells whether a character is a lowercase character.

7)
Ch 17, do the Progress towards a goal, and the Gantt chart.