Featured Post

Complete Parts and Function of Computer Keyboard

BELOW ARE THE MOST PARTS AND FUNCTIONS OF THE COMPUTER KEYBOARD THAT COMMONLY USED. A computer keyboard is used to enter commands of...

16 Basic Control Keys of Computer Keyboards

16 Basic Control Keys Of The Keyboard
The keyboard of the computer is use to enter commands of the computer using its operating and other application program, such as the Microsoft Office and programming language coding. There are different type of the keyboard, as of now we have touch screen keyboard for the windows 8 operating system. But commonly we are using the QWERTY designed keyboard that came from the design of the type writer.

Commonly, there are five major functions of the keyboard; they are function keys, alphanumeric character, special keys, cursor keys, and the numeric keypad. The Alphanumeric Character compose of the following keys; letters from A-Z, numbers from 1-9 and reset 0, symbols, punctuation keys, and the special keys situated left side, bottom, and right side of the alphanumeric character of your QWERTY keyboard.

Now, this post will introduce to you the one of the special keys of the alphanumeric character called CTRL key or the control keys of your keyboards. They are two CTRL keys found of your keyboard located in the bottom left and right. This is use to function another keys for a certain command of the computer, called common shortcuts of the Windows Operating Systems and the Microsoft Office application. They are listed below, if you want to perform an actual procedure, just open the Microsoft Word. Just click start button, point to all programs, find the Microsoft Office 2007 or 2010, then click Microsoft Word.

For your practice, just type any paragraph or type “The quick brown fox down over the lazy dog”. Then remember that you cannot perform the procedure if could not highlight the paragraph or a line of paragraph. In how to highlight the paragraph, just hold the CTRL key then press letter A (all), then proceed and follow the list of controls describe below:
  1. CTRL + Z= UNDO
  2. CTRL + X= CUT
  3. CTRL + C= COPY
  4. CTRL + V= PASTE
  5. CTRL + B= BOLD
  6. CTRL + N= NEW
  7. CTRL + A= ALL (HIGHLIGHT)
  8. CTRL + S= SAVE
  9. CTRL + F= FIND
  10. CTRL + G= GOTO
  11. CTRL + H= REPLACE
  12. CTRL + Y= REDO
  13. CTRL + U= UNDERLINE
  14. CTRL + I= ITALIC
  15. CTRL + O= OPEN
  16. CTRL + P= PRINT

To perform or use this all controls of the keyboard just hold the CTRL key and press the letters describe above. And observe what happen to your document template. “ End”  

Parts and Functions of Multitester or Voltage Ohm Meter

MultiTester_or_VOM

The VOM or Voltage Ohm meter or commonly called as Multitester is used by the technicians or enthusiasts both Electronic or computer technician. This equipment is used to measure both the voltage AC and DC voltages, Resistance, and current. Remember that you will deal with the high voltage in using this equipment. So therefore you need to learn more about how to use this and learn first the parts and functions including the safety precautions.



Parts of voltage ohmmeter

  1. Know what to be measure- remember that before you perform measurement of a voltage or a device you should acquaint yourself what type of current your dealing with. Is this high voltage or not, example: the wall outlet electricity or the convenience outlet or CO that has a standard wall outlet electricity of 220 VAC minimum.
  2. Know the polarity- if we should measure a line of voltages or current we must understand that a Direct Current (DC) have a two channel, the positive and negative. To avoid an incident, we must always avoid the technician error in considering the trial and errors.
  3. Do not hold the test rod- the test rod is the metal tip of the test probe, consider always the voltage and electronic component as high voltage. So that you will avoid the accident of electrical shock and damage of the units you repair.

What is AutoFill Tab and how to use it in Microsoft Office Excel Versions

WHAT IS AUTOFILL TAB AND HOW TO USE IT IN ALL VERSIONS OF MS-EXCEL
Autofill tab is a tool of all versions of the MS-Excel that located or built-in right side down of the worksheet cell of the entire worksheet area of the Microsoft Excel. This is use to auto execute or auto filling a calculation after a logical formula created in the intersection of columns and the rows. Using the white cross cursor of the mouse and pointing it to the autofill tab, it will change right away into a black cross hair or a thin cross cursor of the mouse. And by holding the left mouse button and drag it down until to the last rows of the column, it will sum all the logical functions of your calculated data. See the image shown above of this post.

Let’s say, if we will calculate a series of numbers using the worksheet, we should type the 1 on the first row of data in a columns and type 2 in the next row of data in a column. And highlight the two numbers using the shift combination hold shift key and press right arrow key then down arrow key or use the white cross hair of your mouse to highlight the two numbers.

Then point your mouse cursor to the autofill tab then drag down your mouse until to the last rows of columns of your data calculation. See the image shown above of this post.

In addition of this application using the autofill, you can directly execute or calculate an ID number of employee’s number in your worksheet. By typing the first ID number in the first rows of data and the second ID number of the preceding rows of data, example ID number is 56-00A-10 and 56-00A-20. It should understood that the computer will perform the logical function of the two numbers that have a distance of 10 or what we called by ten numbers count.

Use this autofill also if you wanted to fill of the month and day, including the exact year assign in its columns of data. And proceed to execute the autofill of your worksheet. And if you wanted to put a remark of your worksheet just do it by typing the logical function if that I was given in my previous post of the Microsoft Excel. And even if you perform logical function using the sum, average, count, minimum, maximum, grand total using the sum, vertical look and horizontal lookup and even slope and intercept. And even using the four mathematical operators that we use every day. Example, a standard notation that could be applied in logical function in our worksheet.

Just message me if you have questions and leave it in the comment bar below of this post. “End”

How to Apply Alignment of MS-Office Excel Worksheet Table

how to apply alignment of worksheet table
This post is dedicated to the very beginner of the Microsoft Excel using the two versions, the office 2003 and 2007. As a beginner it is not easy to recognize how to align the worksheet title and the worksheet label of MS-Excel worksheet table. Using the application menu or by using the right click of the mouse through the highlighted portion. And use the auto command format cells and then use the dialogue box using the alignment tab menu button.


Just look the image shown below of this post, if you observe the worksheet title position on the column A1 as we do always begin in typing in the beginning of the column header. And the worksheet label is not arrange well and the other words of it is hidden inside the columns, example the employee number.
   
Formatting CellsThen observe this second image, you will observe that the worksheet title and the label is align on the center of the worksheet table and the worksheet label is arrange very well inside the intersection of the columns and the rows.



In regards with this application of this worksheet, just do this procedure to enhance your ability in using the Microsoft Excel and form the worksheet table neatly.
  • Create your worksheet table
  1. Type the worksheet title in column A and row 1 or A1
  2. Highlight the worksheet accordingly base of the need of your Data, example 21 rows and 9 columns(21R X 9C), use the shift combination, hold the shift key and press the right arrow key until to the last column you need and press the down arrow until to the last rows you need of your data. Just look the name box of the MS-Excel and observe that it will displayed the exact number of rows and columns, example: 21R x 9C. Be sure that once you highlighting a worksheets of your data table begin on the column A and after of your worksheet title just below on it.
  3. Just right click on the highlighted portion
  4. Then click format cells
  5. Then dialogue box will appear, click the border tab menu button
  6. Just click the outline imaginary box
  7. Then click inside imaginary box
  8. Observe the preview of the border, it must have just like a cross inside and the outline form in both sides.
  9. Then click ok button below of the dialogue box.
  10. Now you have a worksheet table in your worksheet area, just below the worksheet title.
  11. Now you’re ready for the alignment or formatting the position of the title and the worksheet label. But just type or insert first the worksheet label in every first columns of your worksheet table.
  • Apply alignment of the worksheet title
  1. Notice always that in centering the worksheet title, all you need is to highlight only a single row of the title within the row. If ever if you have a multiple titles same of the post image above. Highlight accordingly from the beginning of the column A with the row until to the last columns you use of your data table.
  2. Once highlighted, use the home menu and click the merge and center button under of the alignment bar or ribbon. Now you will observe that the worksheet title will move to the center of your worksheet table. Just repeat the procedure to the other worksheet title.
  • Apply alignment of the worksheet label
  1. Notice always that in centering the worksheet label with the columns respectively, all you need is to highlight all the worksheet labels from the beginning of the column until to the last column of your worksheet table.
  2. Then right click on the highlighted portion
  3. And click the format cells
  4. A dialogue box will appear on your screen, just click the alignment tab menu button
  5. Now you will see the application of the text alignment, text control, and orientation. But all need is to focus only of the text alignment and text control. And remember that you,re dealing with multiple data with the columns and the row.
  6. Click the drop down bar of the horizontal and click the center.
  7. Click the drop down bar of the vertical and click the center.
  8. Now, in the text control, just check box on the wrap text. Do not check box the merge cells because there are multiple data or text with the columns and rows. It will erase the other labels or the preceding labels after you click the ok button of the dialogue box.
  9. Now you will notice that the labels will arrange accordingly to the intersection of the columns and the rows.

Now, that’s all just leave your question if you have clarification regarding with our MS-Excel worksheet table. Just type your message in the comment bar below. “End”  

Microsoft Office Publisher 2007- ‘Create Business Card’

BusinessCard
Create Calling Card using MS-Publisher 2007
I posted the other day about the Microsoft Publisher 2007 parts and function. So that, you will know the familiarized the environment of the User interface. Now, let’s go on how to create a project using this application of the Microsoft office automation. Let’s create the most common use for our works and easy to create. Unlike using the Corel draw is needed the most skills how to manipulate the program. And this only need is the basic of MS-word application and the MS-paint.

One of the most common uses is a calling card or business card. We need this always even if we have no business because everyone of us have a cellular phone, most likely if we have position on the company that could easily given to our associates and to our clients. So, before you go on you must sure that the Microsoft Office Publisher installed in your computer as one of the customized program installed in your Microsoft Office 2007 or 2010 package. If completely installed follow this steps:




  • Open up the Microsoft Publisher 2007 or 2010
  • Common Parts of Microsoft Office Publisher 2007

    MicrosoftOfficeProgram
    One of the Microsoft Office program stored in compact disk is the Microsoft Office Publisher. This program is enhancing precisely to fit our need in design and template design application using the toolbars we are commonly used in Microsoft Word application. It’s easy to use compare to the old version 97 and 2003, it’s a drag/ drop because of the ready to fit and use buttons inside the command application bar, such as the task panel. This task panel serves as the docking bar of the most frequently use command application such as the format publication.

    For me this Microsoft Publisher 2007 and most particularly to the 2010 and 2013 design have a more built-in ready to use design pack in the Design Gallery Object. And all can be formatted into 3d effects format with enhance color palette such as the Pantone ® colors that can be access in the color palette normally we use of the MS-Word. And enhance and more font styles already in the formatting bar.


    This application is designed to meet our need, particularly if we don’t have Corel draw or we don’t know how to use this graphics application program. But thanks to the Microsoft we can make now our business card without paying to others. Because it is now in your computer that it is very easy to use program. All you need is a basic computer operation or an experience of how to use the MS-Word, Excel, and PowerPoint or just study this program and you will notice that your now expert to use this.

    MAY YOU LIKE THIS POST!