google search

Monday, May 27, 2019

Changing the Text color of cells in Excel


To change the text color

You can change the color of the text in cells and cell's background color. you can apply a solid color for the background color, or you can apply special effects, such as gradients, textures, and pictures.
·         
  • Select the cell
       Read more on how to select cells, rows, columns, and range
  • Left click the drop down arrow next to the Text Color command. A color palette will appear.
  • Select a color from the palette.












OR
·         Select More Colors. A dialog box will appear.
·         Select a color you desire  from the mixer dialog box



















Changing the Font Size of cells in Excel



To change the font size:
  • Select the cell or cells you want to format.
      Read more on how to select cells, rows, columns and range 
  • Left-click the drop-down arrow next to the Font Size box on the Home tab.
  • Select a font size from the list.

Applying Font Style formatting in Excel


To Change the font style:
  • Select the cells you want to format.
  • Left click the drop-down arrow next to the Font Style box on the Home tab.
  • Select a font style from the list.




















Formatting Cells as Underlined in Excel


To format text as underlined

·         Select the cell you want to format.

  • Click the drop down arrow next to the Underline command.

    • Select the Single Underline or Double Underline option.
























    See Also 


    Formatting cells in Italics font in Excel


    How to format text in italics
    • Select the cell by Left clicking a cell to select it, or drag your cursor over the text in the formula bar to select it.
    Read More on how to select cells, columns, rows, and ranges 
    • Click the I, Italics command as shown in the picture below




















    See Also 


    How to bold cells  


    Formatting you cells in Bold



    How to format text in bold
    • Select the cell by Left clicking a cell to select it, or drag your cursor over the text in the formula bar to select it.
           Read more on how to select cells, columns, rows and ranges 
    • Click the B, Bold or I, Italics command as shown in the picture below












    See Also

    How to bold cells  

    Formatting your Cells


    Formatting cells



    The information you type in Excel can also be formatted in different ways, you will learn how to use the bold, italic, and underline commands, you will also learn how to  modify the font style, size, and color, and also how to apply borders and fill colors to your data in Excel.

    To select the entire column,
    ·         Left-click the column heading,
    ·         And the entire column will appear as selected.

    To select specific cells,
    ·         Left-click a cell and
    ·         Drag your mouse to select the other cells,
    ·         then release the mouse button.




    Displaying Numbers in Currency

    Display numbers as currency

    In the Number group, you have some other options. For example, you can change the U.S. dollar sign to another currency format, switch numbers to percents, add commas, and change the decimal location.

    1. Select the cells that contain the numbers that you want to display with a currency symbol.
    Recommended for reading:

    Monday, May 13, 2019

    Tips for using your keyboard safely



    Other keys

    Some modern keyboards come with "hot keys" or buttons that give you quick, one-press access to programs, files, or commands. Other models have volume controls, scroll wheels, zoom wheels, and other gadgets. For details about these features, check the information that came with your keyboard or computer, or go to the manufacturer's website.

    Tips for using your keyboard safely

    Using your keyboard properly can help avoid soreness or injury to your wrists, hands, and arms, particularly if you use your computer for long periods of time. Here are some tips to help you avoid problems:

             Place your keyboard at elbow level. Your upper arms should be     relaxed at your sides.

             Center your keyboard in front of you. If your keyboard has a numeric keypad, you can use the spacebar as the centering point.

             Type with your hands and wrists floating above the keyboard, so that you can use your whole arm to reach for distant keys instead of stretching your fingers.

             Avoid resting your palms or wrists on any type of surface while typing. If your keyboard has a palm rest, use it only during breaks from typing.

             While typing, use a light touch and keep your wrists straight.

             When you're not typing, relax your arms and hands.



             Take short breaks from computer use every 15 to 20 minutes.

    Friday, May 10, 2019

    WORLD WIDE WEB (WWW)


    Definition and Meaning of Word Wide Web

    The World Wide Web (WWW) is a computer system that is referred to as the Web it is formatted in html and accessible via http. It differs from other computer systems in that it covers the whole world. This is why it is called the World Wide Web. Moreover, it uses the Internet to link together lots of interesting items of information globally. 


    As Internet is the electronic superhighway and an electronic world road system, the World Wide Web is the road sign system. Just as the road sign shows you where a particular road leads to, the World Wide Web makes sure that the information from one computer will be displayed on any other computer on the Internet in a form that is easy to read and understand. It also guides you round the Internet, just as road signs you to where you want to go.


    ORIGIN OF THE WORLD WIDE WEB (WWW)
    The history of the Web dates back to the late 1980s in Geneva, Switzerland, located in this city is the European laboratory for Particle Physics. The Web was first developed in this laboratory. It was originally intended for the use of scientists rather than the general public. The commercial use of the Web started in 1994 and has now spread to most parts of the world.


    However, there are currently less than 30 African countries that have been connected to the Internet. Without connection to the Internet, access to the Web is not possible. It is indeed predicted that every country in the world is linked to the Internet in the year 2010.



    BASIC FEATURES OF THE WORLD WIDE WEB (WWW)
    Internet Connection
    The Web has a number of features with which users should be familiar. First of all, before one can start using the web, there must be an internet connection.



    In addition to Internet connection, there must be a client software programme called Web Browser. A browser is a software tool that greatly simplifies the process of a user’s “visiting” different locations on the Internet. The Web browser performs two important functions. First, it displays the various of files found on the Web as individual pages on the computer screen. This display is in a format that is easy to read. The Web browser also makes it possible to follow the connections built into Web pages.


    Web Page
    A Web page is simply any document, which is available on the Web. The connections built into the Web pages are called hypertext links or hyperlinks.


    Web Site and Home Page
    A connection of Web pages that deal with a single subject or organization is called Web site. The main page of a Web site is called home page. A home page generally contains links to additional locations within the Web site as well as external sites. 


    Hypertext may be defined as a system of writing and displaying text in a way that enables several desired results to be achieved. Example of such results include:
            a.    Making it possible for the text to be linked in multiple ways;
            b.    Making the text available at several levels of detail;
            c.    Accommodating links to related documents.


    Hypertext Markup Language (HTML)
    This is sometimes abbreviated as HTML. It is a language that is used to write pages for the Web and create links for the display of documents on the Web. The language makes it possible for the text to include codes, which define, for example, layout and hypertext links.


    Protocol
    Protocol is very important when communicating over a network, especially the Internet. Protocol here is a system of rules or standards which users have to comply with. Computers and networks interact according to these standards. The standards determine the behavior, which each side expects from the other in the transfer of information. An example of an internet protocol address system represented by decimal notation is http://155.198.172.3/~duo/. This is the Internet address of a Nigerian international concert pianist.

    Notice the distinct difference between the E-mail address and the Internet address systems. Whereas the E-mail address always starts with the name of the addressee, while the internet address always starts with http (hypertext transfer protocol). The protocol (http) is the basis of World Wide Web technology. It is made up of a set of rules which, govern the software that transports HTML (HyperText Markup Language) document along the Internet.



    Recommended for Reading:
    Networking