Perfect Computer Notes

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 in Excel Softw

Today, we will discuss How to create an Employee Worksheet by using Employee Pay sheet formulas in Microsoft Excel . The following formulas will be used in Employee Pay sheet: Q: Prepare a worksheet according to the following instructions: Create a worksheet in MS Excel according to the requirements Enter sample data of employees in a college Apply formula to calculate Medical Allowance @ 40 % of Basic Pay Apply formula to calculate Conveyance Allowance @ 30 % of Basic Pay Apply formula to calculate House Rent @ 50 % of Basic Pay Add a column of Income Tax @ 7 % of Basic Pay Apply formula to calculate Net Pay = Medical Allowance + Conveyance Allowance + House Rent - Income Tax Image for Employee Pay sheet Formulas in Microsoft Excel Software  Solution:How to Create Employee Pay Sheet in Excel With Formulas Create a new workbook in MS Excel and save as with the name Employee Pay sheet Formulas. Enter sample data for at least three employees. Enter formula for M

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 book How to Protect Microsoft Excel File With Password How to Create a New Microsoft Excel Workbook? Start Microsoft Excel . It will open with a new workbook already created. OR when Excel is open, click on Office button and click on New. OR Press Ctrl + N from keyboard How to Save a MS EXCEL Workbook? Click on Office button and click on Save As option OR press CTRL + S Save As dialogue box will open Select the drive and folder location to save file Type work book name Click on Save button to save the workbook  How to Apply Password Protection on Excel Workbook Repeat the above mentioned steps from 1 to 5 as in SAVE WORKBOOK method. Click on Tools button which