Excel User Define Function/C Language/Syllabus Update of PSEB/ Learning Computer

Merge Same Value Cells of Excel

2012-10-03T22:18:00.001-07:00

Steps to Merge Same Value Cells in Excel

Create an Excel Sheet

Month	Salary	Emp Name
January	1000	Gulab
January	5000	Chand
January	89900	Maurya
Feb	93829	Rohit
Feb	73827	Shivansh
March	798989	Maurya
March	232	Shiv

Create New Macro
to create new macro press alt+f8

view this video for help

macro code used in video is given below:-

Sub MergeSame()
Dim r As Range, c As Range
Dim i As Long, j As Long
Set r = Range("A1", Cells(Rows.Count, "A").End(xlUp))

Application.ScreenUpdating = False
Application.DisplayAlerts = False

For i = 1 To r.Count
Set c = r(i)
j = 0
Do Until c <> c.Offset(rowoffset:=1)
Set c = c(2)
j = j + 1
Loop
With Range(r(i), c)
.Merge
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
End With
i = i + j
Next i

Application.DisplayAlerts = True
Application.ScreenUpdating = True
DoEvents
End Sub

alfter running macro the result is show below

Month Salary Emp Name
January 1000 Gulab
5000 Chand
89900 Maurya
Feb 93829 Rohit
73827 Shivansh
March 798989 Maurya
232 Shiv

Regards

Ram Rati

Form For Matriculation Examination Punjabi as Additional Subject October 2012

2012-10-02T22:37:00.000-07:00

Dear Students

Punjab School Education Board Has Published Admission Form For Matriculation Punjabi Additional Examination Form For October 2012 Under Special Examination of Punjabi Students can Download From From the Given Below Link:

Form For Matriculation Examination Punjabi as Additional Subject October 2012

Fee- Rs.3000/-
Instructions: -
Last date of submission of form 17/10/2012 (No form after the expiry of last date will be entertained).
Date of examination PB(A)- 30/10/2012, PB(B) 31/10/2012 and Time of Exam 11:00 AM to 2:00 PM.
Centre for this examination will be allotted in Sahibzada Ajit Singh Nagar Only.
Fee can only be deposited at the Cash Counter, Head Office,Vidya Bhavan, Phase 8, Sahibzada Ajit Singh Nagar (Punjab).
Forms to be deposited at the concerned examination branch (Form Section).The candidate is advised to bring the original pass certificate of
matriculation level.
The Roll Numbers for this examination will be available after 25/10/2012 on Board's Official Website-www.pseb.ac.in.The candidate who is
unable to get his/her roll number online can collect his/her roll number from the concerned examination branch by showing the fee receipt issued
by the Board, such candidates are advised to bring the original pass certificate of matriculation level and two passport size photographs.
Note: The Roll Numbers will not be dispatched through post. The candidate has to download his/her Roll Number from Website- www.pseb.ac.in
Attesting authorities: - School Headmasters/Principals/Board Members/Board Officers not below the Assistant Secretary and First Class Magistrate.

Regards
Ram Rati

PSEB ECONOMICS (HUMANITIES GROUP)

2012-10-01T03:11:00.002-07:00

ECONOMICS

(HUMANITIES GROUP)

Time : 3 Hours Theory: 70 Marks CCE: 30 Marks

Total: 100 Marks

STRUCTURE OF QUESTION PAPER

1. The Question Paper will cover whole of the prescribed syllabus.

2. All Questions will be compulsory.

3. The questions paper will comprise of 15 questions in total.

4. The question paper will have 3 Sections A, B & C.

SECTION A

This section will consist of Q. No. 1 which will be objective type consisting of 12 sub parts (i.e. 6 questions from Part A and 6 questions from Part B of syllabus). Each sub part carry 1 mark. Objective type questions may include questions with one word to one sentence answer/fill in the blank/true or false/multiple choice type questions.

SECTION B

This section will consist of 10 short answer type questions (i.e. 4 questions from Part A and 6 questions from Part B of syllabus) carrying 3 marks each. Answer of each question should be given in 50-60 words. Out of 6 questions from Part-B one question will be numerical.

SECTION C

This section will consist of 4 long answer type questions (i.e. 2 questions from Part A and 2 questions from Part B of syllabus) with internal choice carrying 7 marks each. Answer of each question should be given in 200-250 words. Out of 2 questions from Part-B one question will be numerical.

Syllabus	Units	Sec A 1 Mark Questions	Sec B 3 Mark Questions	Sec C 7 Mark Questions	Total Marks
PART - A Micro Economics	1 2 3 4	1 2 2 1	1 1 1 1	1 Q from Unit 1 & 2 1 Q from Unit 3 & 4	32
PART – B Macro Economics	5 6 7 8 9	1 1 1 2 1	1 2 1 1 1	1 Q from Unit 5 & 6 1 Q from Unit 7, 8 & 9	38
Total	9	12	10	4	70

SYLLABUS

PART-A (INTRODUCTORY MICRO ECONOMICS)

Unit–1 INTRODUCTION

Micro Economics: Meaning; Difference between Micro and Macro Economics, Central Problems of an Economy, Production Possibility Curve and Opportunity Cost.

Unit-2 CONSUMER BEHAVIOUR AND DEMAND

i. Consumer’s Equilibrium:- Meaning, Attainment of equilibrium through Utility Approach (one and two commodity case).

ii. Theory of Demand: Meaning of Demand, Types of Demand: Individual and Market Demand, Determinants of Demand, Demand Schedule, Demand Curve, Movement along and shift in Demand Curve.

iii. Price Elasticity of Demand: Measurement of Price Elasticity of Demand- Percentage, Total expenditure and Geometric method.

Unit-3 PRODUCER BEHAVIOUR AND SUPPLY

i. Production-Meaning, Concept of Production, Function: Returns to Factor and Returns to Scale.

ii. Theory of Supply: Meaning of Supply, Types of Supply: Individual and Market Supply, Determinants of Supply, Supply Schedule, Supply Curve, Law of Supply, Movement along and shifts in supply curve, Price Elasticity of Supply, Measurement of Price Elasticity of Supply; Percentage and geometric method.

iii. Concepts of Costs: Short Run Cost Curves; Fixed and Variable Costs, Total, Average and Marginal Costs.

Concepts of Revenue: Total, Average and Marginal Revenue and their relationship.

iv. Producer’s Equilibrium with the help of MC and MR.

Unit-4 FORMS OF MARKET AND PRICE DETERMINATION

i. Forms of Market: Perfect Competition, Monopoly, Monopolistic Competition-Their Meaning and Features.

ii. Price Determination under Perfect Competition- Equilibrium Price, Effect of shifts in Demand and Supply.

PART-B (INTRODUCTORY MACRO ECONOMICS)

Unit-5 NATIONAL INCOME AND RELATED AGGREGATE

i. Basic Concept and Measurement of National Income (introduction only)

ii. Macro Economics: Meaning, Circular flow of Income,

Concepts of GDP, GNP, NDP, NNP (at market price and factor cost), National Disposable Income (Gross & Net); Private Income, Personal Income and Personal Disposable Income.

iii. Measurement of National Income-Value Added Method, Income Method & Expenditure Method

Unit-6 DETERMINATION OF INCOME AND EMPLOYMENT.

i. Aggregate Demand, Aggregate Supply and their Components.

ii. Propensity to Consume and Propensity to Save (Average and marginal).

iii. Meaning of Involuntary-Unemployment, Concept of Full Employment.

iv. Determination of Equilibrium level of Income and Employment-Two sector model.

v. Concept of Investment Multiplier and its working.

vi. Problems of excess and deficient Demand. Measures to correct excess and deficient Demand, Availability of Credit, Change in Government Spending.

Unit-7 MONEY AND BANKING

i. Money: Meaning, Evolution and Functions.

ii. Central Bank: Meaning and Functions.

iii. Commercial Banks: Meaning and Functions.

iv. Recent significant reforms and issues in Indian Banking System; Privatisation and Modernization.

Unit-8 GOVERNMENT BUDGET AND THE ECONOMY

i. Government Budget. Meaning and its Components, Objectives of Government Budget.

ii. Budget Receipts – Revenue Receipts and Capital Receipts.

iii. Budget Expenditure-Revenue and Ca pital Expenditure, Plan and Non-Plan Expenditure and Development and Non-Development Expenditure.

iv. Balance Budget, Surplus Budget and Deficit Budget: Their Meaning and Implications; Types of Deficit Budget-Revenue Deficit, Fiscal Deficit and Primary Deficit(meaning and implications); Measures to contain different Deficits. Downsizing the role of Government: Meaning and Implications.

Unit-9 BALANCE OF TRADE AND BALANCE OF PAYMENTS.

i. Foreign Exchange Rate: Meaning, Fixed and Flexible Exchange Rate System-Meaning, Merits and Demerits.

ii. Determination of Flexible Exchange Rate System through Demand and Supply.

iii. Balance of Payment Accounts; Meaning and Components.

iv. A brief analysis about recent exchange rate issue.

PSEB 10+2 STRUCTURE OF QUESTION PAPER PUNJAB HISTORY AND CULTURE

2012-10-01T03:09:00.003-07:00

3. PUNJAB HISTORY AND CULTURE

Time: 3 hrs. Theory: 70 Marks

CCE: 30 Marks

Total: 100 Marks

STRUCTURE OF QUESTION PAPER

1. There will be 22 questions in all. All questions will be compulsory.

2. Question No. 1 to 10 will carry 1 mark each. Answer to each question should be in about 1 - 15 words. 10 × 1 = 10

3. Question No. 11 to 15 will carry 3 marks each. Answer to each question should be in about 30- 35 words. 5 × 3 = 15

4. Question No. 16 to 20 will carry 5 marks each with 100% internal choice. Answer to each question should be in about 75-85 words. 5 × 5 = 25

5. Question No. 21 & 22 will carry 10 marks each. Answer to each question should be in about 250 - 300 words. Three will be 100% internal choice in these questions. The paper setter should not set more than one such question from one chapter.

2 × 10 = 20

TOPIC NO.	Questions carrying 1 mark	Questions carrying 3 marks	Questions carrying 5 marks	Questions carrying 10 marks	Total
1, 2, 3,4	4	2	2	1	30
5,6,7,8,9,	6	3	3	1	40
Total questions	10	5	5	2	22
Total marks	10	15	25	20	70

SYALLBUS

1. The great Mughals and their legacy to the Punjab.

2. Guru Nanak Dev Ji.

3. Successors of Guru Nanak Dev Ji.

4. Banda Singh Bahadur and his martyrdom.

5. Sikhs became the Masters of the Punjab.

6. The Punjab under Maharaja Ranjit Singh.

7. The British occupation of the Punjab.

8. Some famous Legends of the Punjab:-

a. Puran Bhagat b. Heer Ranjha

c. Sohni Mahiwal

9. Classical Literature of the Medieval period.

Syllabus 10+2 based on annual system for PSEB Students(GENERAL ENGLISH)

2012-10-01T02:45:00.002-07:00

1. GENERAL ENGLISH

Theory: 50 marks

Time :- 3 hrs CCE: 25 marks

Total: 75 marks

STRUCTURE OF QUESTION PAPER

Do all questions.

Part-A

1 Objective type question (13 questions) based on total syllabus. 13 marks

Part-B (English Reader Book VI) 15 marks

2 a) Comprehension passage 8 marks

b) Essay type question (one out of two) from English Reader in about

100 words. 5 marks

c) Translation from Vernacular into English. (2 isolated sentences). 2 marks

Note:- A special question in lieu of translation for foreign students (To paraphrase a stanza in simple English.)

Part-C (Supplementary Reader) 17 marks

4 a) Short answer type questions (3 out of 5 questions) 3x2= 6 marks

b) Essay type question (one out of two stanzas) from Supplementary

Reader in about 100 words. 4 marks

5 a) Reference to the context & explanation. (1 out of the 2 stanzas) 4 marks

b) Central Idea of a poem (1 out of 2) 3 marks

Part – D 5 marks

6 Do any one out of the following : Paragraph /application/ letter/Precis writing

Paragraph writing (descriptive only) (one)

Application/Letter (Personal/ (one)

Precis writing (one) 5 marks

MARKING SCHEME FOR COMPREHENSION

Sr.No. Questions M.M. 8

1. Name of the Writer and the Chapter 2 marks

2. Short Question 1 mark

3. Short Question 1 mark

4. Match the two words with their meanings 2 marks

5. Fill in the blank with a suitable word from the passage 1 mark

6. Give meanings in simple English (two) 1 mark

INSTRUCTIONS FOR OBJECTIVE TYPE QUESTION

Objective type question will cover the whole syllabus prescribed

Note :- All questions will be strictly based on the syllabus.

All sub-questions are compulsory (marks-13)

Grammar: 7

English Reader: 4

Supplementary Reader: 2

Q.1(a) Do as Directed :

Change the Tense (1)
Change the Voice (1)
Change the Narration (1)
Use of same word as a Noun and as a Verb (only one) (1)
Use of Prepositions and Determiners in sentences (two) from the text (1+1=2)
Transformation of sentences (1)

(b) One line answer questions from English Reader-VI 4 marks

General English

Syllabus

English Reader

1. Monday Morning

2. Swami and his Father

3. All about a Dog

4. Treasure from the Deep

5. Maori Villages

6. The Penguins

7. Alfred Nobel

8. The Easter Egg

9. On Patrol

10. Columbus Sails

11. Fighting the Invisible

12. Operation Indian Ocean

13. Nehru's Will and Testament

14. The Death of Socrates

Supplementary Reader

1. The Diamond Necklace

2. The Lost Child

3. The Doctor's Word

4. The School for Sympathy

5. Tolstoy's Home

6. On Saying ‘Please’

7. Forgetting

8. The Never-Never Nest

9. Uncle Podger Hangs a Picture

10. Reconciliation

11. Fasting as Penance

12. The Tank

13. The Variety and Unity of

India

Poems

i. Where the Mind is Without Fear

ii. Stopping by Woods on a Snowy Evening

iii. Leisure

iv. Say Not, the Struggle Naught Availeth

v. The Daffodils

vi. Indian Weavers

vii. No Men are Foreign

Grammar

1. Determiners and Prepositions

2. Use of same words as a Noun and as a Verb

3. Change the Tenses

4. Voice

5. Narration

6. Transformation of Sentences

Composition

1. Letter-Writing

2. Paragraph-Writing

3. Precis Writing

Learn Computer Basic In 20 Days

2012-10-01T02:27:00.001-07:00

First Day

What is Computer?

Computer is an electronic device which process data under some commands. Computer is very accurate and fast. It can perform multiple tasks at a single time. One computer can perform task of number of persons. Now a day’s computer is used in every field medical, engineering, office management etc.

[Picture 1]

What is CPU?

CPU Stands for Central Processing Unit, it processes all the command given by user.

What are Operating Systems?

The Operating System (OS) is an integral part of your computer. It acts as an interpreter between the different application software programs and your computer. The OS can understand the data, information and commands used by different programs because those programs are written or coded specifically for that Operating System's interface, using it's standard rules, commands and protocols. It then translates the many commands and information into procedures the computer can understand. Computers are not of much use without an operating system.

Just a quick note on Operating Systems. As I said before, your computer will not work without one. The accepted practice in most stores is to sell computers with operating systems.

Recently, I was buying a computer for a customer and one particular store had prices considerably lower than others. Of course, there were the usual price cutting features, smaller hard drive, cheaper video card, less RAM, etc..., but it would serve the purpose. They offered the choice of Windows98 or 2000, which was really nice of them... considering the fact that you had to buy it off the shelf!

Name of Some O.S (Operating Systems are as follows)

MS-DOS (Micro Soft Disk Operating System) it’s a single O.S. It is CUI Character user interface.

WINDOWS, UNIX, LINUX are Multi user O.S. These are GUI Graphics User Interface.

Categories of software:-

Application Software: - Refer to programs or sets of programs that perform a specific processing application. For Example an application package for processing examination results produces mark sheets as the major output, along with other reports such a merit lists, total number of students passed etc. Other examples are payroll Packages, inventory control etc.

System software: - Consists of sets of general programs designed to control the operation of a computer system. Without system software, applications packages cannot be executed example are control program, processing programs etc.

What is RAM/ROM?

RAM (Random Access Memory) acronym for random access memory. the main system memory in a computer, used for the operating system, application programs and data

ROM (Read Only Memory) Acronym for read-only memory. A semiconductor-based memory system that stores information permanently and does not lose it contents when power is switch off. ROMs are used for firmware such as the BIOS used in the PC; and in some portable computers, application programs and even the operating system are being stored in ROM.

How to Switch On/Off Your Computer?

Steps to Switch on your Computer

Plug your computer with UPS (Un-Interrupted Power Supply, used for electricity backup for some time)/Main Power.

Turn on your Computer from CPU (Central Processing Unit) from its Power Button.

Turn on your monitor from its Power Button.

Steps to Switch off your Computer

Left Click at Start Button as shown in [Picture1]

[Picture1

Click at Turn off Computer

Following Windows will appear to turn off your computer click at turn off

By following above mentioned Steps we can shut down Our Computer.

Note: - Before Shut Down Save your Data/File (For detail of file and folder see
PageNo-9)

Starting Paint

To Start Paint Click at Start à All Programs àAccessories àPaint, as shown in [Picture3]

[Picture3]

Look of Paint is as follows in [Picture4]

[Picture4]

Saving File in Paint

Click at File Menu à Save Save Dialogue Box

Save Dialogue Box will appear Give the file name [ab] and click at save to save

Click at Cancel to cancel the command.

Create a New File

File MenuàNew Creates a new Blank File

Setting Current Bitmap as Background

File Menu à Set as Background (Tile/Center)

Tools of Paint

Colour Picker

Exercise for Paint

YYY

Second Day

What is Desktop?

Desktop is first screen which appear on you computer when computer is switched on. On desktop you can place shortcut for your any application or any file or you can create your folder/file.

On the Desktop by default My Computer, My Documents and Recycled are placed.

Look of Desktop [Picture1]

[Picture1]

What is Icon?

Icon is a Graphic object which is related to any application.

Identification of some common icons are as follows

Micro Soft Word

Micro Soft Excel

My Documents

How to Set Date and Time?

Steps to Change Date and Time are as follows

First Click at àStart à Control Panel à Date and Time (double click with mouse)

Change Date and time according to your requirement

Look at Picture2

Left Click with Mouse

[Picture2]

After clicking at control panel following picture will be appear [Picture3]

Double Click with Mouse

[Picture3]

Double click at Date and Time

Following Screen will appear as shown in [Picture4]

[Picture4]

What is

My Computer is the facility which lets you access the component parts of your computer. My Documents is just part of My Computer and the current window can be used to access it

Most icons in My Computer represent disk drives. For example, drive A: is the floppy drive and E: is usually the cd drive. Drives C: and D: represent the internal hard disk.

To access My Computer press Window Key + D to minimize all active windows.

Double Click with (left mouse button) on My Computer Icon

Following screen will appear as Shown in Picture5 and Pictue6.

[Picture5]

[Picture6]

Double click at C Drive to open C Drive

Creating New folder in C Drive

Click at File Menuà New à Folder

Change the name of folder by default it is [New Folder]

As shown in [Picture7] and [Picture8]

[Picture7]

[Picture8]

To Change Name of Folder/ File Press [F2] and Change the name of file/folder.

Control Buttons - the three icons in the top right corner from left to right are:

Minimize - temporarily hides the window

Maximize - makes a window fill the screen. When a window is maximized, this button becomes Restore Down, which returns the window to its smaller size

Close - closes the window

Menu Bar - a simple menu system which gives access to all available commands

What is My Documents?

By default you files are saved in my document when you save your file. But is not necessary to you to save your files in my documents you can save your files in your own folders

File:- files is use to store row data.

Folder: - folder is used to store files and subfolders (folders are just like file cover or you can say folders are just like Almira

My Documents

IMPORTANT: Please use My Documents (NOT FLOPPY DISKS) to store your work. Only use floppies for moving your work between a lab and your own PC.

What is Recycle Bin?

Recycle Bin is a Utility from where you can get your deleted files and folders. If you delete your file or folder from Recycle Bin then you can’t get that file or folder back/ restore. When you delete you file/folder from Recycle Bin they are permanently deleted form your computer.

How to delete a file/folder?

Trace your file select that file/folder by left click of your mouse and then press [Del] Key from keyboard it will prompt you to delete or cancel is operation/command.

What is Virus?

Virus is unwanted files/unwanted commands which are created/run automatically it self some time it cruppers our files or sometime it makes our system very slow etc.

To prevent your computer from virus follow some following instructions:-

· Install any good Anti Virus software in your computer. [For Example Norton Antivirus]

· Before using floppy/Pen Drive scan your disk.

· While using internet be care full while downloading file scan all files before

YYY

Third Day

Common tasks done in a Microsoft Word document by short keys

CTRL+SHIFT+SPACEBAR

Create a nonbreaking space.

CTRL+HYPHEN

Create a nonbreaking hyphen.

CTRL+B

Make letters bold.

CTRL+I

Make letters italic.

CTRL+U

Make letters underline.

CTRL+SHIFT+<

Decrease font size.

CTRL+SHIFT+>

Increase font size.

CTRL+SPACEBAR

Remove paragraph or character formatting.

CTRL+C

Copy the selected text or object.

CTRL+X

Cut the selected text or object.

CTRL+V

Paste text or an object.

CTRL+Z

Undo the last action.

CTRL+Y

Redo the last action.

YYY

Fourth Day

What is a File? /How to create a file?

File is a collection of raw facts. In computer we can create different type of files in different applications. But we are going to learn how to create a text file, write file, doc file. Text file can be created in Notepad, write file can be created in WordPad, Doc file can be created in MS-Word.

Starting Note Pad

Click at Startà All Programsà Accessoriesà Notepad

Click at notepad as shown in [Picture1]

[Picture1]

Look of Notepad is as follows:-

[Picture2]

Typing in Notepad

[Picture3]

Saving Text File in My Documents

Click at File Menu à Save à Select My documentsà Give File Name

As shown in [Picture3]

[Picture4]

Opening Text File from My Documents

Click at File MenuàOpenàSelect My Documentsà Select File name by left button click of mouse and click at open button as shown in [Picture4]

[Picture5]

Selecting text in note pad

Put your cursor at starting point from where you want to start selection and push left button of mouse and move your mouse till that place, till where you want to select.

After selecting you can copy/cut/clear this selected matter.

(What is copy? By cut/copy the selected matte is stored in clipboard; we can get it back by paste command, note cleared/Del matter is not stored in clipboard)

To copy selected matter Press CTRL+C

To cut Selected matter Press CTRL+X

To clear/delete Selected matter Press DEL

[Picture6]

Pasting text data from clipboard

To insert/paste clipboard text data in Notepad put your cursor at the place where you want to insert clipboard text data. Then Press CTRL+V or click at Edit Menuà Paste

YYY

Fifth Day

Starting Microsoft Word

To load Microsoft Word:

Click on the Start menu in the bottom left corner of the screen
Choose All Programs then Microsoft Office (from the sub-menu which appears)
Finally click on Microsoft Office Word 2003

Tip: You'll probably be using Word quite frequently in the future, so it's worth putting it as an icon on the Desktop. To do this, repeat steps 1 to 3, but at step 3 hold down the mouse button (instead of clicking), and drag the mouse away from the menus. Release the mouse button and a Word icon will appear on the Desktop. To load Word in future, simply double click on the icon.

The window shown below will open, ready for you to begin typing.

The window has menus along the top, with toolbars underneath. Both these can be used to give instructions to Word (e.g. to save or print your work). Below the toolbars is the ruler, which shows you have almost 15cm across for your typing (there's another 3cm each side for the margins).

Scroll bars are provided on the right (and bottom) to let you move up and down (or sideways across) your work. At the very bottom of the window, there is information about where you are in your document - here you are on Page 1, at 2.5cm down the paper. Finally, on the far right is the Task Pane, which tries to provide help on Getting Started.

Writing Your Document

Entering Your Text

In a minute you are going to type in some words. If you are not very fast at typing, just type some rubbish, as below, pressing keys at random (BUT remember to type spaces between your words).

Type in a few words, pressing the <spacebar> once after each word to separate them

Don't worry about any red underlining which might appear. This shows where you have made a spelling mistake - there are quite a few in our example!

Continue typing across the screen - the words will automatically spill onto a new line when you reach the right-hand side
Continue typing until you have at least three lines of words then press <Enter> (the upside-down L-shaped key on the right of the main keyboard) to mark the end of the paragraph

Tip: Never press the <spacebar> or <Enter> key more than twice in succession. In particular, do not use spaces to centre a heading or line up words in columns, or to add extra blank lines to force a heading onto a new page. There are special key presses that do this for you - again, these are covered in next lessons.

To separate one paragraph from the next, press <Enter> again, for a blank line
Title Bar

Restore / Maximize button

Minimize button

Practice typing a couple of extra paragraphs, pressing <Enter> twice at the end of each

Close Button

Parts of Document Window

YYY

Sixth Day

Features of MS Word:-

Micro soft word is a very power full word processor it automatically corrects spell mistakes and able to update spell dictionary, it provides auto formatting, auto numbering. We can apply all above features by following steps of commands.

If you have written some thing wrong that word will be underlined automatically, just click at that word to correct as shown in [Picture1] to correct it just right click with mouse and choose the correct spell.

Picture1

Auto format means you can make formatting while typing for example in between * (Stars) written matter will be bold automatically, between _ (underscore) written matter will be italic for example:-

*this is formatting test line*

Above line will be bold automatically as follows

this is formatting test line

_this is formatting test line_

Above line will be italic automatically as follows

this is formatting test line

Important: - it is strongly recommended that without any need of new paragraph do not use enter or extra space to set paragraph.

Bullets and numbers will be automatically applied you have to start just first one for example type first number or insert first bullets mark as like below

first heading

Second number is automatically appeared to change format use can use tab or alphabets like a, i, I etc.

Some special symbols we can get by simple typing some are as follows

Character	Symbol
:(	L
-->	à
==>	è
(c)	©
(r)	®
1/2	½
1/4	¼
1st	1^st
2nd	2^nd
3rd	3^rd
4th	4^th
(tm)	™
<=>	ó

YYY

Seventh Day

Different Toolbars

Standard Toolbar

Formatting Toolbar

Drawing Toolbar

Revision of last lessons

Question Related last days.

YYY

Eighth Day

Creating New Document

Fileà New (Ctrl+N) Creates a new blank document

Open Existing Document

Fileà Open (Ctrl+O) Opens or Find a File

Closing Current File

File à Close (ALT+FC)

Close the active file without existing the program. If the file contains any unsaved changes, you will be prompted to save the file before closing. In Microsoft Word and Microsoft Excel, you can close all open files by holding down SHIFT and clicking Close All on the file Menu

Saving a file

Fileà Save (Ctrl+S)

Saves the current file with its current filename, location and file format.

Save as a File

File àSave as (F12)

Saves the Active file with different filename, location and file format. You can set password to your file by selecting toolsàoptionàSecurity then give your password to the file.

Page Setup

File à Page Setup (Alt+FU)

Sets margins, paper source, paper size, page orientation, and other layout options for the active file.

Print Preview (File menu) Ctrl +F2

Shows how a file will look when you print it.

Recently Used File List (File menu)

Lists the files you've most recently opened in this program. To quickly reopen one of these files, click it.

YYY

Ninth Day

Edit Menu

Undo (Edit menu)

Reverses the last command or deletes the last entry you typed. To reverse more than one action at a time, click the arrow next the Undo button, and then click the actions you want to undo. The command name changes to Can't Undo if you cannot reverse the last action.

Repeat (Edit menu)

Repeats your last command or action, if possible. The Repeat command changes to Can't Repeat if you cannot repeat the last action.

When you use the Undo command to reverse an action, the Repeat command changes to redo. The Redo command reverses the action of the Undo command.

Cut (Edit menu)

Removes the selection from the active document and places it on the Clipboard.

Copy (Edit menu)

Copies the selection to the Clipboard.

Show Office Clipboard

Displays the contents of the Office Clipboard.

Paste (Edit menu)

Inserts the contents of the Clipboard at the insertion point, and replaces any selection. This command is available only if you have cut or copied an object, text, or contents of a cell. For special paste options, click the down arrow next to the button.

Paste Special (Edit menu)

Pastes, links, or embeds the Clipboard contents in the current file in the format you specify.

Paste as Hyperlink (Edit menu)

Inserts the contents of the Clipboard as a hyperlink at the insertion point, replacing any selection. This command is available only if you have cut or copied the contents of a cell or data from another program.

Formats (Edit menu)

Removes only the formatting from your selection; the content and comments are unchanged.

Contents (Edit menu)

Deletes the selected text and graphics. If no text is selected, then the character before the insertion point is deleted.

Select All (Edit menu)

Selects all text and graphics in the active window, or selects all text in the selected object.

Find (Edit menu)

Searches for the specified text or formatting.

Replace

Searches for and replaces the specified text and formatting.

Go To (Edit menu)

In Microsoft Word, moves the insertion point to the item you want to go to. You can move to a page number, comment, footnote, bookmark, or other location.

YYY

Tenth Day

Normal (View menu)

Switches to normal view, which is the default document view for most word-processing tasks, such as typing, editing, and formatting.

Normal (View menu)

Switches to normal view, which is the default document view for most word-processing tasks, such as typing, editing, and formatting.

Print Layout (View menu)

Switches the active document to print layout view, which is an editing view that displays your document as it will print. Print layout view uses more system memory, so scrolling may be slower, especially if your document contains many pictures or complex formatting.

Task Pane (View menu)

Displays the task pane, an area where you can create new files, search for information, view the contents of the clipboard, and perform other tasks.

Toolbars (View menu)

Displays or hides toolbars. To display a toolbar, select the check box next to the toolbar name. To hide a toolbar, clear the check box.

Ruler (View menu)

Displays or hides the horizontal ruler, which you can use to position objects, change paragraph indents, page margins, and other spacing settings.

Document Map (View menu)

Turns on or off the Document Map, a vertical pane along the left edge of the document window that outlines the document structure. Use the Document Map to quickly browse a long or online document and to keep track of your location in it.

Header and Footer (View menu)

Adds or changes the text that appears at the top and bottom of every page or slide.

Footnotes (View menu)

Displays footnotes and endnotes so that you can view and edit them.

Markup (View menu)

Displays or hides comments and tracked changes such as insertions, deletions, and formatting changes. View markup when you want to process tracked changes and comments.

Full Screen (View menu)

Hides most screen elements so that you can view more of your document. To switch back to your previous view, click Full Screen or press ESC.

Zoom (View menu)

Controls how large or small the current file appears on the screen.

Eleventh Day

Test 10 Marks Time 30 Minutes

YYY

Twelfth Day

Insert Menu

Break (Insert menu) (CTRL+ Enter)

Inserts a page break, column break, or section break at the insertion point.

Page Numbers (Header and Footer toolbar)

Inserts page numbers that automatically update when you add or delete pages.

Date and Time (Insert menu)

Adds the date and time to an individual slide using the format you choose. If you want to add the date and time to every slide, use the Header and Footer command
(View menu).

AutoText (Insert Menu) ALT+F3

Creates or inserts an AutoText entry.

Click the AutoText entry you want to insert into your document.

Symbol (Insert menu)

Inserts symbols and special characters from the fonts that are installed on your computer.

Insert Footnote

Inserts a footnote or endnote into the active document. The note reference mark is inserted at the insertion point.

Caption (Insert menu)

Inserts captions for tables, figures, equations, and other items.

Index and Tables (Insert menu)

Creates indexes, tables of contents, tables of figures, tables of authorities, and other similar tables.

Clip Art (Insert menu)

Opens the Clip Gallery where you can select the clip art image you want to insert in your file or update your clip art collection. In PowerPoint, this command is available only in slide and notes views.

AutoShapes Menu

Displays the AutoShape categories you can insert. Click an AutoShape category, click the AutoShape you want, and then click or drag in the active window where you want to insert the AutoShape. To draw an AutoShape that retains its default height-to-width ratio, hold down SHIFT while you drag.

Insert WordArt

Creates text effects by inserting a Microsoft Office drawing object.

Text Box

Draws a text box with horizontal text direction where you click or drag. Text boxes help you arrange text and add text to graphics.

Object (Insert menu)

Inserts an object ¾ such as a drawing, WordArt text effect, or an equation ¾ at the insertion point.

Bookmark (Insert menu)

Creates bookmarks, which you can use to mark selected text, graphics, tables, or other items.

YYY

Thirteenth Day

Format Menu

Font (Format menu)

Changes the font and character spacing formats of the selected text.

you can change the font style, font size, font, font color, underline style, Effects like ~~strikethrough~~, ~~double Strikethrough~~, ^superscript, _subscript, shadow, outline, emboss ,engrave, Small caps, all caps hidden( hidden text is not printed on paper)

Paragraph (Format menu)

Changes paragraph indents, text alignment, line spacing, pagination, and other paragraph formats in the selected paragraph.

Bullets and Numbering (Format menu)

Adds bullets or numbers to selected paragraphs and modifies the bullets and numbering format.

Borders and Shading (Format menu)

Adds borders and shading to selected text, paragraphs, pages, table cells, or pictures.

Columns (Format menu)

Changes the number of columns in a document or a section of a document.

Tabs (Format menu)

Sets the position and alignment of tab stops and determines the type of leader character for each tab stop.

Drop Cap (Format menu)

Formats a letter, word, or selected text with a large initial ¾ or "dropped" ¾ capital letter. A "drop cap" is traditionally the first letter in a paragraph, and it can appear either in the left margin or dropped from the base line of the first line in the paragraph.

Text Direction (Format menu)

Rotates selected text in table cells so you can read it from bottom to top or from top to bottom.

Change Case (Format menu) SHIFT+F3

Changes the capitalization of selected text.

Fourteenth Day

Tools Menu

Spelling and Grammar (Tools menu)

Checks the active document for possible spelling, grammar, and writing style errors, and displays suggestions for correcting them. To set spelling and grammar checking options, click Options on the Tools menu, and then click the Spelling and Grammar tab.

Set Language (Tools menu)

Designates the language of selected text in a file that contains more than one language. The spelling checker automatically uses the dictionary for the designated language.

Word Count (Tools menu)

Counts the number of pages, words, characters, paragraphs, and lines in the active document. Punctuation marks and special symbols are also included in the word count.

Word Count (Tools menu)

Counts the number of pages, words, characters, paragraphs, and lines in the active document. Punctuation marks and special symbols are also included in the word count.

Mail Merge Wizard (Tools menu)

Starts the Mail Merge Wizard that helps you produce form letters, mailing labels, envelopes, catalogs, and other types of merged documents. (It a separate chapter)

Customize (Tools menu)

Customizes toolbar buttons, menu commands, and shortcut key assignments.

Options (Tools menu)

Modifies settings for Microsoft Office programs such as screen appearance, printing, editing, spelling, and other options.

AutoSummarize (Tools menu)

Automatically summarizes the key points in the active document. You can use the AutoSummarize command to create an executive summary or an abstract.

Compare and Merge Documents (Tools menu)

Compares the current document with any document you select, gives you the option to merge the two, or displays the differences (including any pre-existing tracked changes or comments) as markup. Lets you choose whether the merge results are displayed in the target document, in the current document, or, in a new, third document.

AutoCorrect Options (Tools menu)

Sets the options used to correct text automatically as you type, or to store and reuse text and other items you use frequently.

Macros (Tools menu)

Opens the Macros dialog box, where you can run, edit, or delete a macro. Use Record New Macro to record a series of actions as a macro, or click Visual Basic Editor to write a macro.

Related Examples

YYY

Fifteenth Day

Mail Merge

Is use to send a single letter at multiple address. For example a single circular we want to circulate in all the branches then mail merge command is very beneficial to do this work

Steps to do mail merge

Ø Type your Letter/document or any not which you want to circulate

Ø Tools menu à Mail Merge Wizard

Step 1

Select Letter Radio button then click at next

Step 2

Use Current Document

Step 3

Type new list or select existing list

Step 4

Insert merge fields at appropriate place where you want to print that detail.

Step 5

Preview your letters

Step 6

Print your letters

Test

15 Marks 30 Minutes

YYY

Sixteenth Day

Table Menu

Draw Table (Table menu)

Inserts a table where you drag in the document. After you drag to insert the table, drag inside the table to add cells, columns, or rows. You can create cells of different heights or a varying number of columns per row. In Microsoft Word, you can even create a nested table. For more information, type the keywords creating tables in the Office Assistant.

Insert Table (Table menu)

Inserts a table in the document with the number of columns and rows you specify.

Insert Columns to the Left

Inserts a column into the table to the left of the insertion point. If more than one column is selected, the same numbers of columns are inserted into the table to the left of the selection.

Insert Columns to the Right

Inserts a column into the table to the right of the insertion point. If more than one column is selected, the same number of columns is inserted into the table to the right of the selection.

Insert Rows Above

Inserts a row into the table above the insertion point. If more than one row is selected, the same number of rows is inserted into the table above the selection.

Insert Rows Below

Inserts a row into the table below the insertion point. If more than one row is selected, the same number of rows is inserted into the table below the selection.

Insert Cells

Inserts cells starting at the insertion point. You can choose to shift other cells in the table to the right or down. You can also insert an entire row or column.

Merge Cells

In Microsoft Word and Microsoft PowerPoint, combines the contents of selected adjacent cells into a single cell.

In Microsoft Excel, combines two or more selected cells into a single cell. The cell reference for a merged cell is the upper-left cell in the original selection. Merging multiple cells into one cell will keep the contents of the upper-left cell only.

Split Cells / Unmerge Cells

In Microsoft Word and Microsoft PowerPoint, splits the selected cells into the number of rows and columns you enter.

In Microsoft Excel, separates a merged cell into the cells that were originally combined.

Table AutoFormat (Table menu)

Automatically applies formats, including predefined borders and shading, to a table. Automatically resizes a table to fit the contents of the table cells.

AutoFit to Contents

Automatically adjusts the width of columns in the table, based on the amount of text you type.

Distribute Rows Evenly

Changes the selected rows or cells to equal row height.

Distribute Columns Evenly

Changes the selected columns or cells to equal column width.

Heading Rows Repeat (Table menu)

Designates the selected rows to be a table heading that is repeated on subsequent pages if the table spans more than one page. This command is available only if the selected rows include the top row of a table.

Sort

Arranges the information in selected rows or lists alphabetically, numerically, or by date.

Convert Table to Text

Converts a selected table or selected table rows to text, separating the contents of the cells in each row with the separator character you specify.

Table Properties

Sets various options to the table such as the table size, alignment, and text wrapping; the row height, row page breaking, and row header options; the column width; and the cell size, alignment, and other cell options.

Gridlines

In a table, the Gridlines command (Table menu) displays or hides dotted gridlines to help you see which cell you're working in. Table gridlines don't print; if you want to add printable gridlines to your table, use the Borders and Shading command (Format menu).

If you are working in an East Asian language, the Gridlines command (View menu) displays or hides the document grid.

Exercises Related To Table

YYY

Seventeenth Day

Micro Soft Excel

Microsoft excel is an electronic spread Sheet in common language we can say Microsoft excel is use for some calculations. In MS Excel we create Work books a work book is a collection of work sheet a worksheet is a collection of rows and columns. In one worksheet we have 65,536 rows and 256 columns are available and one workbook can contain maximum 256 worksheets.

A simple look of Microsoft excel is as follows:-

Micro Soft PowerPoint

Microsoft Power point is use for Presentation. We can create presentation in PowerPoint. With dynamic effects and sound. A simple look of a slide is show as blew picture:-

Revision of all lessons

YYY

Eighteenth Day

Internet

Abbreviation for internet work. A set of computer networks, made up of a large number of smaller networks, using different networking protocols. Internet the world’s largest computer network, consisting of over 10,500 individual networks supporting over1.7 millions computers and 15 million users. The internet users TCP/IP protocols

Terms used for internet?

www World Wide Web.

ISP: Internet Service Provider.

URL: Uniform resource Locater.

E-mail- Electronic mail is defined as the communication of nonverbal messages from one person to another using an electronic transmission medium.

Information moves between two locations over hard wires, telephone lines etc.

This information movement is referred to as telecommunications. Messages sent can be data which refers to figures or not-data i.e. text or graphics. Some of the most commons electronic mail transmission mediums are telex facsimile, computer-based message systems & communication word processor.

How to create an Email Id at yahoomail.com?

Double Click at internet explorer à write www.yahoomail.com at address bar then press enter. If you are old/existing of user of you mail then fill you email ID and password the click at Sign other wise click at Sign me up then you will find a registration form fill that form by following instruction given at the form after completing the form submit the form now you are success to create an E-mail Id at yahoomail.com.

Come back at home page of yahoo mail and fill you ID and PASSWORD and click at sign.

After doing this you will get a welcome screen and navigation bard containing Inbox, Compose, Address book etc. inbox is related to you list of mails it show how many mails you have and how many of them you have read and how many are unread. Compose by clicking at compose you can send mail to you desired person you just have to write the full email address in Send To Box and message in message box, after writing your message click at send button your message will be send to that person. After completing your work don’t forget to click at Sign out button.

How to open any web site?

Connect to the inter net by clicking at connect to internet when your are connected with internet.

To open any website first of all click at internet explorer then click at address bar and write the website address and press enter webpage will be open.

YYY

Nineteenth Day

Floppy Disk Drive

A device used to read and write data to and from a floppy disk floppy disk drives may be full-height drives, but more commonly these days they are half-height drives.(Floppy Disk:- a flat round magnetically coated plastic disk enclosed in a protective jacket.)

How to copy Data from computer to floppy?

Double click at My Computer à Select your Drive and then select your file to be copied -àRight click at very same file a popup will appear àSelect Copy from the popup by left click of mouse.

Again Double click at My computeràSelect Floppy DriveàDouble click with mouse and right click at any where in the window à A popup will appearà Select Paste Command and left click at paste command your file will be copied to the floppy disk

How to Create a Folder?

Look in Second Day for answer.

How Search A File?

Click at Start Button or press window key + S To search a file of folder

As shown in following picture

After clicking at search command Search will windows will appear as shown in following window

Click at all files and folders to give name of file and contents of a file of file extension (Extension for document file is .doc)

Click at Search button to start search

How to format a Floppy disk?

Double click at My computer and Select floppy disk à Right Click at floppy disk icon a popup will appear as shown in following picture

Click at format to format you floppy disk. By formatting your floppy disk will empty means whole date from your floppy disk will be removed permanently.

How to delete any file or Folder?

Double Click at My computer and select you file/folder which you want to delete and press DEL Key From key board you fill will be delete To Recover deleted file Double click at RECYCLE BIN and select you file right click at that file and click at restore. File will be recovered.

NOTE: - Once a file deleted from floppy disk that can’t be recovered from RECYCLE BIN.

Questions and Queries related all Days

11111111111111

Twentieth Day

Final Test 75 Marks 1- ½ Hours

Some Good Question Of C Language

2012-10-01T01:51:00.002-07:00

COLORS (text mode)

====================|Back-|Fore-

Constant |Value|grnd?|grnd?

--------------+-----+-----+-----

BLACK | 0 | Yes | Yes

BLUE | 1 | Yes | Yes

GREEN | 2 | Yes | Yes

CYAN | 3 | Yes | Yes

RED | 4 | Yes | Yes

MAGENTA | 5 | Yes | Yes

BROWN | 6 | Yes | Yes

LIGHTGRAY | 7 | Yes | Yes

DARKGRAY | 8 | No | Yes

LIGHTBLUE | 9 | No | Yes

LIGHTGREEN | 10 | No | Yes

LIGHTCYAN | 11 | No | Yes

LIGHTRED | 12 | No | Yes

LIGHTMAGENTA | 13 | No | Yes

YELLOW | 14 | No | Yes

WHITE | 15 | No | Yes

-----

#include <conio.h>

int main(void)

{

clrscr();

cprintf("INSLINE inserts an empty line in the text window\r\n");

cprintf("at the cursor position using the current text\r\n");

cprintf("background color. All lines below the empty one\r\n");

cprintf("move down one line and the bottom line scrolls\r\n");

cprintf("off the bottom of the window.\r\n");

cprintf("\r\nPress any key to continue:");

gotoxy(1, 3);

getch();

insline();

getch();

return 0;

}

------

#include <conio.h>

int main(void)

{

cprintf("Press any key to continue:");

while (!kbhit()) /* do nothing */ ;

cprintf("\r\nA key was pressed...\r\n");

return 0;

}

--------

#include <conio.h>

#include <string.h>

int main(void)

{

char *str = "This is a test string";

clrscr();

cputs(str);

getch();

movetext(1, 1, strlen(str), 2, 10, 10);

getch();

return 0;

}

-----

#include <stdio.h>

#include <conio.h>

int main(void)

{

char ch = 0;

printf("Input a string:");

while ((ch != '\r'))

{

ch = getch();

putch(ch);

}

return 0;

}

----------

#include <conio.h>

int main(void)

{

/* Display the normal cursor */

cprintf("\n\rNormal Cursor: "); getch();

/* Turn off the cursor */

_setcursortype(_NOCURSOR);

cprintf("\n\rNo Cursor : "); getch();

/* Switch to a solid cursor */

_setcursortype(_SOLIDCURSOR);

cprintf("\n\rSolid Cursor : "); getch();

/* Switch back to the normal cursor */

_setcursortype(_NORMALCURSOR);

cprintf("\n\rNormal Cursor: "); getch();

return 0;

}

------------

#include <conio.h>

int main(void)

{

int i;

clrscr();

for (i=0; i<9; i++)

{

textattr(i + ((i+1) << 4));

cprintf("This is a test\r\n");

}

return 0;

}

---------------

#include <conio.h>

int main(void)

{

textmode(BW40);

cprintf("ABC");

getch();

textmode(C40);

cprintf("ABC");

getch();

textmode(BW80);

cprintf("ABC");

getch();

textmode(C80);

cprintf("ABC");

getch();

textmode(MONO);

cprintf("ABC");

getch();

return 0;

}

-------------

#include <conio.h>

int main(void)

{

clrscr();

gotoxy(10,10);

cprintf("Current location is X: %d Y: %d\r\n", wherex(), wherey());

getch();

return 0;

}

----------The bitwise operators

Operator

Name

Description

a&b

and

1 if both bits are 1. 3 & 5 is 1.

a|b

1 if either bit is 1. 3 | 5 is 7.

a^b

xor

1 if both bits are different. 3 ^ 5 is 6.

not

This unary operator inverts the bits. If ints are stored as 32-bit integers, ~3 is 11111111111111111111111111111100.

n<<p

left shift

shifts the bits of n left p positions. Zero bits are shifted into the low-order positions. 3 << 2 is 12.

n>>p

right shift

shifts the bits of n right p positions. If n is a 2's complement signed number, the sign bit is shifted into the high-order positions. 5 >> 2 is 1.

----------

------------- Add two number without using arthi. op

#include <stdio.h>

int add(int a, int b){

if (!a) return b;

else

return add((a & b) << 1, a ^ b);

}

int main(){

int a,b;

printf("Enter the two numbers: \n");

scanf("%d",&a);

scanf("%d",&b);

printf("Sum is: %d",add(a,b));

}

--------------------

#include <iostream.h>

#include <conio.h>

int main()

{

cout << "Bit-operators example\nBy Sean Patrick Kane\nhttp://celtickane.com\n\n";

//AND operator

cout << "****AND(&)****\n";

cout << "*..A..B..A&B.*\n";

cout << "* 1 0 " << (1 & 0) << " *\n";

cout << "* 0 1 " << (0 & 1) << " *\n";

cout << "* 0 0 " << (0 & 0) << " *\n";

cout << "* 1 1 " << (1 & 1) << " *\n";

cout << "**************\n";

cout << "Hit any key to continue...\n";

getch();

//OR operator

cout << "\n****OR (|)****\n";

cout << "*..A..B..A|B.*\n";

cout << "* 1 0 " << (1 | 0) << " *\n";

cout << "* 0 1 " << (0 | 1) << " *\n";

cout << "* 0 0 " << (0 | 0) << " *\n";

cout << "* 1 1 " << (1 | 1) << " *\n";

cout << "**************\n";

cout << "Hit any key to continue...\n";

getch();

//XOR operator

cout << "\n****XOR(^)****\n";

cout << "*..A..B..A^B.*\n";

cout << "* 1 0 " << (1 ^ 0) << " *\n";

cout << "* 0 1 " << (0 ^ 1) << " *\n";

cout << "* 0 0 " << (0 ^ 0) << " *\n";

cout << "* 1 1 " << (1 ^ 1) << " *\n";

cout << "**************\n";

cout << "Hit any key to exit...\n";

getch();

return 0;

}

Excel Functions

2012-10-01T01:26:00.001-07:00

Syntax
ABS(number)
Number is the real number of which you want the absolute value

Example :-
=abs(-123)
result 123

And
Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.
=AND(A6<33,B6<33,C6<33)

if a6,b6 and c6 is less than 33 then it returns true else false

By using
if Command you can change true as good false as bad

=IF(AND(A6<33,B6<33,C6<33),"Good","Bad")

=AVERAGE(...,...,..,..)

Returns the average (arithmetic mean) of the arguments. For example, if the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

AVERAGEIF(range,criteria,average_range)
Range is one or more cells to average, including numbers or names, arrays, or references that contain numbers.
Criteria is the criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
Average_range is the actual set of cells to average. If omitted, range is used.

CONCATENATE(text1, [text2], ...)
The CONCATENATE function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

text1 Required. The first text item to be concatenated.
text2 ... Optional. Additional text items, up to a maximum of 255 items. The items must be separated by commas.
Note You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1).

COS(number)
Number is the angle in radians for which you want the cosine.

=COUNT(A1:A20)
In this example, if five of the cells in the range contain numbers, the result is 5.

COUNTIF(range, criteria)
The COUNTIF function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

range Required. One or more cells to count, including numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.
criteria Required. A number, expression, cell reference, or text string that defines which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".

FACT(number)
Number is the nonnegative number for which you want the factorial. If number is not an integer, it is truncated.

FLOOR(number,significance)
Number is the numeric value you want to round.
Significance is the multiple to which you want to round.

Creates a shortcut or jump that opens a document stored on a network server, an intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.), or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file that is stored at link_location.

Syntax
HYPERLINK(link_location,friendly_name)

LEFT(text,num_chars)
LEFTB(text,num_bytes)
Text is the text string that contains the characters you want to extract.
Num_chars specifies the number of characters you want LEFT to extract.

Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, LEFT returns all of text.
If num_chars is omitted, it is assumed to be 1.

Extract Sub Total Summery Into New Place

2012-09-26T22:22:00.001-07:00

To copy the subtotals summary:

1. Add Subtotals to the List.
2. In the Subtotal levels, click level 2.

3. Select a cell in the List, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A).

4. To select visible cells, press Alt+;.
OR
Press F5, and in the Go To dialog box, click Special. In the Go To Special dialog box, select Visible cells only and click OK.
OR
Press Select Visible Cells Icon.

5. Copy and paste the summary of the subtotals into a different sheet.

Video

If you face Still any problem write to me...

Regards

Ram Rati

Convert Number into Indian Rupees Word

2012-09-25T22:52:00.004-07:00

In MS Excel you can create your own function to create you own custom/user-define function follow the following steps

How to create a user-defined function in Excel 2007 or Excel 2010

If you know Visual Basic programming then you can create your own user-defined functions in Excel 2007 or Excel 2010. Follow the steps below:

1. Click on Excel Developer tab. If you can’t see the developer click

How to show the developer tab in excel 2007

Excel 2007 user interface does not show the developer tab in the default display. To activate or display the developer tab follow these steps:

1. Click the Microsoft Office Button.

3. 2. Click Excel Options, The options window will open.

2. On the Code group click Visual Basic.

3. You will be switched to Visual Basic Editor Menu.

4. On the Insert menu (Visual Basic Editor) select Module.

5. This will open the code window.

6. Type the Visual Basic code for your function.

7. On the File menu click Close and return to Microsoft Excel.

8. Your new function should now be ready for use like any other Excel function.

= NumbertoRupee (115) in a cell

Copy and paste the below NumbertoRupee Function in to Module1

Function NumbertoRupee(ByVal MyNumber, Optional incRupees As Boolean = True)
Dim Crores, Lakhs, Rupees, Paise, Temp
Dim DecimalPlace As Long, Count As Long
Dim myLakhs, myCrores
ReDim Place(9) As String
Place(2) = " Thousand ": Place(3) = " Million "
Place(4) = " Billion ": Place(5) = " Trillion "
' String representation of amount.
MyNumber = Trim(Str(MyNumber))
' Position of decimal place 0 if none.
DecimalPlace = InStr(MyNumber, ".")
' Convert Paise and set MyNumber to Rupees amount.
If DecimalPlace > 0 Then
Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
myCrores = MyNumber \ 10000000
myLakhs = (MyNumber - myCrores * 10000000) \ 100000
MyNumber = MyNumber - myCrores * 10000000 - myLakhs * 100000
Count = 1
Do While myCrores <> ""
Temp = GetHundreds(Right(myCrores, 3))
If Temp <> "" Then Crores = Temp & Place(Count) & Crores
If Len(myCrores) > 3 Then
myCrores = Left(myCrores, Len(myCrores) - 3)
Else
myCrores = ""
End If
Count = Count + 1
Loop
Count = 1
Do While myLakhs <> ""
Temp = GetHundreds(Right(myLakhs, 3))
If Temp <> "" Then Lakhs = Temp & Place(Count) & Lakhs
If Len(myLakhs) > 3 Then
myLakhs = Left(myLakhs, Len(myLakhs) - 3)
Else
myLakhs = ""
End If
Count = Count + 1
Loop
Count = 1
Do While MyNumber <> ""
Temp = GetHundreds(Right(MyNumber, 3))
If Temp <> "" Then Rupees = Temp & Place(Count) & Rupees
If Len(MyNumber) > 3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
MyNumber = ""
End If
Count = Count + 1
Loop
Select Case Crores
Case "": Crores = ""
Case "One": Crores = " One Crore "
Case Else: Crores = Crores & " Crores "
End Select
Select Case Lakhs
Case "": Lakhs = ""
Case "One": Lakhs = " One Lakh "
Case Else: Lakhs = Lakhs & " Lakhs "
End Select
Select Case Rupees
Case "": Rupees = "Zero "
Case "One": Rupees = "One "
Case Else:

Rupees = Rupees
End Select
Select Case Paise
Case "": Paise = " and Paise Zero Only "
Case "One": Paise = " and Paise One Only "
Case Else: Paise = " and Paise " & Paise & " Only "
End Select
SpellNumber = IIf(incRupees, "Rupees ", "") & Crores & _
Lakhs & Rupees & Paise
End Function
' Converts a number from 100-999 into text
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right("000" & MyNumber, 3)
' Convert the hundreds place.
If Mid(MyNumber, 1, 1) <> "0" Then
Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred "
End If
' Convert the tens and ones place.
If Mid(MyNumber, 2, 1) <> "0" Then
Result = Result & GetTens(Mid(MyNumber, 2))
Else
Result = Result & GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function
' Converts a number from 10 to 99 into text.
Function GetTens(TensText)
Dim Result As String
Result = "" ' Null out the temporary function value.
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19...
Select Case Val(TensText)
Case 10: Result = "Ten"
Case 11: Result = "Eleven"
Case 12: Result = "Twelve"
Case 13: Result = "Thirteen"
Case 14: Result = "Fourteen"
Case 15: Result = "Fifteen"
Case 16: Result = "Sixteen"
Case 17: Result = "Seventeen"
Case 18: Result = "Eighteen"
Case 19: Result = "Nineteen"
Case Else
End Select
Else ' If value between 20-99...
Select Case Val(Left(TensText, 1))
Case 2: Result = "Twenty "
Case 3: Result = "Thirty "
Case 4: Result = "Forty "
Case 5: Result = "Fifty "
Case 6: Result = "Sixty "
Case 7: Result = "Seventy "
Case 8: Result = "Eighty "
Case 9: Result = "Ninety "
Case Else
End Select
Result = Result & GetDigit _
(Right(TensText, 1)) ' Retrieve ones place.
End If
GetTens = Result
End Function
' Converts a number from 1 to 9 into text.
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = "One"
Case 2: GetDigit = "Two"
Case 3: GetDigit = "Three"
Case 4: GetDigit = "Four"
Case 5: GetDigit = "Five"
Case 6: GetDigit = "Six"
Case 7: GetDigit = "Seven"
Case 8: GetDigit = "Eight"
Case 9: GetDigit = "Nine"
Case Else: GetDigit = ""
End Select
End Function

Originally copied from http://www.exceldigest.com/myblog/2011/04/23/how-to-create-a-user-defined-function-in-excel-2007-or-excel-2010/