Frequently asked Questions
General Questions
- Have you seen Microsoft Vista and Office 2007 and what do you think? Should I get one or both?
- How do they figure out the date for Easter? (Western version - The answer opens in Excel)
- You told us to NEVER spell résumé, resume. Can you remind me how to find the right letter if my program doesn't have the Insert Symbol option?
- Is there an easy way to save multiple attachments I receive in a single e-mail?
- I upgraded to Windows XP, what happened to Scandisk?
- We talked about some cooking substitutions and tips during breaks. Do you have them listed anywhere?
Word Questions
- How can I sort a list of uneven word count by the last word?
- How do I add a watermark to a Word document?
- In Word 2007 when I drag rows from one table to another table, the rows are inserted, but the row above the inserted ones gets last row formatting and the row below the inserted ones gets header row formatting. Am I doing something wrong?
- Is there any way I can get rid of all those hyperlinks when I copy and paste from the web into Word?
- Is there a way to ungroup WMF files in 2007 like we did in 2003?
- When I try to total a column in a Word table that includes empty cells, the answer is always wrong. How can I make it work?
- When you type three or more of certain characters (ie: -,=,*) and hit enter, Word automatically puts a line across the page. How do I get rid of one I don't want anymore or how do I make it stop doing this?
- Where is (fill in command here) in Word 2007?
- Why doesn't my ribbon look like the one in the book? How come I don't have the buttons at home that we have at school? Why can't I find this command?
Excel Questions
- Can I have the sheet name automatically display in the worksheet?
- Do you have any examples for using functions?
- How can I figure out someone or something's age in Excel if I have their birth date?
- How come I have funny characters (',",^) showing in the formula bar at the beginning of each cell?
- I am trying to use the "&" character in a header/footer. It will not print or show in print preview but will otherwise display. How can I fix this?
- If I have a date in Column C, how can I get Column D to automatically show Friday's date?
- I have a contract date that I would like to have Excel figure a due date of two business days later. Is there any way I can do that?
- I have an Excel table that has the name all in one field. How can I fix this?
- I import a lot of stuff from text files, but the numbers come in as text and sometimes include spaces, is there an easy way to fix this?
- Is there an easy way to fill alternate rows with color?
- How can I add total hours? I always get an answer less than 24?
- How can I change the way a new blank workbook looks when it opens? I always want (fill in your choice: the header, the footer, etc.) to be the same for every workbook, is there a way to do it?
- Where is (fill in command here) in Excel 2007?
PowerPoint Questions
- I saw a presentation where they clicked to flip an object and then clicked to flip it back. How did they do that?!
- What happened to all the layouts in PowerPoint 2007? You can't switch graphics from left to right with a layout anymore?
- When I changed the slide design, some slides didn't change, what happened? Is there an easier way to fix it then by changing it manually?
- Where is (fill in command here) in PowerPoint 2007?
Access Questions
- Do you have a list of Access Operators?
- How can I determine an age in Access?
- How do you create an Access query to find everyone born in a certain month, regardless of year?
- I have an Access table that has the name all in one field. Is there an easy way to divide it into Last Name and First Name columns?
- Where is (fill in command here) in Access 2007?
