# PSC HELPER

Public Service Commission Preparation & Blogging

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

Practical Guides

Practice Sets

Tips & Tricks

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

MCQ Sets

## Interviews Preparations

### Tips & Tricks

Based on Experience

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Modal Sets

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

Tutorials

## Blogging & Wordpress Tutorials, Courses

Tips

Tips

New Strategies

New Strategies

Make Money

Make money

Guide

Guide

For Beginners

For Beginners

Tutorials

Tutorials

How to start?

How to start?

Intermediate

### Wordpress

Intermediate

Q.No.1: Prepare the following bill and calculate the bill amount for the customers. Also create a suitable chart.

 Cust. No. Name Current Meter Reading Previous Meter Reading Consumed Unit Bill Amount A1001 RajKumar Sharma 1250 1130 A1002 Hari Shankar 1320 1305 A1003 Anita K.C. 768 599 A1003 Sarita Thapa 1380 1125
Condition: Minimum Charge upto 20 units is Rs.80, the charge for 21 to 250 units is Rs.7.30 per unit and the charge for more than 250 units is Rs.11.50 per unit.

 SN EMP Code Sale AMT Commission Earning Tax Net Earning 1 1001 5000 2 1002 3800 3 1003 4000
a. Enter above data in sheet 1. (2)
b. Calculate Commission as 7% of Sales AMT. (1)
c. Calculate Earning as sum of Sales AMT and Commission. (1)
d. Calculate Tax as 13% of Earning for all Sales AMT equal or more than 4000. (2)
e. Calculate Net Earning as the difference of Earning and Tax. (1)
f. Create a column chart showing Earning and Net Earning for each EMP Code. (3)

Q.No.3. Create a line chart from following data. (10)
 Product January February March April May June Platinum 7000 Gold 2002 Silver 3003
Fill up the blanks cells with following informations.
a. The quantity of Platinum and Silver was increased by 20% in February and March.
b. The quantity of Platinum is decreased by 5% in April and 4% increament in May and June.
c. The quantity of Gold was steadily increasing by 3% in every months.
d. The quantity of Silver was decreased by 2% in April, May and June.

Q.No.4. Calculate the Increment using by excel.
A Trading company distributes incentive salary to the staff 25000/- because of company boomed up.
 SN Designation Before Increment 1 CEO 198000/- 2 Manager 150000/- 3 ......... ........ 4 ......... ........ 5 ......... ........
Calculate the increament Salary
a. Calculate the Percentage as
(After Increment Salary - Before Increment Salary)/Before Increment Salary * 100
b. Show the percent in pie chart view.

Q.No. 5. Enter following data in Excel Worksheet. (10)
 Product Date Qty Rate Disc% Amount USB Extension 150 186 7 Pen Drive 3000 1600 12 Memory Sticks 500 668 7
Fill up the blanks cells with following information.
a. Display current system data in Date column in YMD format such as 13 Oct 2012.
b. Format the Rate column with one decimal digit and currency such as Rs. 186.0
c. Calculate Amount for each row.