Super Easy Short Computer Notes To Improve Computer Literacy and Your IT Skills

Sponsored Links

Sunday, July 6, 2014

Create Bar Chart in Excel Easily by Example

Leave a Comment
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.

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.


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 Bar Chart in Excel Easily by Example Step 1

 

  1. Create Worksheet and enter data to Create Bar Chart in Excel Easily by Example.
  2. 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 keyboard and select the other column by mouse.
  3. Start the Chart Wizard by clicking on Chart Wizard Tool.
  4. Select the type of chart as BAR chart and select the subtype also. Click Next button.
  5. There is nothing to do in this step as you have already selected data for chart in step 2. You can change data here if necessary. Click NEXT
  6. In this step enter the name of the chart and titles for the X- and Y-axes. you can also set some other options for the axes, grid lines, legend, and data labels etc. Click NEXT.
  7. In this final step select the location to insert chart. Click As new sheet if you wish to insert chart in a new blank sheet. Select As object in if the chart should be included in the existing sheet.

Create Bar Chart in Excel Easily by Example Step 2

Create Bar Chart in Excel Easily by Example Step 2

Create Bar Chart in Excel Easily by Example Step 3 

Create Bar Chart in Excel Easily by Example Step 3

 Create Bar Chart in Excel Easily by Example Step 4 

 
Create Bar Chart in Excel Easily by Example Step 4

 Final Image for Create Bar Chart in Excel Easily by Example 

Create Bar Chart in Excel Easily by Example Step by Step

 A BAR CHART will look like this

Picture of a Bar Chart in Excel
A Bar Chart in Excel

 This Excel Tutorial is based on Microsoft Office 2000 - 2003.

 Create Bar Chart in Excel Easily By Example Office 2007

 In Microsoft Excel 2007,
  1.  Type and select the data.
  2. Click on INSERT tab.
  3. In chart group, click on the required chart type. suppose you click on Bar type then a list of subtype options is displayed, select one of it.
  4. The selected chart will be inserted. 
  5. You can edit this chart for any modifications.

Download original Worksheet to create Bar Chart in Excel Easily By Example Office 2007


Create Bar Chart in Excel Easily By Example Office 2007
Read More...

Students Test Score Grades Result Sheet in Excel

Leave a Comment
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
  1. Create a worksheet in MS Excel according to the requirements as shown above
  2. Enter sample data of Roll No. and Test Score Columns as shown in above table.
  3. 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"))))

Image for Students Test Score Grades Result Sheet in Excel

Students Test Score Grades Result Sheet in Excel


Solution:
  1. Create a new workbook in MS Excel and save as with the name Students Test Score Grades Result Sheet in Excel
  2. Enter sample data for one to five Roll Numbers of students as shown in above table.
  3. Enter formula for Grade in the cell C3 Formula=IF(B3>=90,"A",IF(B3>=80,"B",IF(B3>=70,"C",IF(B3>=60,"D","F"))))and press Enter.
So, the worksheet with Electricity Bill Calculator Formulas Worksheet in Excel has been prepared successfully.

Download the Original Workbook File Prepared For Students Test Score Grades Result Sheet in Excel

Click to Download Excel Workbook For Students Test Score Grades Result Sheet Students Test Score Grades Result Sheet with Formulas in Excel is normally required to be prepared by the students of a Basic Microsoft Office Training Course. There are very simple formulas used to calculate Grade using the IF logical function. Although, an established institute may use a customized software for preparing Result Sheets, the students of Microsoft Excel will learn the use of different formulas and built-in functions to prepare Students Test Score Grades Result Sheet Worksheet with Formulas. Microsoft Excel can be very helpful to prepare such worksheets.  
Read More...

Saturday, July 5, 2014

Microsoft Office Word Processing Practicals

Leave a Comment
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. I have given the solutions according to some old versions of Microsoft Office 2000, 2003 etc. Soon, I will provide the practical procedures to perform these tasks in newer versions of Microsoft Office starting from MS Office 2005, 2007 and above.

MS OFFICE 2000, 2003 Old is Gold 


Microsoft Office Word Processing Practicals

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 -> click on Save

To Save a File with Password

File -> Save As  -> Click on Tools -> General Options -> Type password in Password to open box.
-> Ok -> Retype password / confirm password -> ok -> save

To Save Document in a Folder on Desktop


File -> Save As -> Select Desktop -> Click on New Folder button on dialogue box ->
Type folder name -> Type filename -> Save

Some More Useful Features for Microsoft Office Word Processing Practicals

How to set Paragraph Line Spacing


Type Paragraph. -> Select paragraph
-> Press
CTRL+1   For single line spacing
CTRL+2     For double line spacing
CTRL+5   For 1.5 line spacing

Text Effects


Select text -> Format menu -> Text Effects Tab -> select a text effect -> ok

Change Case


Select text -> Format -> change case -> select option -> ok (short cut CTRL+F3)

Borders and Shading


Select paragraph -> Format menu -> Borders and shading -> borders tab
-> Select a border setting, style, color and width -> ok

Shading


Select paragraph -> Format menu -> Borders and shading -> shading tab
-> Select a color from fill section -> ok

Microsoft Office Word Processing Practicals: Applying Graphical Page Borders

Page Borders


Format menu -> Borders and shading -> Page Border tab
-> Select a border from Art list box -> set other options -> ok

DROP CAPS

Image for Drop Caps Microsoft Office Word Processing Practicals
Set Drop Cap Options in Microsoft Office Word Processing Practicals
Place the cursor in paragraph -> Format menu -> Drop Caps -> select different options -> ok

Header and Footer

Picture for Header and Footer 
Header Footer Options in Microsoft Office Word Processing Practicals

View Menu -> Header and Footer -> Type text in header or use Insert Auto text option to
enter different options like Page X of Y    ---  Page 1 of 10 --- etc
-> click on Switch between header and footer button -> type text in footer or insert page number
etc. -> Close

Insert Page Number


Insert Menu -> Page Number -> set different options -> ok

Microsoft Office Word Processing Practicals: Inserting Word Art and Clip Arts

Word Art


Insert menu -> Picture -> Word Art -> set different options -> ok

Clip Arts

Microsoft Office Word Processing Practicals: Inserting Clip Arts

Insert Menu -> Picture -> Clip Arts -> select category and picture

TABLES

Inserting Tables in a Document: Microsoft Office Word Processing Practicals

Table menu -> Insert -> table -> select number of rows and columns
-> ok

TYPE Text E = mc2(Superscript and Subscript by Shortcut Key)


type the text E = mc2   -> select 2 -> press[ CTRL + Shift + = ]for super script text
similarly Press CTRL + = for subsript text

Bullets and Numbering


Select text -> Format menu -> bullets and numbering -> select bulleted or numbering tab ->
select bullets and number style

COLUMNS

Using Columns in Document: Microsoft Office Word Processing Practicals

Format menu -> columns -> select number of columns -> or select preset options
 -> ok

Soon, I will provide the same procedures to perform Microsoft Office Word Processing Practicals
in latest versions of MS Office.

Download Worksheet and Procedure to Create an Employee Pay sheet Worksheet in Microsoft Excel

 
Read More...

Thursday, July 3, 2014

Electricity Bill Calculator Formulas in Excel

2 comments
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:
  1. Create a worksheet in MS Excel according to the requirements
  2. Enter sample data of Electricity units consumed by customers in a city
  3. Apply formula to calculate Units Consumed
  4. Apply formula to calculate Electricity Charges
  5. Apply formula to calculate Surcharge
  6. Apply formula to calculate Bill Payable
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)

Image for Electricity Bill Calculator Formulas in Excel Software



Solution:
  1. Create a new workbook in MS Excel and save as with the name Electricity Bill Calculator Formulas in Excel
  2. Enter sample data for at least three customers
  3. Enter formula for Units Consumed= D5 - C5 in cell with cell reference E5.
  4. Enter formula for Electricity Charges =IF(E5>200, E5*15,IF(E5>100, 1000+(E5-100)*12, E5*10)) in cell with cell reference F5.
  5. Enter formula for Surcharge = IF(F5>5000, F5*5%,IF(F5>1000, F5*3%, 0)) in cell with cell reference G5.
  6. Enter formula for Bill Payable =SUM(F5:G5) in cell with cell reference H5.
So, the worksheet with Electricity Bill Calculator Formulas in Excel Worksheet has been prepared successfully.

Download the Original Workbook File Prepared For Electricity Bill Calculator Formulas in Excel

Click to Download Excel Workbook For Electricity Bill Calculator Formulas in Excel Worksheet
Electricity Bill Calculator Worksheet with Formulas in Excel is normally required to be prepared by the students of a Basic Microsoft Office Training. There are very simple formulas used to calculate monthly electricity bill of the customers living in a town. Although, the electric supply company may use a customized software for preparing electricity bills, the students of Microsoft Excel will learn the use of different formulas and built-in functions to prepare Electricity Bill Calculator Worksheet with Formulas. Microsoft Excel can be very helpful to prepare such worksheets.  
Read More...

Wednesday, July 2, 2014

Employee Pay sheet Formulas in Microsoft Excel

1 comment
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:
  1. Create a worksheet in MS Excel according to the requirements
  2. Enter sample data of employees in a college
  3. Apply formula to calculate Medical Allowance @ 40 % of Basic Pay
  4. Apply formula to calculate Conveyance Allowance @ 30 % of Basic Pay
  5. Apply formula to calculate House Rent @ 50 % of Basic Pay
  6. Add a column of Income Tax @ 7 % of Basic Pay
  7. Apply formula to calculate Net Pay = Medical Allowance + Conveyance Allowance + House Rent - Income Tax

Image for Employee Pay sheet Formulas in Microsoft Excel Software

Employee pay sheet Formulas in MS Excel

 Solution:How to Create Employee Pay Sheet in Excel With Formulas

  1. Create a new workbook in MS Excel and save as with the name Employee Pay sheet Formulas.
  2. Enter sample data for at least three employees.
  3. Enter formula for Medical Allowance = D5 * 40% in cell with cell reference E5.
  4. Enter formula for Conveyance Allowance = D5 * 30% in cell with cell reference F5.
  5. Enter formula for House Rent = D5 * 50% in cell with cell reference G5.
  6. Enter formula for Income Tax = D5 * 5% in cell with cell reference H5.
  7. Enter formula for Net Pay = D5 + E5 + F5 + G5 - H5 in cell with cell reference I5.
So, the worksheet with Employee Pay sheet Formulas has been prepared successfully.

Download the Original Worksheet Prepared For Employee Pay Sheet Formulas

Click to Download Excel Workbook For Employee Pay sheet Formulas Employee Pay sheet is normally required and maintained in every small business organization. There are very simple formulas are used to calculate monthly pay of the employees working in a small business. There is no need to develop a software for this purpose in a small book shop. Because, Microsoft Excel can be very useful to prepare such employee pay sheet with formulas.

Employee Pay sheet Formulas in Microsoft Excel

Here is the
Picture of Complete MS Excel Worksheet on

Employee Pay sheet Formulas in Microsoft Excel

Employees Pay Sheet Formulas Complete MS Excel Worksheet

 

Read More...

Recent Posts

Sponsored Links
.