Archive for August, 2012
You’re in class on the first day and the professor is going over the syllabus. There are readings, papers, quizzes; all of the usual stuff. She says that if you participate in class and turn in your assignments you’ll get a B. Then she mentions the big end-of-semester project that counts for 70 percent of your grade. If you do well on this, you’ll get an A. You hear this and say to youself, “I’d better get started on this right away!” Of course you do. You’re a go-getter.
You decide to make a list of things that would make your presentation stand out.
You may need to save Excel data in text files in order to be able to use the data in other programs or applications. There are several text file formats that are supported by Excel. The two commonly used file formats are: delimited text files (.txt) in which tabs separate each field of text, or comma delimited files (.csv) in which commas separate each field. You can easily save Excel data into one of these formats or import these text formats into Excel. Remember, however, that formatting, graphics, and other objects will be lost when saving data in a text file.
Saving as a Comma Delimited File
We will illustrate how to save Excel columns as a comma delimited file. The original data might look something like this:
NOTE: To display preceding zeros in a column, you can go to the Format Cells dialog box and choose Custom. On the right-hand side, scroll up (if necessary) and click the single 0. In the Type field, enter as many zeros as required digits (in this example, the number of zeros would equal 10).
Apple has made a lot of changes to the behavior of their keyboard shortcuts over the last several operating systems. In the days before Exposé, things were pretty straightforward; the function keys worked the same regardless of how the operating system was configured.
Today, with Mission Control and Exposé, things aren’t so easy. Apple keyboards now have fancy little icons on some of the F-keys, and by default, they don’t function like a windows F-key. This can be confusing and it makes it difficult for us to keep our materials accurate for Macintosh systems.