Yearly Archives: 2014

How to Protect Excel Workbook with Password

Today, we will discuss a basic MS Excel Tutorial with a lot of pictures on How to Create a New Work book, Save workbook and Apply Password Protection on workbook in MS Excel. Here is a list of topics to discuss: Create a new Excel Work Book Save a Work book Password Protect a work… Read More »

Explain Advantages and Disadvantages of Fiber Optic Cable

What is a Fiber Optic Cable? A Fiber Optic cable comes with the technology that uses glass threads called fibers to transmit data as pulses of light. A fiber optic cable consists of a bundle of glass threads, each of which is capable of transmitting messages modulated onto light waves.A Fiber Optic Cable transmits data… Read More »

Explain Different Uses of Communication Technologies

Following are the main uses of Communication Technologies: 1. Video Conferencing Video Conferenccing combines the computer communication capabilities with video technologies to conduct an online meeting between two or more distant participants. The participants of a Video Conferencing are normally at different geographical locations within a building like a university campus or within a city… Read More »

Uses of Left Right Mid Text Functions in Excel

Why To Use Left Function in Microsoft Excel? The Left function is used to get first N characters from the given text string or the text contained in a cell. Syntax of LEFT Function in Excel LEFT(Text, Number_of_characters) For example, the function LEFT(“Normal”,3) will return Nor. Syntax of LEFT function with Cell Reference LEFT(CellReference, Number_of_characters)… Read More »

Learn Practical Use of MAX Function and MIN Function in Excel Worksheets

What is MAX Function? Learn Practical Use of MAX Function and MIN Function in Excel Worksheets The MAX function is used to get the maximum number from different given numbers in Excel Worksheet. Syntax of MAX Function in Excel MAX(number1,number2,number3,…numberN)For example the function MAX(5,100,35) will return 100, since 100 is largest number of all 5,… Read More »

Explain Different Uses of Excel in Business and Commerce

Microsoft Excel is very useful in Business and Commerce. Following is a list of the uses of Microsoft Excel in Business and Commerce: 1. Creating Computerized Worksheets Microsoft Excel is a computer software with electronic worksheets. You can easily input, edit, format your business data in computerized worksheets provided by MS Excel. You can manipulate… Read More »