About Us / Contact Us

About Us

Mahmood Alam - Founder of www.computergap.com

( www.computergap.com / www.forfreeeducation.blogspot.com )

I am Mahmood Alam, the founder of this blog : www.computergap.com / www.forfreeeducation.blogspot.com. I am an Instructor by profession and a part time blogger. I am not able to give much time to blogging because of my job. This blog is another place to share knowledge. Two of my students also help keep this blog updated. Thanks nice guys! Keep it up!

www.computergap.com / www.forfreeeducation.blogspot.com is a free source of perfect computer notes to decrease the computer gap and spread computer science knowledge and information technology skills. We work to spread computer literacy - free computer science education for all.

Contact Us

( www.computergap.com / www.forfreeeducation.blogspot.com )

You may contact us at softalogy@gmail.com for any queries, suggestions, complaints etc. Thanks for coming here on www.computergap.com / www.forfreeeducation.blogspot.com.

Comments

Electricity Bill Calculator Formulas in Excel

Today, we will discuss How to create an Electricity Bill Calculator Worksheet by using Electricity Bill Calculator Formulas in Excel . The following formulas will be used in Electricity Bill Calculator Worksheet: Q: Prepare a worksheet according to the following instructions: Create a worksheet in MS Excel according to the requirements Enter sample data of Electricity units consumed by customers in a city Apply formula to calculate Units Consumed Apply formula to calculate Electricity Charges Apply formula to calculate Surcharge Apply formula to calculate Bill Payable Note: Every formula will start from = Units Consumed Formula=D5-C5 Electricity Charges Formula=IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10)) SURCHARGE FORMULA = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0)) BILL PAYABLE FORMULA = SUM(F5:G5) Download Excel Electricity Bill Calculation Worksheet Free Image for Electricity Bill Calculator Formulas ...

What are Dual Devices or Both Input/ Output Devices

The devices that can be used to perform both functions -input and output- are called Dual Devices. These devices are also called Dual Purpose Devices or Both Input/Output Devices. With the help of a dual purpose device, we can enter data into computer as well as we can output data from the computer to outside world. For example, Dual devices include: Touch Screen Monitor, Modem, Network Interface Card, Sound card, Hard disk drive, Floppy disk Drive, Magnetic Tape Drive CD-Writer and DVD-Writer etc. These are also called Input/output devices, because they perform both functions. Touch Screen Monitor Dual Devices or Both Input / Output Devices - Touch screens Touch Screen Monitor is an input/output device. It uses a special touch sensitive screen. The User can enter data by touching icons or menus on the screen. As soon as the user selects a command from menu, output is displayed on screen. Commonly touch screen monitors use sensors to detect touch of finger. ...

Advantages and Disadvantages of Tree Topology

Tree Topology Actually, a Tree topology is the combination of two topologies: bus topology and star topology . A tree topology combines the characteristics of bus and star topologies. It consists of groups of computer connected as star topology. These groups are then connected to a central communication medium (bus cable). Advantages and Disadvantages of Tree Network Topology Advantages of Tree Network Topology 1. Many software and hardware vendors support tree topology . 2. It provides point-to-point wiring for individual groups. Disadvantages of Tree Network Topology 1. If the main backbone line breaks, the entire tree network goes down . 2. A tree network is more difficult to configure and maintain. 3. If any hub fails, related segment will be removed from the network. Read More on Networking and Networks 1 Explain Advantages Of Networks 2 Types Of Computer Networks...

Perfect Computer Notes

Search This Blog