Public Service Commission Preparation & Blogging

Post Top Ad

Ms-Office Practical Guides

In this section, we present the learning materials for your computer practical exam especially in Ms-Office. Most important, frequently asked Questions, Practical Guides, Practice Sets, and Tips & Tricks from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the practical exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's started to learn.


Ms-Word

Practical Guides

Ms-Word

Asked Papers

Ms-Word

Practice Sets

Ms-Word

Tips & Tricks


Ms-Excel

Practical Guides

Ms-Excel

Asked Papers

Ms-Excel

Practice Sets

Ms-Excel

Tips & Tricks


Ms-Powerpoint

Practical Guides

Ms-Powerpoint

Asked Papers

Ms-Powerpoint

Practice Sets

Ms-Powerpoint

Tips & Tricks


Ms-Access

Practical Guides

Ms-Access

Asked Papers

Ms-Access

Practice Sets

Ms-Access

Tips & Tricks


Multiple Choice Questions Sets

Here we presents the selected, Most important, frequently asked Multiple Choice Questions from Ms-word, Ms-excel, Ms-powerpoint, Ms-Access and HTML for the written exam preparation of PSC Computer Operator and Data Entry Supervisor. Let's Get started to learn.


Ms-Word

MCQ Sets

Ms-Excel

MCQ Sets

Ms-Powerpoint

MCQ Sets

Ms-Access

MCQ Sets


HTML

MCQ Sets

Operating System

MCQ Sets



Interviews Preparations

The most important part of preparing for an Interview is practice. Preparation is the key to a successfull interview so take a look at Preparations Questions and Tips & Tricks how to answer them. Let's Get started to learn.


Interview Questions

Asked Before

Tips & Tricks

Based on Experience



Question Papers

I knew its hard to find the right question papers in internet from one website. But it's good to say here i collects questions papers sets that are previously asked from psc exams. These questions will be helpful for the final preparation of your exam. Let's start to expand your knowledge.


Section Officer

Asked Before

Computer Officer

Asked Papers

Nayab Subba

Asked Papers

Computer Operator

Asked Papers


Kharidar

Asked Papers

Asst. C.O.

Asked Papers



Modal Practice Paper Sets

Here we have writes some sample practical paper sets for your exam. Try to solve these questions within time at home frequently. If you solve this within time you will cover almost every quetions in exam hall. These questions will be helpful for the final preparation of your exam. Let's start to practice.


Section Officer

Modal Sets

Computer Officer

Asked Papers

Nayab Subba

Modal Sets

Computer Operator

Modal Sets


Kharidar

Modal Sets

Asst. C.O.

Modal Sets



Tutorials & Courses

In this section, we presents the learning materials for your Public Service Commission exam, bank exam, Nea exam, institutional exan etc. This section contains chapters with solutions, cources, or any thing that helps for your written exam, practical exam & interview based on curriculam. Let's start to prepare for your exam.


Section Officer

Tutorials

Computer Officer

Tutorials

Nayab Subba

Tutorials

Computer Operator

Tutorials


Kharidar

Tutorials

Asst. C.O.

Tutorials



Blogging & Wordpress Tutorials, Courses

In this place, you will find blogging tips, new strategies, and will teach you how to be a bogger with just the most basic computer skills. Everything you need to know to start blogging-we'll show you how step by step for blogging and wordpress. Let's Get started to learn.


Wordpress

Tips

Blogging

Tips

Wordpress

New Strategies

Blogging

New Strategies


Blogging

Make Money

Wordpress

Make money

Blogging

Guide

Wordpress

Guide


Blogging

For Beginners

Wordpress

For Beginners

Blogging

Tutorials

Wordpress

Tutorials


Wordpress

How to start?

Blogging

How to start?

Blogging

Intermediate

Wordpress

Intermediate


Post Top Ad


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.


Q.No.2. Enter following data in speadsheet and perform as asked. (10)
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.


No comments:

Post a Comment

Post Top Ad