Hermit's Free Library Brain Teasers
Hermit's Free Library Brain Teasers
In the Good Old Days...
"You cannot load information directly from a spreadsheet into Ventura Desktop Publisher. You can, with effort, incorporate data from a spreadsheet into Ventura. My advice, however, is to use spreadsheet data only if it is necessary..."
Schuyler W. Lininger, Jr. Ventura Publisher Tips, Tricks, and Traps. 1989. Que Corporation
These brain teasers demonstrate how the imaginative use of application software features can accomplish tedious, time-consuming tasks involving potentially large amounts of data with a tiny fraction of the effort required to do them manually.
Many of the examples show how data can be shuffled between two or more application to exploit their respective strengths as part of the total solution.
Read the brain teasers and check out the provided data. Cast your mental net wide and see if a solution appears. Multiple solutions are possible, but elegance, speed, and simplicity are the goals.
If you're stumped, all the brain-teasers include solutions with step-by-step instructions. Give them a try - easy, fun, and fast - once you know how!
#1 Moving Items Up and Down in a List
#2 Sort a Table and Transpose Columns
#3 Transpose Table Rows and Columns
#4 Manipulating Dates and Transforming Lists
#6 Text Data Clean-Up and Count
#10 Create a Spreadsheet in Notepad
