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

Operators are the symbols which are used to perform mathematical calculation according to the data type.
For e.g. +, -, <, >, & etc are the operators.
With the help of these operators, you perform simple mathematical calculations, a mathematical calculation based on condition, basic operation on the text such as join the text but this is rarely used.

Operators in Ms-Excel specifies the type of calculation to be performed on a given set of values.
Basically, there are 4 types of operators in Excel, mentioned below:

  • Arithmetic Operators.
  • Logical/Comparison Operators.
  • Text Concatenation Operator.
  • Reference Operators.
Arithmetic operators in Excel
As the word itself suggest, Arithmetic Operators are used for arithmetic operations like addition, subtraction, multiplication, division, etc. As can be guessed, this set of operators can be used for numeric calculations.
The following are the arithmetic operators available in Excel.
  • + Plus (addition):- 
With the help of this operator, you perform the addition calculation on ms-excel. For e.g.
Addition operators in ms-excel
In the above figure, I3 cell is the total of all subjects which is calculated by SUM function but in this case, another formula also is used  "=D3+E3+F3+G3+H3". Let me explain, if you want to sum numbers in ms-excel, firstly type the equal symbol (=) just type the address (location) of cells and adds the + sign symbols between cells.  For e.g. "=A1+B1"
  • - Minus (subtraction):- 
This operator is used to perform subtraction. For e.g. In the below figure, To calculate Net Amount (H8 Cell), you need to subtract Total-discount but using formula "=F8-G8" in ms-excel. 
subtract operators in ms-excel
  • * An asterisk (multiplication):-
This Asterisk symbol is used to perform multiplication on ms-excel. In the above figure to calculate Total, you need to multiply Item Price with Quantity No., to do that you need to multiply D8 cell with E8 cell. For e.g. typing the formula "=D8*E8" in the Total (F8) Cell to find out the total amount.
  • / Slash (division):-
The division operator is used to divide the numbers in ms-excel. In the below figure,  to calculate the Percentage, here we divide the total marks of all subjects with the number of subjects. We divide the Total (I4) cell with 5 by typing the formula "=I4/5" in the J4 cell. 

division operator in ms-excel
  • % Percent:-
In the ms-excel, we calculate the percentage by multiplying the number with the % symbol in the formula. For e.g., in the below figure, to calculate the VAT of an item, here we multiply the Amount with 13%. 
ampersand operator in ms-excel
  • ^ Caret (exponentiation):
In the ms-excel, to calculate the value of the square number or number of power, we need to use Caret Symbol between the numbers. For e.g. to calculate the square of the 5 number, we need to write the "=5^2" formula in ms-excel. 
Comparison operators in Excel
Operators comparisons are used when we need to compare two values ​​or two data. In working with these operators return us to TRUE or FALSE (true or not true). Here I show you the figure in which these operators are to be defined.
comparision operators in ms-excel
  • = Equal to
  • < Less than
  • > Greater than
  • >= Greater than or Equal to
  • <= Less than or Equal to
Text operators in Excel
Working with text in Excel, you have the ability to concatenate multiple parts of the text in a single unit. For this purpose, you can use the & character (ampersand) that concatenate two or more values ​​from multiple cells to produce one continuous text value ("earth" & "is" & "round") and the result is (earth is round) in a single cell.
text operators in ms-excel
Excel has one operator which helps to join in two or more text strings and produces a single text line. We can use the ampersand (&) operator to join two or more strings and get a single text line.

Operators references in Excel
There are three operator's references for working with Excel. These operators are helping us to combine multiple ranges of cells in calculations and formulas.
  • ":" Range (colon)
  • ";" Union (semicolon) or ',' (comma)
  • 'space' intersection (blank character, using the Space key on your keyboard)
Using these operators is easier to work with formulas.
The range operator serves us to use more cells in some range of data.
Union operator separates multiple ranges of cells and makes union data.
Intersection operator, which results in a reference to cells common to the two references. Below are the example of the above operators.

comparision operators in ms-excel

This is all about Operators in Ms-excel, if you have any problems to use these above operators in ms-excel, feel free to comments here, I'll answer you as soon as possible.

No comments:

Post a Comment

Post Top Ad