Tutor profile: Katherine K.
Subject: Microsoft Excel
How can I get Microsoft Excel to allow leading zeros in a field, such as when creating a database of addresses for mail merge?
In order to allow for leading zeros in such a scenario, you would select the column that needs to contain leading zeros. In the case of a mail merge database, this is usually a zip code field. You would choose 'Number Format' then 'More Number Formats' from the drop-down menu, then choose 'Special -->Zip Code'. If, on the other hand, it is not a mail merge database, under 'Number Format' you could simply choose 'Text' to allow leading zeros to appear.
Subject: Study Skills
What are some ways to retain what you've read in textbooks?
One of the best methods to retain a lot of what you read for homework are to first scan the text, noting any subheadings, charts, tables and bolded words, then rereading the text to expand on those notes. If you have the time, try re-stating key concepts from the reading in another way. A modified version of this will also work if you are pressed for time. You would scan the text, taking note of subheadings, charts, tables, and bolded words, then read the abstract (if present), introduction and conclusion/summary.
Subject: Library and Information Science
What is the purpose of a librarian, especially in the digital age?
A librarian can organize information so that it is more easily accessible to students and serve as a resource to help students when they run into problems with their research.
needs and Katherine will reply soon.