Computer Info – (06/23/1999)

Locking Row and Column Titles in Excel

    To lock the row and column titles on an Excel spreadsheet -- place your cursor in a cell to the RIGHT of the column that you want locked and to the cell UNDER the row that you want locked. Then from the menu, choose WINDOW - then SPLIT.

Quick Sum or Average in Excel

    To quickly see the sum of a number of cells – click in the first cell and drag your mouse over the rest of the cells that you would like added. At the bottom of the screen on the Status Bar, you will see the sum of the cells. If you wish to see the maximum, minimum or average of these cells, then right click on the results on the Status Bar and make your choice. You can even have it tell you the number of cells that you had chosen.
    If you cannot see the Status Bar, then from the VIEW menu, click on Status Bar to display it.

Access – Creating a Form

    Last time we talked about creating a table. Now we will create a form to view our information a record at a time.

Create a new form.
    To create a new form, click on NEW. In the next window, click on DESIGN VIEW. Then choose the table that you want your information to come from. Then click on OK.
    What you get next, is a small gray area with a grid of black dots on it. This is the start of your form. If you wish to see what your new form looks like, from the top menu, choose VIEW – then FORM VIEW. You will then see your form – you can watch each of your changes as you make them. To get back to the design screen, from the top menu, choose VIEW – then DESIGN VIEW.
    Right click on the bar entitled DETAIL – and choose PROPERTIES. This opens a window that allow you to set the background color of your form. Click on the FORMAT tab and look for BACK COLOR. When you click in this field, you will see a button to the right that has three dots on it. Click on the button and choose the color you want – then click on OK.
    Now, lets add our fields to the form. From the top menu, choose VIEW – FIELD LIST. This places a small window near the top that shows all of the fields from your table. Click on a field name that you wish placed on your form and drag it to the area on the form where you wish it. Do this for all of the fields that you want on the form.
    Notice that when you add these fields, you see the name of the field twice – once as a label and once as the area where you enter the data. Let’s remove the label to all of these. Left click on the first label – then as you hold the SHIFT key down, left click on the rest of the labels. Then from the keyboard, press the DELETE key. All of the labels should disappear.
    Click on the first field – and you will see the handles where you can adjust the size of the box. Adjust this box to the height that you wish all of your boxes to be. Then while holding down the SHIFT key, left click on the rest of the fields. Now using your right mouse button, right click on one of the fields – from the menu, choose SIZE – TO TALLEST. This will make all of the boxes the same height. While they are all still highlighted, set the font, font size and justification from the menu.
    To add a title to this form (or add any additional text), from the top menu, choose VIEW – TOOLBOX. This opens up a small window of tools. Click on the label tool (Aa) and notice that your cursor changes to a capital A with a plus sign. By holding the left mouse button down, you can draw a box where you wish to place your text. Type your text in and then make any adjustments to it for font style, font size, color, etc.
    If you wish to add a picture to your form, click on the IMAGE tool. Choose a picture from your hard drive.
    When you are through designing your form, click on the X to close the window. You will be ask if you wish to save your changes. Choose YES and then give your form a name.

How Do I Clean My Scanner Glass (and other questions)

http://www.scantips.com/faq.html
This is a very good web page that deals with cleaning the glass on your scanner and many, many other FAQ’s (frequently asked questions) that all pertain to the scanner.

IBM Aptiva – Booting when the Telephone Rings

    Last week we had a question about how to stop the IBM Aptiva computer from booting up (turning on) everytime the telephone would ring. We had never heard of this – and were skeptical that it was even possible. So we went to the internet to look it up.

We also found the following -----
    QUESTION: Can you explain what the Aptiva Wake up on Ring is used for?
    ANSWER: Wake Up on Ring is a Rapid Resume feature. When you enable it, the computer will turn on when the phone rings (assuming you have the telephone line connected to the computer). If you have fax or fax/voice software open, the computer can receive faxes or messages after it turns on. If the computer is off at that time, it will turn on automatically. The Aptiva systems will answer the telephone from each of the following states:

1.Powered on
2.Standby
3.Suspend (Rapid Resume enabled, power off)
4.Powered off (Rapid Resume disabled)

    For the first three, the telephone answering software (ex: Faxworks, Aptiva Communication Center) must be running (when the system goes into that state) in order for the telephone to be answered. For the powered off state (RR disabled), the system will turn on if wake-up-on-ring is enabled; however, to answer the phone, the Operating System's StartUp Group needs to be setup to run the software (FaxWorks, Aptiva Communications Center) After the phone has been answered and the FAX or message received, the system will return to its previous state: If standby is enabled, the system enters standby after the time period set by the user (15-90 minutes). If auto-power off is enabled, the system will power down after the time period set by the user (15-90 minutes). If Rapid Resume is enabled when the system powers down, then the state will be saved and the
system will go back to the suspend mode.
    We also found that you can put your computer into hiberation. The hibernate feature turns off your monitor and hard disk, saves everything in memory on disk, and turns off your computer. When you restart your computer, your desktop is restored exactly as you left it. It takes longer to bring your computer out of hibernation than out of standby.
    Since it did not state where to find the control that turns this Wake Up On Ring on or off, this is my guess. From MY COMPUTER – choose CONTROL PANEL – then POWER MANAGEMENT.

Internet Phone Calls

    Internet telephone calls are done through a third-party Internet Telephony Service Provider (ITSP). Instead of dialing someone directly on the regular telephone, you connect to an ITSP through your normal Internet connection. The ITSP acts as a gateway for your call. All that is required is a good Internet connection, microphone and an additional account with an ITSP (like Delta Three). If usage conditions are not ideal, your calls may feature a lot of line noise and interruptions; therefore, Internet telephony is not at the stage where it will replace your long distance carrier anytime soon. The quality is still patchy at best. The savings of up to 70 percent offered by Web telephony companies may well be lost, due to the amount of time required to place calls during times of even moderate traffic. For example, it is possible to get regular phone rates as low as the ten cent rate offered by Delta Three.

Printing Handouts of your PowerPoint Presentation

    To print a handout for your PowerPoint presentation, begin by choosing PRINT from the FILE menu (DON’T CLICK ON THE PRINT ICON ON THE TOOLBAR – this doesn’t give you the choices). Choose Handouts from the PRINT WHAT drop-down list

Storage Requirements
(in kilobytes)

    The following chart shows you the storage requirements for black-and-white images, grayscale images, and color images in different sizes and resolutions. All sizes are in kilobytes (KB); 1,000 kilobytes is equal to 1 megabyte (MB). Example: 1,028KB = 1.02MB; 65,742KB = 65 MB; 131,484KB = 131 MB; 1,577,813KB = 1.5GB (gigabytes).
 
 
75 dpi
150 dpi
300 dpi
600 dpi
1200 dpi
2400 dpi
Single-bit Black-and-White
8.5" x 11"
8.5" x 5.5"
5" x 7"
4" x 5"
3" x 5"
-
-
-
65
33
25
14
11
-
-
-
257
130
97
55
42
-
-
-
1,028
514
385
220
165
-
-
-
4,109
2,055
1,540
880
660
-
-
-
16,435
8,218
6,153
3,516
2,637
-
-
-
65,742
32,872
24,010
14,063
10,547
8-bit Grayscale

8.5" x 11"
8.5" x 5.5"
5" x 7"
4" x 5"
3" x 5"

-
-
514
257
193
110
83
-
-
2,055
1,028
770
440
330
-
-
8,218
4,109
3,077
1,758
1,319
-
-
32,872
16,436
12,305
7,032
5,274
-
-
131,484
65,743
49,219
28,125
21,095
-
-
825,938
262,969
196,875
112,500
84,375
24-bit Color

8.5" x 11"
8.5" x 5.5"
5" x 7"
4" x 5"
3" x 5"

-
-
1,541
771
577
330
248
-
-
6,164
3,082
2,308
1,319
989
-
-
24,654
12,327
9,229
5,274
3,955
-
-
98,614
49,307
36,915
21,094
15,820
-
-
394,453
197,227
147,657
84,375
63,282
-
-
1,577,813
788,907
590,625
337,500
253,125
36-bit Color

8.5" x 11"
8.5" x 5.5"
5" x 7"
4" x 5"
3" x 5"

-
-
2,311
1,156
865
495
371
-
-
9,245
4,623
3,461
1,978
1,484
-
-
36,980
18,490
13,843
7,910
5,933
-
-
147,920
73,960
55,371
31,641
23,731
-
-
591,680
295,840
221,485
126,563
94,922
-
-
2,366,719
1,183,360
885,938
506,250
379,688