# 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

Ã˜Â  Create suitable chart to plot given data: - For e.g., Pie, bar, column, line chart etc.
Ã˜Â  Use formula to satisfy given condition: - 1. Using AND, IF, OR, NOT, SUMIF operator etc. >, <, >=, <=, = etc. 2. Sum, Average, Max, Min function etc.
Ã˜Â  Sort and Filter: - Sort data in specific column or all in ascending order or descending order on values, cell color etc.
Ã˜Â  What if Analysis (Goal Seek): - For e.g. if you know result that you want from a formula, but not the input value then you needs to get that result.
Ã˜Â  Table formatting, cell formatting: - To format cell, table giving conditions.
Ã˜Â  Insert header or footer in a sheet.
Ã˜Â  Use Conditional Formatting: - For e.g. Use Conditional formatting to display cell in giving condition.
Ã˜Â  Inserting comments (Notes) on cell.
Ã˜Â  Consolidate Sheets: - For e.g. Consolidate means combine the data using function (sum, average) from different sheet or workbook in other sheet or workbook.
Ã˜Â  Data Validation: - For e.g. Configure a cell such that it not accepts values satisfying condition that are given in question.
Ã˜Â  Rang Names: - For e.g. giving a name for range of cell or a cell so that it uses further for calculations or used for easier.
Ã˜Â  Format the cells: - For e.g. to display cell value in Rupees or Dollar, or Pound within two decimal places, alignment the value; left, right, middle, top, middle, bottom, align, Merge cells, wrap text t he cell value, rotating text.
Ã˜Â  Format Painter: - For e.g. it uses as to format the cell from one to another range or a single cell.
Ã˜Â  Hyperlink: - For e.g. to insert hyperlink in a cell or in sheet.
Ã˜Â  Insert External Data from other files: - For e.g. If insert data from access file, text file, web etc to calculate.