Skip to main content

Popular posts from this blog

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 ...
2 comments
Read more

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. ...
1 comment
Read more

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...
Post a Comment
Read more