Technology Q&A
Ink-jet vs.
laser printers
Convert decimals to
fractions
What you
should know about defragging your hard
drive
Printing just one
spreadsheet column and row
Stop a CD from
automatically starting.
| Key
to Instructions To
help readers follow the instructions in this
article, we use two different typefaces.
Boldface type is
used to identify the names of icons, agendas and
URLs.
Sans serif type indicates commands and instructions that
users should type into the computer and the names
of files.
|
| |
| Q. We need new printers for our office and
my partner insists on buying three low-cost
ink-jet models. He says not only are they cheap
but they can print in black and white and in
color. Somehow I think a laser printereven
if it is more expensiveis better. What are
your thoughts? |
| A. Your partner has a point. Its
wise to have access to a color printer, and
inexpensive ink-jet models do have that plus. The
cheapest color laser, by comparison, costs more
than $1,000. Ink-jet printers have several negative
features, however. While their initial cost is
low (as little as $100), they gobble up ink at a
prodigious rate. As a result, each printed page
costs as much as five centsand thats
just for the ink. A laser printer, on the other
hand, while initially more expensive, generates
each page at a tiny fraction of a cent. In
addition, most laser models print far faster than
ink-jet models, and the printing quality is
generally far superior.
So maybe you can
compromise and have the best of both worlds. Buy
one color ink-jet printer for those few times you
want to print in color and get laser models for
the rest of your needs.
Until recently,
the least expensive black-and-white laser printer
cost more than $400, but Samsung just introduced
a seven-page-per-minute model (the ML-1210) with
a $199 price tag. It appears to be the
lowest-priced laser model on the market. You may
want to check it out.
|
| Q. Thanks for your advice in the September
2001 issue on converting fractions in Excel into
decimal values. But how about those of us who
need to do the reversethat is, convert
decimal values into fractions? Can Excel do that? |
A. Sure can, and heres how its
done: Highlight the decimal numbers you want to
convert to fractions and then right-click,
selecting Format Cells and the Number
tag. Then scroll down the Category
list and click on Fraction,
producing this screen: |
Notice your choices: Excel will convert
decimals into many different kinds of fractions:
from up to one digit in the numerator and
denominator (such as 14) to those with hundredths as
denominators (such as 30100). Heres a table with some sample
conversions: |
Q. I know Im suppose to defrag my
hard drive every now and then so it runs more
efficiently. But every time I start a defrag, the
function runs for a few minutes, stops and then
starts all over again. I also get a message that
says, Drive contents changed. I even
once let it run overnight, and when I returned to
the office the next morning, it was still trying
to finish the job. What can I do?
|
A. Let me first congratulate you for even
trying to defrag your hard drive. Defragging is
like flossing after every meal: We know we should
for good dental hygiene, but most people
cant be bothered. And thats too bad
because failing to defrag a computer regularly
makes the computer dragrunning slower and
slower as time goes on.
Before I tell you
how to overcome your problem, which isnt
unique, Id like to explain what defragging
is and why its important to do on a regular
basis.
Defrag is short
for defragmentation. Every file on a hard disk
(or any storage device) is made up of tiny bits
of data, and each time a file is saved, many of
the bits get scattered to different parts of the
disk, settling in the nearest vacant space. Thus,
bits of data for a single file may be widely
separated. Fortunately, the computer keeps track
of each bits location, and when you call up
a file, it gathers them all together.
But with each
saving, the component bits get scattered more
widely, and the computer has to work harder each
time to locate the various bits and then
reassemble them.
Thats where
defrag comes in. When a tool thats built
into Windows, called a Disk Defragmenter,
is evoked, it scans the hard drive, locates all
the scattered bits and repositions them so all
the bits of each file are situated as close to
each other as possible. Defragging is a
never-ending joblike flossing your teeth.
The more you use a computer, the more frequently
you need to defrag.
For most machines,
a weekly defrag is sufficient. While you can
launch the defrag tool manually, Windows comes
with scheduling tools that let you automate the
event; most people schedule it for after-office
hours.
Youll find
the defrag tools and two maintenance-scheduling
tools by clicking on Start, Programs,
Accessories, System Tools.
Now, to answer
your question about the application stalling and
restarting. I would guess that defrag stalls in
your computer because, in all likelihood, you
have some application intermittently running in
the background, and each time it stops, its data
get scattered. Imagine trying to line up a bunch
of hyperactive kids by height: Its like
trying to load frogs in a wheelbarrow. And each
time the position of the data changes, defrag
senses that and has to stop and start all over
again.
To keep the data
from scattering, you have to stop the program
from starting. But you dont want to
permanently stop it because it could be an
antivirus program or some other vital
application.
The easiest way to
temporarily stop it is to use whats called
a three-finger reboot or a hot reboot: You do
this by holding down the Ctrl and Alt keys
simultaneously and then pressing the Delete key.
But be carefuldo this only once. If you do
it twice, your computer will reboot.
What you want to
do by commanding the first step of the hot reboot
is to evoke a Close Program
screen that lists all the programs running in the
background. By highlighting each application and
then clicking on the End Taskone
after the otheryou can temporarily halt
those apps from running. Be careful not to press
the Shut Down key; that will
reboot the computer. Also, never close two
programs in the Close Program
list: Explorer and Systray.

|
| Q. Ive got a problem that sounds
simple, but I just cant find a solution.
From a complex spreadsheet that contains many
rows and columns and many formulas that affect
the cells in these rows and columns, my boss
wants me to print just one of the rows and one of
the columns on a single sheet of paper. She wants
to see where the information crosses.
I tried copying the single row and column to
another worksheet but lost the formula
relationships. And then I considered linking the
data, but thats cumbersome. Any ideas? |
A. There are several ways to accomplish
your goal, but it seems to me, as always, the
simplest is usually the best. Id suggest
you just hide the columns and rows you dont
want to show on the printed paper. And the
easiest way to hide it is to color the font white
so it wont print. To
do that, highlight the areas you want to hide,
right-click and then click on Format
Cells, bringing up this screen:
|
| Then
click on the Color menu and
select white. |
| Q. I have a couple of CDs that start
automatically when I slip them into the computer,
and I like that. But I also have one that
automatically begins an install process, and I
dont like that; its a real nuisance.
How can I stop that auto-install feature? |
A. You can turn off both the auto-start
and auto-install features. If you want to turn it
off only temporarilythat is, on a one-time
basishold down the Shift key while
inserting the CD until the CD activity stops. If you want to make the change
permanent, go to Start, Settings, Control
Panel, System. Click on the Device
Manager tab and press the (+) symbol
next to CD and right-click on the CD name that
appears. Then either click on Properties
or right-click again and select Properties.
Choose the Settings tab and
remove the check mark next to Auto insert
notification. The changes will take
effect after a reboot. 
|
| |
| Do you have a technology question for
this column? Send it to Senior Editor Stanley
Zarowin via e-mail at zarowin@mindspring.com or regular mail at the Journal of
Accountancy, Harborside Financial Center,
201 Plaza Three, Jersey City, NJ 07311-3881. We
regret that we cannot answer letters
individually. If a readers question is
deemed to have sufficiently broad interest, we
will answer it in a forthcoming Technology
Q&A column. The editors
|
|