Skip to main content

Posts

Create Bar Chart in Excel Easily by Example

Today, we will discuss How to Create Bar Chart in Excel Easily by Example . A chart is the graphical representation of data. Microsoft Excel provide an easy to use Chart Wizard for this purpose. The Microsoft Excel Chart Wizard guides you on each step to perform the specific tasks and get a brilliant Chart finally. Create Bar Chart in Excel Easily by Example Steps to Create Bar Chart in Excel Easily by Example NOTE: You can chose a chart Type as BAR chart which is on number two in chart type list. For this example, here pictures are provided for the default chart type, the first one, named COLUMN CHART.  as shown in the following picture.   Create Worksheet and enter data to Create Bar Chart in Excel Easily by Example. Select the columns data. If the two columns are adjacent, Select the both columns along with column headings with the help of mouse. If the two columns are not adjacent, select first column by mouse dragging. Now press and hold CTRL button from key

Students Test Score Grades Result Sheet in Excel

Today, we will discuss How to create an Students Test Score Grades Result Sheet in Excel using Formulas / Functions ( IF Function ) . The following formulas will be used in Students Test Score Grades Result Sheet: Q: Prepare the following Students Test Score Grades worksheet in MS Excel. Apply suitable formula and functions: Test Score >=90 A grade, 80-89 B grade, 70-79 C grade, 60-69 D grade, below 60 F grade, as shown in the following table: Roll No. Test Scores Grade 1 90 A 2 80 B 3 75 C 4 60 D 5 50 F Create a worksheet in MS Excel according to the requirements as shown above Enter sample data of Roll No. and Test Score Columns as shown in above table. Apply formula to calculate Grade on the basis of test scores obtained by the student. Grade Formula in Students Test Score Grades Result Sheet Grade Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F"))))

Microsoft Office Word Processing Practicals

Today we will discuss some important basic Microsoft Office Word Processing Practicals . These practicals are essential part of Learning Microsoft Word for basic documentation preparation process. How To Create a New File (Document) and Save It Start Microsoft Word according to the procedure shown in the following picture or by double clicking the Microsoft Word shortcut on desktop. Microsoft Word will open with a blank document. Type something in this Word document Then Click on Microsoft Office button and then Save option Or you can press keyboard shortcut CTRL+S Type file name and select location Click on Save. I have given the solutions according to some old versions of Microsoft Office 2000, 2003 etc. MS OFFICE 2000, 2003 Old is Gold  Open Microsoft Word Start -> Programs -> Microsoft Word To Create a New File File -> New or Press CTRL+N To Save a File: File -> Save or Save As -> Type file name -> Select file location -&g

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

Employee Pay sheet Formulas in Microsoft Excel

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

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 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

Download Top 7 Free Antivirus

Here is a list of  a comparative grading of World's Most Popular Free Antivirus Solutions . This list of results was published by PCMAG, after a series of tests in PCMAG's Labs. Here is a list of Top Most Popular and Competent Free Antivirus Software as shown and rated by Different Popular Online Software Collection Providers like, Softpedia, Snapfiles.com and Cnet.com along with PCMAG. So, Download Your Selected Antivirus from the Following List of  Top 7 Free Antivirus software of 2014 : 1. AVAST World’s most-trusted antivirus avast! now protects over 200 million PCs, Macs, and Androids globally – more than anyone else. Download avast!  free today! 2. AVG Get our essential award-winning free protection now AVG AntiVirus FREE Free Download 3. AVIRA   Avira Free Antivirus Effortless protection for virus-free devices  Download Avira Antivirus Free  4. BitDefender   Trust Bitdefender Security Technologies 500 million users already do Dow