Procedures in Using Computer System Configuration Tools
The subsequent sections below present the various procedures in using Computer System Configuration Tools:
- Accessing and using Microsoft System Configuration
- Click on Start Button
- In the Search Box, type Run
- In the Run window, type msconfig, and press Enter.
- Accessing and using Regedit:
- Click on Start Button
- In the search box, or Run window, type the following:
regedit and then press Enter
Using the Registry Editor
The Registry Editor (regedit.exe) is included in Windows to enable you to view and edit the contents of the Registry. When you open the Registry Editor, you will see a window divided into two panes. The left side shows a tree with folders (see Structure of the Registry above), and the right side shows the contents (values) of the currently selected folder (key).
- To expand a certain branch, click on the little plus sign [+] on the left of any folder, or just double-click on the folder.
- To display the contents of a key (folder), just click the desired key, and look at the values listed on the right side.
- You can add a new key or value by selecting New from the Edit menu.
- You can rename any value and almost any key with the same method used to rename files; right-click on an object and click rename, or click on it twice (slowly), or just press F2 on the keyboard
- Lastly, you can delete a key or value by clicking on it, and pressing Delete on the keyboard, or by right-clicking on it, and choosing Delete.
Caution: Using regedt32.exe or regedit.exe incorrectly might cause configuration problems that may require you to reinstall the operating system.
- Accessing and Using Direct X Diagnostic
You can test Microsoft DirectDraw and Direct3D on each monitor attached to your system. You can also test DirectSound on each wave output device, and DirectMusic on each music port
To run the DirectX Diagnostic Tool (DX Diagnostic Tools Window of Windows XP differs from Windows 7 but it does the same function):
- Click on Start Button, type Run on the search box.
- On the Run window, Type in dxdiag and click Ok or press Enter, as shown in Figure 9, Run Dialog Box.
Characteristics of a computer
- It is a machine
- It is electronic
- It is automatic
- It can manipulate data
- It has memory
- It has logic function. (more…)
Autosum automatically creates the formula that makes use of the sum function. When you use autosum button, Excel anticipates that you want to add values within the reference range you have specified.
Autosum is very easy to use, just follow these three steps:
- Select the cell where you want to hold the result of the equation. If you are adding a column or row then choose the last empty cell or the cell after to hold the formula result.
- From the standard toolbar, look for the autosum button and click it.
- Press Enter key. The result will be seen at the chosen cell. (more…)
Understanding Excel Formulas
One way to add calculations to an Excel workbook is to create your own formulas. Formulas are typically used to perform calculations such as addition, subtraction, multiplication, and division. More complex calculations are better left to Excel functions, which is a built-in set of formulas that provide financial, mathematical, and statistical calculations.
Formulas that you create typically include cell addresses that reference cells on which you want to perform a calculation. Formulas also consist of mathematical operators, such as + (addition) or * (multiplication). (more…)
Changing Text Attributes with Toolbar Buttons
1. Select the cell or range that contains the text whose look you want to change.
2. To change the font, click the Font drop-down list, and select a new font name. To change the font size, click the Font Size drop-down list and select the size you want to use. You can also type the point size into the Font Size box and then press Enter.
3. To add an attribute such as bold, italic, or underlining to the selected cells, click the appropriate button: Bold, Italic, or Underline, respectively.
You can also change the color of the font in a cell or cells. Select the cell or cells and click the Font Color drop-down arrow on the Formatting toolbar. Select a font color from the Color palette that appears. (more…)
Adjusting Column Width and Row Height with a Mouse
You can also adjust row heights, if you want, using the mouse. However, your row heights will adjust to any font size changes that you make to data held in a particular row. Row heights also adjust if you wrap text entries within them. You will probably find that you need to adjust column widths in your worksheets far more often than row heights. (more…)
Text is any combination of letters, numbers, and spaces. By default, text is automatically left-aligned in a cell, whereas numerical data is right-aligned.
Entering Numbers As Text To enter a number that you want treated as text (such as a ZIP code), precede the entry with a single quotation mark (‘), as in ‘46220. The single quotation mark is an alignment prefix that tells Excel to treat the following characters as text and left-align them in the cell. You do not have to do this to “text” numerical entries, but it ensures that they will not be mistakenly acted upon by formulas or functions. (more…)