Best ways to learn details about Excel and Word?
 

Ok here is the situation. I am applying to an x-ray technician program taught at a local community college. Because this program has a high amount of computer-related work, they require you to take a prerequisite computer fluency test called IC3.

The test is divided into 3 different sections: Hardware, Internet/networks, and key applications. I passed the Hardware and Internet/networks sections easily, however I didn't pass the key applications section which focuses on Word and Excel. Of course I've used these programs many times in college, but there were questions about things I've never had to do. Here are some examples from a sample test:

- In this excel spreadsheet replace all occurances of "Milan" with "Paris."
- In this word document specify that the selected graphic will be positioned at exactly 3 inches from the left margin.
-In this excel spreadsheet move the cell pointer to the last line using only a keyboard action.
- In this excel spreadsheet combine columns A and B.

So basically I need to learn the nitty gritty details on these two programs, which is probably a good thing.

So if anyone knows any particularly good tutorials or books, that would really help me out. Thank you !

You mean besides just playing with it?

- Edit > Replace all
- Right click picture and check for image properties. It's probably in there
- Ctrl+End
- Combine = add? --> go to C1 and either use the formula function to create a sum function, or just enter (no quotes) "=sum(a1:b1)". Hit enter, then grab the little black dot in the bottom right hand corner of C1 and drag it down to replicate the formula.

-Word tutorial - http://www.baycongroup.com/wlesson0.htm | http://www.fgcu.edu/support/office2000/word/
-Excel tutorial - http://www.baycongroup.com/el0.htm | http://www.fgcu.edu/support/office2000/excel/

Then there is always the Microsoft Office for Dummies series, or any other books with Microsoft and Office in the title. That will definitely get you through to Intermediate levels with Office.

On one hand, you might not need this work. I plan on going to medical school and when I worked with my aunt (a board-certified radiologist) I spent a lot of time with her and her technicians. There was absolutely NO use of any Microsoft program from Office. Every word that is documented is done via a proprietary system that you would learn on training. I went through every detail with my aunt and her technicians, no Word, Powerpoint, Excel or anything EVER occurred.

That could just be her hospital (Virginia Mason Hospital), but I dount you need Office experience with radiology.

MeanSpleen thank you for the links, I will check them out.

Soccerchamp76 I completely agree with you, I doubt I would need to be entering pictures into word documents in order to be a rad tech. However it's either I pass this exam or I can take a quarter long IT 101 class where they basically teach you how to address e-mails and what a cpu is. I'd rather study to take this exam for a few weeks than sit through a boring class for 3 months.