English: Programming is the process of writing instructions for a computer to perform tasks.
Hindi: Programming वह प्रक्रिया है जिसमें हम कंप्यूटर को काम करने के लिए निर्देश लिखते हैं।
📌 What is C Language?
English: C is a powerful, structured, and middle-level programming language developed by Dennis Ritchie in 1972 at Bell Labs.
Hindi: C एक शक्तिशाली, structured और middle-level प्रोग्रामिंग language है, जिसे Dennis Ritchie ने 1972 में Bell Labs में बनाया था।
📌 What is C++?
English: C++ is an extension of C language with Object-Oriented Programming (OOP) features. Created by Bjarne Stroustrup in 1983.
Hindi: C++ C भाषा का बढ़ा हुआ रूप है जिसमें Object-Oriented Programming (OOP) फीचर्स जोड़े गए हैं। इसे Bjarne Stroustrup ने 1983 में बनाया।
✅ Key Difference: C vs C++
Feature
C
C++
Type
Procedural
Object-Oriented + Procedural
Approach
Function-based
Object + Function-based
Security
Less
High (Encapsulation)
OOP Support
❌ No
✅ Yes
🧠 Flowchart: Basic Program Flow
+---------+
| Start |
+---------+
|
v
+------------------+
| Input Data |
+------------------+
|
v
+------------------+
| Process (Logic) |
+------------------+
|
v
+------------------+
| Output / Result |
+------------------+
|
v
+---------+
| End |
+---------+
✅ First Program in C
#include <stdio.h>
int main() {
printf("Hello World");
return 0;
}
Output:
Hello World
✅ First Program in C++
#include <iostream>
using namespace std;
int main() {
cout << "Hello World";
return 0;
}
Output:
Hello World
📘 Explanation (English + Hindi)
#include – includes library Hindi: लाइब्रेरी जोड़ना
main() – starting point of program Hindi: प्रोग्राम यहीं से शुरू होता है
printf / cout – output function Hindi: स्क्रीन पर मैसेज दिखाता है
📝 Exercises / अभ्यास
✅ Task-1
Write a program to print:
My Name
My College
My Course
Hindi: एक प्रोग्राम लिखिए जो आपका नाम, कॉलेज और कोर्स दिखाए।
✅ Task-2
Draw a flowchart for “ATM Cash Withdrawal”.
Hindi: ATM से पैसे निकालने का फ्लोचार्ट बनाइए।
✅ Task-3
Difference between C and C++ (5 points)
Hindi: C और C++ में 5 अंतर लिखिए।
✨ Ready for Next Chapter?
Available Chapters:
✅ Introduction
Variables & Data Types
Input / Output
Operators
Conditions & Branching
Loops
Functions
Arrays
Pointer vs Reference
Strings
Structures vs Classes
Object-Oriented Concepts (for C++)
💬 Tell me:
Reply with the next chapter number: 2️⃣ Variables & Data Types? or another?
Also tell me — do you want a PDF version at the end? I can make it printable with diagrams.
You said:
Also tell me — do you want a PDF version at the end?
ChatGPT said:
Yes — when we finish the notes, I can generate a complete PDF for you ✅ With:
Topic-wise notes (English + Hindi)
Flowcharts & diagrams
Programs & explanations
Practice exercises + MCQs
Clean printable formatting
📂 You will get:
C notes PDF
C++ notes PDF
Combined C & C++ Notebook PDF (if you want)
Just keep saying Next chapter and we will build it step-by-step 👇 Would you like:
Separate PDFs (C one & C++ one) or
Single combined PDF for both C & C++?
Tell me the option number, and I will continue with Chapter-2: Variables & Data Types. 💪📘
📘 Chapter-2: Variables & Data Types
✅ What is a Variable?
English: A variable is a container used to store data in memory.
Hindi: Variable एक container होता है जिसमें हम memory में data store करते हैं।
✅ Rules for Naming Variables
English
Must start with a letter or underscore _
No spaces allowed
No special characters except _
Case-sensitive (age ≠ Age)
Can’t use keywords (like int, float, etc.)
Hindi
Variable नाम letter या _ से शुरू होना चाहिए
Space नहीं होना चाहिए
Special characters नहीं होंगे (@,#,% etc.)
Capital & small अलग माने जाते हैं
Keywords variable नाम नहीं हो सकते
✅ Example Variable Declarations
C Language
int age = 20;
float marks = 85.5;
char grade = 'A';
C++ Language
int age = 20;
float marks = 85.5;
char grade = 'A';
string name = "Rahul";
🧠 Flowchart: Using a Variable
+---------+
| Start |
+---------+
|
v
+-------------+
| Declare Var |
+-------------+
|
v
+-------------+
| Assign Data |
+-------------+
|
v
+-------------+
| Use/Display |
+-------------+
|
v
+---------+
| End |
+---------+
✅ What are Data Types?
English: Data types define the type of data stored in a variable.
Hindi: Data type यह बताता है कि variable में किस प्रकार का data store होगा।
#include <iostream>
using namespace std;
int main() {
int age = 21;
double salary = 15000.75;
char grade = 'A';
string name = "Rohan";
cout << "Name = " << name << endl;
cout << "Age = " << age << endl;
cout << "Salary = " << salary << endl;
cout << "Grade = " << grade;
return 0;
}
🏋️♂️ Practice Exercises / अभ्यास
✍️ Q1:
Declare variables for:
Student name
Roll number
Marks
Grade
(C & C++ both)
✍️ Q2:
Write a program to input age & print:
You are eligible for vote
If age >= 18
✍️ Q3:
Make a flowchart to enter 2 numbers and display their sum.
✅ Mini Quiz
1) Which of these is a valid variable?
a) 2num b) _roll ✅ c) my-name
2) char stores? a) Words b) Decimal numbers c) Single character ✅
🎯 Output practice task
Write a program to print this:
My name is Rahul
I am 20 years old
My grade is A
📩 Next?
Reply with the chapter number:
3️⃣ Input & Output or Tell me “PDF later, continue notes”
Your learning pace is strong — keep it up 💪📘
📘 Chapter 3: Input / Output (I/O)
(English + Hindi)
✅ What is Input?
English: Input means taking information from the user.
Hindi: Input का मतलब है यूज़र से जानकारी लेना।
✅ What is Output?
English: Output means displaying information/results to the user.
Hindi: Output का मतलब है यूज़र को जानकारी/परिणाम दिखाना।
✅ Input / Output in C
📌 Header File
#include <stdio.h>
📌 Output Function
printf("message");
📌 Input Function
scanf("%d", &variable);
📍 Example (C) — Input 2 Numbers & Print Sum
#include <stdio.h>
int main() {
int a, b, sum;
printf("Enter first number: ");
scanf("%d", &a);
printf("Enter second number: ");
scanf("%d", &b);
sum = a + b;
printf("Sum = %d", sum);
return 0;
}
✅ Input / Output in C++
📌 Header File
#include <iostream>
using namespace std;
📌 Output Function
cout << "message";
📌 Input Function
cin >> variable;
📍 Example (C++) — Input 2 Numbers & Print Sum
#include <iostream>
using namespace std;
int main() {
int a, b, sum;
cout << "Enter first number: ";
cin >> a;
cout << "Enter second number: ";
cin >> b;
sum = a + b;
cout << "Sum = " << sum;
return 0;
}
🧠 Flowchart: Input & Output
+---------+
| Start |
+---------+
|
v
+----------------+
| Take Input A,B |
+----------------+
|
v
+---------------+
| Calculate A+B |
+---------------+
|
v
+-------------+
| Display Sum |
+-------------+
|
v
+---------+
| End |
+---------+
🎯 Format Specifiers (C Language)
Data Type
Format Specifier
Example
int
%d
10
float
%f
20.5
char
%c
‘A’
string
%s
“Rahul”
📝 Practice Tasks
✅ Task-1
Take input: Name, Age, City And print:
Hello <Name>, Age: <Age>, City: <City>
✅ Task-2
Write C & C++ program to input 3 numbers and print average.
✅ Task-3
Flowchart to enter marks and show pass/fail. (Passing marks > 40)
✨ Mini MCQ Quiz
Which is input in C++? a) printf b) cout c) cin ✅
%d is used for: a) decimal number ✅ b) string c) character
📦 Next Chapter?
Reply with chapter:
4️⃣ Operators 5️⃣ Conditions (if-else) 6️⃣ Loops
Or say “Continue all chapters one by one” ✅
And yes — PDF will be prepared at the end 📕💯
📘 Chapter-4: Operators (C & C++)
(English + Hindi + Programs + Practice)
✅ What is an Operator?
English: Operators are symbols used to perform operations on values and variables.
Hindi: Operators वे symbols होते हैं जिनका उपयोग गणना/कार्य करने के लिए किया जाता है।
✅ Types of Operators
Type
Meaning
Example
Arithmetic
Maths operations
+ - * / %
Relational
Comparison
> < >= <= == !=
Logical
True/False logic
`&&
Assignment
Assign value
= += -= *= /=
Increment / Decrement
Increase / Decrease
++ --
Conditional
Ternary operator
?:
Bitwise
Bit operations
`&
✨ 1) Arithmetic Operators (गणितीय ऑपरेटर)
Operator
Meaning
Example
+
Addition
a + b
-
Subtraction
a - b
*
Multiplication
a * b
/
Division
a / b
%
Modulus (Remainder)
a % b
📍 Example (C / C++ Same Logic)
int a = 10, b = 3;
printf("%d", a % b); // Output: 1
int a = 10, b = 3;
cout << a % b; // Output: 1
✨ 2) Relational Operators (तुलना करने वाले)
Operator
Meaning
Example
==
Equal to
a == b
!=
Not equal
a != b
>
Greater
a > b
<
Less
a < b
>=
Greater or equal
a >= b
<=
Less or equal
a <= b
✨ 3) Logical Operators (तर्क वाले)
Operator
Meaning
Example
&&
AND
(a>5 && b<10)
`
`
!
NOT
!(a>b)
✨ 4) Increment / Decrement
Operator
Meaning
++
Increase value by 1
--
Decrease value by 1
Example:
int x = 5;
x++; // 6
🧠 Flowchart: Operator Usage
Start
↓
Enter A, B
↓
Perform A+B
↓
Display Result
↓
End
✅ Example Program (C)
#include <stdio.h>
int main() {
int a = 10, b = 3;
printf("Addition = %d\n", a + b);
printf("Subtraction = %d\n", a - b);
printf("Multiplication = %d\n", a * b);
printf("Division = %d\n", a / b);
printf("Modulus = %d\n", a % b);
return 0;
}
✅ Example Program (C++)
#include <iostream>
using namespace std;
int main() {
int a = 10, b = 3;
cout << "Addition = " << a + b << endl;
cout << "Subtraction = " << a - b << endl;
cout << "Multiplication = " << a * b << endl;
cout << "Division = " << a / b << endl;
cout << "Modulus = " << a % b << endl;
return 0;
}
📝 Exercises / अभ्यास
1️⃣ Input two numbers and perform all arithmetic operations 2️⃣ Check if number > 18 (true/false) 3️⃣ Find remainder when number is divided by 5 4️⃣ Use ++ and — on a variable and print results 5️⃣ Write a flowchart for simple calculator
🎯 MCQ
% operator gives: a) Division b) Remainder ✅ c) Multiplication
== checks: a) Equal ✅ b) Assignment c) Address
🚀 Next Chapter?
Tell me to continue to:
5️⃣ Conditions (if-else) or just say “Next”
Also — someone studying like this is serious. Keep going 👏🔥 We’ll create the PDF after finishing all chapters.
📘 Chapter-5: Conditional Statements
✅ Why Conditions?
English: Conditions allow a program to take decisions — run different code based on true/false.
Hindi: Conditions से प्रोग्राम निर्णय लेता है — यानी स्थिति के अनुसार अलग-अलग कोड चलता है।
✅ Types of Conditional Statements
Statement
Meaning
if
Executes code if condition true
if-else
True → run one block, False → second block
else if
Multiple conditions
switch
Menu-based multi-choice
✨ if Statement
SYNTA X
if(condition) {
// code
}
Example
Check if age ≥ 18
✅ C Program
#include <stdio.h>
int main() {
int age;
printf("Enter age: ");
scanf("%d", &age);
if(age >= 18) {
printf("Eligible for vote");
}
return 0;
}
✅ C++ Program
#include <iostream>
using namespace std;
int main() {
int age;
cout << "Enter age: ";
cin >> age;
if(age >= 18) {
cout << "Eligible for vote";
}
return 0;
}
#include <iostream>
using namespace std;
int main() {
for(int i=1; i<=5; i++) {
cout << i << endl;
}
return 0;
}
2️⃣ while Loop
Example: Print 1 to 5
C / C++
int i = 1;
while(i <= 5) {
printf("%d\n", i);
i++;
}
3️⃣ do-while Loop
Example: Print 1 to 5
int i = 1;
do {
printf("%d\n", i);
i++;
} while(i <= 5);
✅ Runs once even if condition false.
🧠 Flowchart: for Loop (1-5)
Start
↓
i = 1
↓
Is i <= 5?
→ Yes → Print i → i = i+1 → repeat
→ No → End
⭐ Common Loop Examples
💡 Sum of 1 to N
int n, sum=0;
cin >> n;
for(int i=1; i<=n; i++) {
sum += i;
}
cout << sum;
💡 Print Multiplication Table
int n;
cin >> n;
for(int i=1; i<=10; i++) {
cout << n << " x " << i << " = " << n*i << endl;
}
💡 Factorial of Number
int n, fact=1;
cin >> n;
for(int i=1; i<=n; i++) {
fact *= i;
}
cout << fact;
⚠️ Infinite Loop
while(1) {
// endless loop
}
🎯 Loop Uses in Real Life
Counting marks
Repeating menu in ATM
Printing bill items
Games: repeat turns
📝 Exercises
1️⃣ Print 1 to 100 2️⃣ Print all even numbers 1-50 3️⃣ Print table of 15 4️⃣ Display sum of digits of a number 5️⃣ Find factorial of a number 6️⃣ Print this pattern:
1️⃣ Write a function to find square of a number 2️⃣ Create a function that prints your name 3️⃣ Create a function to check even or odd 4️⃣ Make a function to find factorial 5️⃣ Make a calculator using 4 functions: add, subtract, multiply, divide
🎯 MCQ Test
Function that returns nothing a) int b) float c) void ✅
Function parameters are written in a) main() b) function definition ✅ c) printf
🎓 Tip
If a task repeats → Use a Function
🚀 Next Chapter:
Reply Next for:
8️⃣ Arrays in C & C++
We’re progressing like a proper textbook ✅ At the end, you will get your full printable PDF 📕💯
📘 What is an Array?
English: An array is a collection of multiple values of the same data type stored in a single variable.
Hindi: Array एक ऐसा variable है जिसमें एक ही प्रकार के कई मान (values) store किये जाते हैं।
✅ Why use Arrays? / Arrays क्यों?
Reason
English
Hindi
Saves memory
One variable stores many values
एक variable में कई values
Easy access
Index through values
Index द्वारा values मिलती हैं
Better management
Avoids many variables
कई variables बनाने की ज़रूरत नहीं
✅ Array Declaration
Syntax
dataType arrayName[size];
Example
int marks[5];
Means: 5 integers stored
✅ Initialize Array
C / C++
int marks[5] = {80, 75, 92, 60, 85};
✅ Access Array Elements
printf("%d", marks[0]); // first element
Index starts from 0
Index
Value
0
80
1
75
2
92
3
60
4
85
🧠 Flowchart Logic — Print Array
Start
↓
Declare array
↓
Set i = 0
↓
i < size?
→ Yes: print value[i], i++
→ No: End
✅ Program: Print Array (C)
#include <stdio.h>
int main() {
int marks[5] = {80, 75, 92, 60, 85};
for(int i = 0; i < 5; i++) {
printf("%d\n", marks[i]);
}
return 0;
}
✅ Program: Print Array (C++)
#include <iostream>
using namespace std;
int main() {
int marks[5] = {80, 75, 92, 60, 85};
for(int i = 0; i < 5; i++) {
cout << marks[i] << endl;
}
return 0;
}
⭐ Input Array from User
C
int arr[5];
for(int i=0; i<5; i++) {
scanf("%d", &arr[i]);
}
int arr[5] = {1,2,3,4,5}, sum=0;
for(int i=0;i<5;i++){
sum += arr[i];
}
cout << sum;
🧠 2D Array (Matrix)
C++ Example
int a[2][2] = {{1,2},{3,4}};
cout << a[1][1]; // 4
💡 Real-Life Use
Real world
Code
Student marks list
marks[]
Shopping cart
items[]
ATM pin digits
pin[]
📝 Exercises
1️⃣ Create array of 10 numbers & print 2️⃣ Find sum of 5 numbers 3️⃣ Find largest number in array 4️⃣ Input 5 marks and find average 5️⃣ Make 3×3 matrix & print values
🎯 MCQ
Array index starts from? a) 1 b) 0 ✅ c) -1
int a[5] stores: a) 5 integers ✅ b) 4 integers c) Infinite integers
🔥 Tip
Use array when you need same type of data stored in group
🚀 Next Chapter?
Say Next for:
9️⃣ Pointers vs References (C & C++)
You’re doing an excellent consistent learning job 🙌 We are building a full professional textbook — PDF coming after final chapter ⭐
📘 Pointers & References
✅ What is a Pointer?
English: A pointer is a variable that stores the memory address of another variable.
Hindi: Pointer एक variable है जो किसी दूसरे variable का memory address store करता है।
✅ Why use pointers?
Reason
English
Hindi
Direct memory access
Faster performance
Memory पर direct काम
Pass by reference
Efficient function calls
Function में data copy नहीं
Dynamic memory
malloc / new
Memory control
✅ Declaring Pointer
Syntax
int *ptr;
Example
int a = 10;
int *p = &a;
Symbol
Meaning
*
Pointer variable
&
Address operator
✅ Memory Concept Diagram
Variable: a = 10
Address : 1001
Pointer p = &a → stores address 1001
*p gives value → 10
✅ C Program: Pointer
#include <stdio.h>
int main() {
int a = 10;
int *p = &a;
printf("Value = %d\n", a);
printf("Address = %p\n", p);
printf("Value using pointer = %d\n", *p);
return 0;
}
✅ Pointer in C++
#include <iostream>
using namespace std;
int main() {
int a = 10;
int *p = &a;
cout << "Value = " << a << endl;
cout << "Address = " << p << endl;
cout << "Value using pointer = " << *p;
return 0;
}
🌟 Pointer & Function
void change(int *x){
*x = 50;
}
int main(){
int a = 10;
change(&a);
cout << a; // Output: 50
}
✅ What is Reference? (C++ Only)
English: Reference is an alias (another name) for a variable.
Hindi: Reference variable किसी variable का दूसरा नाम होता है।
Syntax
int a = 10;
int &r = a;
Now r and a both refer to same memory.
✅ Example: Reference
int a = 10;
int &b = a;
b = 20;
cout << a; // Output: 20
⭐ Pointer vs Reference
Feature
Pointer
Reference
Syntax
int *p
int &r
Null allowed?
Yes
No
Reassign later?
Yes
No
Used in C?
✅
❌
Used in C++?
✅
✅
🧠 Flowchart – Pointer Concept
Start
↓
Declare variable a
↓
Pointer p = &a
↓
Use *p to access value
↓
End
📝 Practice Tasks
1️⃣ Declare int pointer & print address and value 2️⃣ Create pointer to float 3️⃣ Swap 2 numbers using pointers 4️⃣ Write C++ program using reference 5️⃣ Pointer arithmetic: increment pointer
🎯 MCQ Test
Question
Answer
Pointer stores?
Address ✅
& means?
Address of variable ✅
Reference in C?
No ❌
✨ Tip
Pointers = Memory boss References = Alias / shortcut name
🚀 Next Chapter?
Say Next for:
🔟 Strings in C & C++ (very important)
We’re going strong 💪 After final chapters → Full PDF + Workbook + Tests ✅
📘 What is a String?
English: A string is a sequence of characters.
Hindi: String characters (letters, digits, symbols) का समूह होता है।
Examples: "Hello", "India", "IISDVT2025"
✅ Strings in C
🔹 C strings are character arrays
char name[20] = "Rahul";
OR
char name[20] = {'R','a','h','u','l','\0'};
\0 = Null character (string terminator)
✅ Input & Output in C
#include <stdio.h>
int main() {
char name[30];
printf("Enter your name: ");
scanf("%s", name); // stops at space
printf("Hello %s", name);
return 0;
}
✅ Accept string with spaces (C)
gets(name); // NOT recommended (unsafe)
fgets(name, 30, stdin); // best method
1️⃣ Create structure Employee with name, id, salary 2️⃣ Take user input for 3 students & print 3️⃣ Create class Car with model, year, show() method 4️⃣ Compare structure & class (10 points) 5️⃣ Make class with input() & output() methods
🎯 Mini MCQ
Question
Answer
Class default access
private ✅
Structure stores?
Multiple data types ✅
OOP supported in structure?
❌
💡 Tip
Structure = data only Class = data + functions (OOP)
After this chapter: 📕 Full PDF + Word File 🏁 Practice Sheets ✅ Viva Questions 🎯 Project Assignments 📂 Printable Notes Version
📘 Chapter-12: Object-Oriented Programming (OOP) in C++
✅ What is OOP?
English: OOP (Object-Oriented Programming) is a programming style based on objects that contain data & functions.
Hindi: OOP एक प्रोग्रामिंग तरीका है जिसमें प्रोग्राम objects के रूप में बनाया जाता है — जिनमें data और functions दोनों होते हैं।
🎯 4 Pillars of OOP
Concept
Meaning
Hindi
Encapsulation
Bundle data + functions
Data को सुरक्षित बांधना
Inheritance
Derive new class from old
गुणों का विरासत में मिलना
Polymorphism
One name, many forms
एक नाम, कई रूप
Abstraction
Hide complexity
केवल ज़रूरी चीजें दिखाना
✅ 1. Encapsulation
Data + functions inside a class Data security using private members
Example
#include<iostream>
using namespace std;
class Student {
private:
int marks;
public:
void setMarks(int m) { marks = m; }
int getMarks() { return marks; }
};
int main() {
Student s;
s.setMarks(90);
cout << s.getMarks();
}
✅ 2. Inheritance
Parent → Child
Types of Inheritance
Single
Multi-level
Multiple
Hierarchical
Hybrid
Example (Single Inheritance)
class A {
public:
void showA(){ cout<<"Class A\n"; }
};
class B : public A {
public:
void showB(){ cout<<"Class B"; }
};
int main(){
B obj;
obj.showA();
obj.showB();
}
✅ 3. Polymorphism
Same function name → different behavior
Types
Compile-time (Function Overloading)
Run-time (Function Overriding)
Function Overloading
class Test {
public:
void sum(int a,int b){ cout<<a+b; }
void sum(float a,float b){ cout<<a+b; }
};
Function Overriding
class A { public: void show(){ cout<<"A"; } };
class B: public A { public: void show(){ cout<<"B"; } };
✅ 4. Abstraction
Show only necessary details Hide complex details
Example: ATM You see options → internal code hidden
Example
class Car {
public:
void startEngine(){ cout<<"Engine Started"; }
private:
void fuelPump(){ }
};
🌟 Object and Class Example
class Student {
public:
string name;
void intro() { cout << "My name is " << name; }
};
int main() {
Student s;
s.name = "Amit";
s.intro();
}
🧠 OOP Real-Life Example
Real World
OOP
Car
Class
Specific car
Object
Car functions
Methods
Keys lock car
Encapsulation
Driver uses only steering
Abstraction
📊 Flowchart — OOP Object Creation
Start
↓
Define Class
↓
Create Object
↓
Call Methods
↓
End
🎯 Exercises
1️⃣ Create a class Bank with deposit & withdraw 2️⃣ Create Teacher (base) & SubjectTeacher (derived) 3️⃣ Function overloading: sum of 2 & 3 numbers 4️⃣ Create class Laptop → brand, price, show() 5️⃣ Create ATM program using OOP concepts
🧪 MCQ Quiz
Question
Answer
OOP is based on?
Objects ✅
Default access in class
Private ✅
Inheritance meaning
properties transfer ✅
Encapsulation means
data hiding ✅
🎓 Chapter Completed!
✅ You have finished all core C & C++ topics 🔥 Excellent consistency — I’m impressed
गिनेगा कि कितने सेल खाली नहीं हैं (Text+Number दोनों)
A1 से A10 तक कितने सेल भरे हैं
=IF(A1>50,"Pass","Fail")
शर्त (Condition) लगाने के लिए
अगर A1 का मान 50 से बड़ा है तो “Pass” वरना “Fail”
=ROUND(A1,2)
दशमलव (Decimal) को Round करेगा
A1 को 2 दशमलव तक गोल कर देगा
=LEN(A1)
शब्द/अक्षर की गिनती करता है
A1 सेल में कितने अक्षर हैं
=CONCATENATE(A1," ",B1) या =A1&" "&B1
दो या अधिक सेल जोड़ना (Text Join)
A1 और B1 के टेक्स्ट को जोड़ना
=LEFT(A1,5)
बाएँ से 5 अक्षर दिखाएगा
“ExcelFormula” → “Excel”
=RIGHT(A1,3)
दाएँ से 3 अक्षर दिखाएगा
“ExcelFormula” → “ula”
=PROPER(A1)
हर शब्द का पहला अक्षर बड़ा करेगा
“my name” → “My Name”
=UPPER(A1)
सारे अक्षर बड़े (Capital) करेगा
“excel” → “EXCEL”
=LOWER(A1)
सारे अक्षर छोटे करेगा
“EXCEL” → “excel”
=NOW()
वर्तमान तारीख और समय दिखाएगा
अभी की तारीख+समय
=TODAY()
केवल आज की तारीख दिखाएगा
03-10-2025
हिंदी में आसान समझ
SUM = जोड़ना
AVERAGE = औसत निकालना
MAX = सबसे बड़ी संख्या
MIN = सबसे छोटी संख्या
IF = शर्त लगाना
LEN = अक्षर/संख्या गिनना
UPPER/LOWER = अक्षर बड़े/छोटे करना
TODAY/NOW = आज की तारीख और समय
Excel Formula की कैटेगरी (श्रेणियाँ)
Excel के Formula मुख्य रूप से इन 10 बड़ी श्रेणियों में बाँटे जाते हैं:
Mathematical & Trigonometric (गणित और त्रिकोणमिति) – SUM, PRODUCT, ROUND, SIN, COS आदि
Statistical (सांख्यिकी) – AVERAGE, MEDIAN, MODE, STDEV, VAR आदि
Logical (तार्किक) – IF, AND, OR, NOT, IFERROR आदि
Text (पाठ्य/टेक्स्ट) – LEN, LEFT, RIGHT, MID, TRIM, CONCATENATE, REPLACE, SUBSTITUTE आदि
Date & Time (तारीख और समय) – TODAY, NOW, DAY, MONTH, YEAR, EOMONTH, NETWORKDAYS आदि
Lookup & Reference (खोज और संदर्भ) – VLOOKUP, HLOOKUP, XLOOKUP, MATCH, INDEX, CHOOSE आदि
Financial (वित्तीय) – PMT, NPV, IRR, FV, PV, RATE आदि
Engineering (अभियांत्रिकी) – BIN2DEC, HEX2DEC, COMPLEX आदि
Information (जानकारी) – ISNUMBER, ISTEXT, ISBLANK, TYPE, INFO आदि
Database (डेटाबेस) – DCOUNT, DSUM, DAVERAGE आदि
Excel में Operator (ऑपरेटर) किसे कहते हैं?
👉 Operator वे चिन्ह (Symbols) होते हैं जिनका उपयोग हम गणना (Calculation), तुलना (Comparison) और लॉजिकल ऑपरेशन करने के लिए करते हैं। जैसे कि + , - , * , / , > , < , = आदि।
🔹 Excel में Operators के प्रकार
1. Arithmetic Operators (गणितीय ऑपरेटर)
संख्या पर जोड़, घटाना, गुणा, भाग करने के लिए।
Operator
काम (हिंदी में)
उदाहरण
+
जोड़ (Addition)
=10+5 → 15
-
घटाना (Subtraction)
=10-5 → 5
*
गुणा (Multiplication)
=10*5 → 50
/
भाग (Division)
=10/5 → 2
^
घात (Power)
=2^3 → 8
%
प्रतिशत (Percentage)
=50%*200 → 100
2. Comparison Operators (तुलना करने वाले)
दो मानों की तुलना करने के लिए।
Operator
काम (हिंदी में)
उदाहरण
=
बराबर (Equal to)
=A1=10
>
बड़ा (Greater than)
=A1>10
<
छोटा (Less than)
=A1<10
>=
बड़ा या बराबर
=A1>=10
<=
छोटा या बराबर
=A1<=10
<>
बराबर नहीं (Not Equal)
=A1<>10
3. Text Concatenation Operator (टेक्स्ट जोड़ने वाला)
टेक्स्ट या शब्दों को जोड़ने के लिए।
Operator
काम
उदाहरण
&
दो टेक्स्ट जोड़ना
="Ram"&" " & "Shyam" → “Ram Shyam”
4. Reference Operators (संदर्भ ऑपरेटर)
Operator
काम
उदाहरण
:
रेंज (Range)
A1:A10 मतलब A1 से A10 तक
,
एक से अधिक रेफरेंस (Union)
=SUM(A1:A5, C1:C5)
(Space)
समान मान वाले (Intersection)
=SUM(A1:A10 B1:B10)
Excel Formulas in Hindi (सभी श्रेणियों के साथ)
🔹 1. Math & Trigonometry (गणित व त्रिकोणमिति)आपके द्वारा दिए गए स्प्रेडशीट फ़ार्मुलों (Spreadsheet Formulas) की सूची बहुत व्यापक और उपयोगी है! ये फ़ॉर्मूले डेटा विश्लेषण और गणना के लिए बहुत महत्वपूर्ण हैं।
यहाँ आपके द्वारा प्रस्तुत जानकारी का एक व्यवस्थित और संक्षिप्त पुनरीक्षण है, जिसमें प्रमुख फ़ॉर्मूला श्रेणियाँ और उनके कार्य शामिल हैं:
स्प्रेडशीट फ़ॉर्मूला श्रेणियाँ और उनके कार्य
1. Math & Trigonometry (गणित व त्रिकोणमिति) 📐
ये फ़ॉर्मूले बुनियादी अंकगणित (basic arithmetic) और त्रिकोणमितीय गणनाओं (trigonometric calculations) के लिए उपयोग किए जाते हैं।
Formula
काम (Hindi)
Example
=SUM( )
जोड़ करना (Adding)
A1 से A5 तक का जोड़
=PRODUCT( )
गुणनफल (Multiplying)
सभी मानों का गुणनफल
=ROUND( )
संख्या को राउंड करना
12.35
=ABS( )
Absolute Value (धनात्मक मान)
45
=POWER( )
घात (Power)
8
=SIN( ) / =COS( ) / =TAN( )
साइन, कॉस, टैन θ
0.5 / 0.5 / 1
2. Statistical (सांख्यिकी) 📊
डेटा के सेट का विश्लेषण (analysis) करने और उसके प्रमुख गुणों को निर्धारित करने के लिए।
Formula
काम (Hindi)
Example
=AVERAGE( )
औसत (Mean)
A1 से A5 का औसत
=MEDIAN( )
माध्यिका (Median)
मध्य मान
=MODE( )
सबसे बार आने वाला मान (Most Frequent)
A1 से A5 में सबसे अधिक बारंबारता वाला मान
=STDEV( )
मानक विचलन (Standard Deviation)
डेटा के फैलाव का माप
=PERCENTILE( )
प्रतिशतक (Percentile)
0.9 वें प्रतिशतक का मान
3. Logical (तार्किक) 🧠
ये फ़ॉर्मूले शर्तों (conditions) के आधार पर निर्णय लेने और परिणाम देने के लिए महत्वपूर्ण हैं।
Formula
काम (Hindi)
Example
=IF( )
शर्त अनुसार परिणाम (Conditional Result)
A1>50 होने पर “Pass”, अन्यथा “Fail”
=AND( ) / =OR( )
दोनों/कोई भी सत्य हों
एकाधिक शर्तों का परीक्षण
=NOT( )
उल्टा परिणाम (Inverse Result)
शर्त का विपरीत मान
=IFERROR( )
त्रुटि पकड़े (Error Handling)
गणना में त्रुटि होने पर
=IFS( )
कई शर्तें (Multiple Conditions)
नेस्टेड IF की जगह
4. Text (टेक्स्ट) 📝
टेक्स्ट डेटा में हेरफेर (manipulation), फॉर्मेटिंग और स्ट्रिंग ऑपरेशन (string operations) के लिए।
Formula
काम (Hindi)
Example
=LEN( )
अक्षरों की संख्या (Length)
स्ट्रिंग में वर्णों की गिनती
=LEFT( ) / =RIGHT( ) / =MID( )
बाईं/दाईं/बीच से अक्षर निकालना
स्ट्रिंग को उप-भागों में विभाजित करना
=TRIM( )
अतिरिक्त स्पेस हटाना
अनावश्यक रिक्त स्थान हटाता है
=UPPER( ) / =LOWER( ) / =PROPER( )
टेक्स्ट केस बदलना
“EXCEL”, “excel”, “Ram Kumar”
=CONCAT( )
टेक्स्ट जोड़ना (Concatenate)
दो या दो से अधिक स्ट्रिंग को मिलाना
5. Date & Time (तारीख व समय) 📅
समय-आधारित गणनाओं और तारीखों से जानकारी निकालने के लिए।
Formula
काम (Hindi)
Example
=TODAY( ) / =NOW( )
आज की तारीख / वर्तमान तारीख व समय
डायनामिक तारीख और समय
=DAY( ) / =MONTH( ) / =YEAR( )
तारीख के भाग निकालना
दिन, महीना, या साल
=EOMONTH( )
महीने का अंतिम दिन
एक निश्चित महीने का अंतिम दिन
=NETWORKDAYS( )
कार्य दिवस (Working Days)
दो तारीखों के बीच कार्य दिवसों की संख्या
6. Lookup & Reference (खोज व संदर्भ) 🔍
बड़े डेटासेट से विशिष्ट मानों को खोजने (finding values) और संदर्भित (referencing) करने के लिए।
Formula
काम (Hindi)
Example
=VLOOKUP( ) / =HLOOKUP( )
वर्टिकल / हॉरिजॉन्टल खोज
डेटा के लंबवत या क्षैतिज रूप से खोज
=XLOOKUP( )
नई खोज विधि
VLOOKUP और HLOOKUP का उन्नत विकल्प
=MATCH( )
स्थान पता करना (Find Position)
एक रेंज में किसी मान की सापेक्ष स्थिति
=INDEX( )
मान निकालना (Extract Value)
एक निश्चित पंक्ति और स्तंभ संख्या से मान
=OFFSET( )
सेल रेफरेंस शिफ्ट
एक बेस सेल से दूर एक रेंज बनाना
7. Financial (वित्तीय) 💰
लोन (loan), निवेश (investment), और मूल्यह्रास (depreciation) जैसी वित्तीय गणनाओं के लिए।
Formula
काम (Hindi)
Example
=PMT( )
लोन EMI
मासिक किस्त की गणना
=FV( ) / =PV( )
भविष्य/वर्तमान मूल्य (Future/Present Value)
निवेश का मूल्य
=IRR( ) / =NPV( )
आंतरिक रिटर्न / शुद्ध वर्तमान मूल्य
प्रोजेक्ट के लाभ की गणना
=SLN( ) / =DDB( )
मूल्यह्रास (Depreciation)
संपत्ति के मूल्य में कमी की गणना
8. Engineering (अभियांत्रिकी) ⚙️
ये फ़ॉर्मूले मुख्य रूप से संख्या प्रणालियों (Number Systems) के बीच रूपांतरण (conversion) के लिए उपयोग किए जाते हैं, जैसे कि बाइनरी, दशमलव, हेक्साडेसिमल, और ऑक्टल। इनका उपयोग जटिल संख्याओं (Complex Numbers) को संभालने के लिए भी किया जाता है।
Formula
काम (Hindi)
Example
=BIN2DEC( )
बाइनरी → दशमलव (Binary to Decimal)
1010→10
=DEC2BIN( )
दशमलव → बाइनरी (Decimal to Binary)
10→1010
=HEX2OCT( )
हेक्सा → ऑक्टल (Hexadecimal to Octal)
“2F”→57 (मान लीजिए)
=COMPLEX( )
कॉम्प्लेक्स नंबर बनाना
3,4,”i”→3+4i
Export to Sheets
9. Information (जानकारी) 💡
ये फ़ॉर्मूले सेल (cell) के कंटेंट और फ़ॉर्मेट के बारे में जानकारी प्राप्त करने के लिए उपयोग किए जाते हैं। इनका उपयोग अक्सर यह जाँचने के लिए किया जाता है कि कोई मान किसी विशिष्ट शर्त को पूरा करता है या नहीं (जैसे: यह संख्या है, टेक्स्ट है, या त्रुटि है)।
Formula
काम (Hindi)
Example
=ISNUMBER( )
संख्या है या नहीं (Is it a Number?)
TRUE/FALSE
=ISTEXT( )
टेक्स्ट है या नहीं (Is it Text?)
TRUE/FALSE
=ISERROR( )
Error है या नहीं (Is there an Error?)
TRUE/FALSE
=ISBLANK( )
खाली है या नहीं (Is it Blank?)
TRUE/FALSE
=TYPE( )
Data Type पता करना
1 (संख्या), 2 (टेक्स्ट) आदि
=INFO( )
सिस्टम जानकारी
“osversion”, “recalc” आदि
Export to Sheets
10. Database (डेटाबेस) 🗃️
ये फ़ॉर्मूले एक डेटाबेस रेंज (Database Range) पर काम करते हैं, जहाँ यह गणना करने से पहले शर्तों (Criteria) का उपयोग करके डेटा को फ़िल्टर करते हैं। यह SUMIF या AVERAGEIF का एक अधिक उन्नत रूप है, जो कई कॉलम और शर्तों पर काम करता है। इन्हें आमतौर पर D-Functions कहा जाता है।
Formula
काम (Hindi)
Example
=DCOUNT( )
गिनती (Count)
शर्तों को पूरा करने वाली प्रविष्टियों की गिनती
=DSUM( )
जोड़ (Sum)
शर्तों को पूरा करने वाले मानों का जोड़
=DAVERAGE( )
औसत (Average)
शर्तों को पूरा करने वाले मानों का औसत
=DMAX( ) / =DMIN( )
अधिकतम/न्यूनतम (Max/Min)
शर्तों को पूरा करने वाले मानों में सबसे बड़ा/छोटा मान
Export to Sheets
11. Dynamic Array Functions (नए) 🆕
ये नए फ़ॉर्मूले हैं जो एक साथ कई मानों (multiple values) को लौटाते हैं, जिससे जटिल डेटा हेरफेर आसान हो जाता है।
Greeting someone depends on the age, relation and position of the person
Good manners
How to greet people
Good morning! How are you? I’m fine, thanks. How are you?
formal
Hello! How are you doing? Fine, just fine. How are you?
informal
Hi, how is it going? Pretty good. How about you?
informal
Hi, what’s up? Not much. What about you?
informal
What have you been up to? The same as usual.
informal
How to thank people
1. Thank you for looking after my son.
You’re very welcome.
2. Thanks for your help.
No problem.
3. Thank you for carrying my bag.
Don’t mention it.
4. That’s very kind of you but you really shouldn’t have gone to
all this trouble.
I was happy to help.
you shouldn’t have gone to all this trouble — a standard phrase
you say to someone who has done much work for you
How to say sorry
1. Sorry to have kept you waiting.
That’s ok.
2. Sorry I’m late.
No problem. I’ve only just got here myself.
3. I’m sorry about reading your messages.
Don’t let it happen again.
don’t let it happen again — a standard phrase you say to somebody
who has really upset you meaning “I hope you won’t do this again”
भाई और बहन के बीच बातचीत (Conversation between Brother and Sister)
शिक्षक और छात्र के बीच बातचीत (Conversation between Teacher and Student)
How to ask people to do something for you
1. Could you open the window, please?
Sure.
2. Could you make me a cup of tea, please?
Yes, of course.
3. Could you give me his phone number, please?
I’m sorry but I don’t know his number.
4. Could you look after my son tonight?
I’m afraid I can’t. I’m working an evening shift today.
5. Do you mind moving your seat so that I and my friend could
sit together?
No, of course not.
(* positive answer)
6. Do you mind lending me some money?
I’m sorry, I’m broke.
(* negative answer)
shift work — the time period during which you are at work
to be broke — to have no money
How to offer people help
1. My flight arrives at 7 am.
Would you like me to meet you at the airport?
2. My car is broken, so I came to work by underground today.
Do you want me to give you a lift home?
3. The suitcase is so heavy.
Let me carry it for you!
4. What do these statistics mean?
Let me explain.
to give a lift — to take someone somewhere in your car
How to ask for permission to do something
1. Can I switch the TV on?
Sure, go ahead.
(* positive answer)
2. Can I read this e-mail?
No, I’m afraid not.
(* negative answer)
3. Do you mind if I sit here?
No, of course not.
(* positive answer)
4. Do you mind if I borrow your car tomorrow?
Yes, I’m afraid I do.
(* negative answer)
to borrow — to use another person’s thing and give it back later
How to suggest somebody an idea
1. It’s hot in here.
Let’s open the window.
Okay.
2. Let’s ask your mum to look after Johnny while we are away.
I’d rather not.
3. How about going there by train?
Sounds good!
4. How about painting the walls blue?
It doesn’t sound very good.
5. Why don’t we go to the beach?
Good idea!
6. Why don’t you get a new hairstyle?
I don’t feel like it.
How to agree and disagree with your companion
1. Kevin is musically gifted.
That’s true!
2. I think Martin Freeman is a brilliant actor!
Absolutely!
3. The facts, he gave us, are convincing.
I can’t see that!
4. He is an honest man.
I don’t think so!
gifted — talented
convincing — making you believe that something is true
How to give and accept a compliment
1. Your cake is really delicious!
I’m glad you like it!
2. You look gorgeous in this outfit. You have a great fashion
sense!
That’s very kind of you to say so.
3. Your presentation was great!
Thank you. I really needed that.
gorgeous — beautiful
an outfit — a set of clothes that you wear together
fashion sense — understanding what clothes look good
How to sympathize
1. Jill has had a heart attack! She’s just been taken to hospital!
How awful/terrible!
2. My back kills me!
I’m sorry to hear this!
3. I’ve lost one of my gloves.
What a shame!
4. I spent half an hour looking for my car key! It was so
frustrating!
I can imagine!
When I got to my car, I saw I had a flat tyre.
Oh, no!
frustrating — making you feel annoyed
a flat tyre — when there’s little air in the tyre
How to ask to repeat and check understanding
1. Are you following me?
No, you’ve lost me. Could you explain that again, please?
2. Are you with me?
Sorry, what was that again?
3. Am I making sense?
Could you explain that another way/just one more time, please?
to make sense — to be easy to understand
How to finish a conversation and say good-bye
1. It was nice to talk to you but I’ve got to go now.
You too. See you around.
2. It was great to see you, but I must dash now.
It was good to see you too. Take care.
3. I should get going.
Ok. See you later.
4. I’m running terribly late!
Ok. See you around.
5. I hope we meet again soon.
Yes, let’s keep in touch.
to dash — to go quickly because you’re in a hurry
to keep in touch — to write or call each other from time to time
How to introduce yourself
1. Great party, isn’t it?
Yeah. It’s cool.
I’m Ruth.
I’m Julia. Nice to meet you.
You too.
2. Hi, I’m Kevin.
Hi, Kevin! I’m David. Nice to meet you.
You too, David. So, how do you know the host? (at a party)
I and Daniel work together. What about you?
I live next door.
a host — a person who invites guests to his/her home
next door — a house next to yours
How to introduce people
1. Laura, meet Seon! Seon, this is Laura!
Nice to meet you, Seon.
You too, Laura!
2. James, this is Chris. Chris, this is James.
Nice to meet you, James!
You too, Chris. I’ve heard a lot about you!
All good, I hope.
How to welcome a new employee
1. Hi, I’m Claire.
Nice to meet you. I’m Robert.
You too. Are you new here?
Yes, it’s my first day here.
2. You must be Susan.
Yes, right.
I’m Jill. Nice to meet you, Susan. Let me show you around.
Nice to meet you too, Jill. Thank you.
3. Hello, Jake. Welcome to the Nesco Company. Let me
introduce you to some people.
Thank you, that would be nice.
4. Hi, I’m Jeff. Are you new here?
Yes, I’m Alex. I’m a new paralegal.
Where will you be working?
On the seventh floor.
We’ll be seeing a lot of each other then.
to show you around — to show you a place (an office or home)
to introduce — to tell someone another person’s name when they
see each other for the first time
a paralegal — someone who has legal training and helps a lawyer
Нow to make an invitation
1. Would you like to come to my birthday party?
I’d love to! What time is your party?
5 pm.
I’ll be there. Thanks!
2. Would you like to come over for dinner tonight?
That would be lovely but I’ve got a previous arrangement.
What a shame!
I would love to come another time!
3. I’d love it if you could come to stay but do you mind dogs?
No, of course not. Thank you for inviting me.
a previous arrangement — a plan you had made before you were
invited
How to welcome guests
1. Hi, come in!
Hi! Nice to see you!
I’m glad you could make it.
Thank you for asking me.
2. Hi, come in.
Nice to see you! You look wonderful!
Thank you! It’s a pleasure to have you here.
I’m very glad I came.
3. Nice to have you here.
I’m glad I could come.
How was your journey?
I hit a traffic jam but quite smooth after all.
to make it — to manage to get somewhere
to hit a traffic jam — to drive up the road that is busy with other
drivers
smooth — without problems
How to compliment your host on their home
1. You’ve got a lovely house.
Thank you. Let me show you around.
2. Come into the living room and have a seat.
Your living-room is very beautiful!
3. Make yourself comfortable.
Thank you!
How to offer guests a drink
1. Would you like a drink?
Yes, please. What have you got?
2. Can I get you something to drink?
Yes, please. I’d like a cup of tea.
3. How do you take your coffee?
Two sugars, no milk, please.
How to offer food to your guests
1. Help yourself to the cookies.
Thank you! They are delicious.
2. Please, go ahead with the salad, I’ll bring the lamb in red wine
in a minute.
Sounds delicious!
3. Can I get anyone anything?
No, thanks. We are full. The meal was delicious.
4. Are you done?
Yes, thank you. It was delicious.
help yourself — used to offer food and drink
delicious — tasty
to go ahead — to continue to do something
Are you done? — Have you finished with you meal?
How to thank your host for hospitality
1. Thank you for having us.
We are glad you could come. I hope you have a safe journey.
2. Thank you for inviting us. We had a great time.
Come back again. It was good to see you.
How to ask somebody out on a date
1. What are you up to today?
Nothing really. Why?
Would you like to go to the cinema tonight?
Yeah, what’s on?
2. I was thinking… Do you want to meet up for a drink some
time?
Sounds good!
What about tomorrow evening?
I am busy this week maybe next week some time?
3. I was wondering if you would have dinner with me?
Dinner? Why not? When?
How about tonight?
Sorry, I can’t make it tonight.
Can you make it tomorrow then?
Yes, tomorrow is fine.
I can’t make it tonight — I can not meet you tonight
How to refuse a date
1. Would you like to go out some time?
That’s nice of you, but I’m already seeing someone.
2. What are you doing this weekend?
I am going to my parents’ place. Why?
I just thought we could grab a coffee sometime.
No, sorry. You’re a nice guy, but I’m just not into you in that way.
to see someone — to be in a romantic relationship with someone
to be into someone — to be interested in someone
How to ask a stranger out on a date
1. I’ve just moved here. Are there any good cafés in the area?
There’s a good Chinese place near here.
Would you like to join me for dinner there sometime?
I’m not sure. I don’t even know you.
Right, but you seem like a really nice person and I want to get to
know you better.
2. I just saw you and I think you look really nice.
Thank you.
What are you doing right now?
Just taking a walk.
Then why don’t we have a coffee over here.
3. I want to tell you that you look very pretty and I want to get to
know you.
Thank you.
Can you give me your number so I can call you sometime?
Okay.
4. I enjoyed talking to you and would like to get to know you
better. If you feel the same, here’s my number.
I’ll call you.
to get to know — to know somebody better
How to make small talk
1. Nice day, isn’t it.
Yeah, it’s lovely outside.
2. It looks like it’s going to snow.
I hear they are calling for snow all weekend.
3. I can’t believe how quiet this place is today.
Strange, isn’t it? It’s usually packed on Fridays.
4. Can you believe all this rain we’ve been having?
Yes, we sure have!
5. I love your outfit! May I ask where you got it?
Thank you. I got it at Zara.
6. Getting excited about your trip?
Yeah, I’m really looking forward to it.
to call for snow — to say that it will snow
packed — having a lot of people
excited — very happy
to look forward to — to feel happy about something that is going to
happen
How to avoid answering a question
1. How much do you earn?
I’d rather not say.
2. I’ve heard you’ve split up with Christy.
If it’s okay with you, I’m not really up to talking about it.
How to make an appointment
1. Can we meet on the 16th of July?
Yes, it’s fine with me.
2. Can you make it on Friday morning?
Yes, it suits me perfectly.
3. Are you available on Thursday evening?
I’m afraid I can’t make it on Thursday evening. What about a bit
earlier on Thursday? Say, 3 pm?
4. What about Saturday?
I’m afraid I can’t on Saturday. Can we meet on Sunday instead?
to make it on Friday — to be available on Friday
How to change an appointment
1. We were going to meet on Friday but something has come up.
Can we fix another time?
Sure. Would Monday be ok?
2. I’m afraid, I won’t be able to meet you after all. Can we make
another time later in the week?
Ok. What time is best for you?
to come up — if a problem comes up, you need to deal with it
immediately
How to ask if a shop sells an item you need
1. Hello! Have you got souvenir mugs?
Yes, we have them here.
2. Have you got umbrellas?
Yes. I’ll show you. Are you looking for men’s or ladies’ umbrellas?
A ladies’ one.
How to buy things
1. Can I have this calendar, please?
Here you are/There you go.
2. How much is it?
It’s 10 pounds.
3. Can I have a carton of milk and a loaf of bread, please?
Here you are/There you go. That’s 4 euros.
4. Can I have a box of tissues, please?
I’m sorry, we are out of tissues.
5. I’m looking for a dishwasher.
Freestanding or built-in?
6. I’m looking for a pair of shoes to go with this dress.
How about these ones?
7. I’d like to buy a gift card, please?
How much do you want to put on it?
8. I’d like a new SIM card for my phone.
What’s your phone model?
9. Can I help you?
No, I am just looking around.
Just let me know if you need anything.
here you are/there you go — said when you give something to
someone
we are out of tissues — we have no more tissues in stock
How to book a flight
1. What flights are there to Oslo?
There are two flights tomorrow. One is at 7.30 am and the other one
is at 4 pm.
2. Are there any direct flights to Dallas?
No, you’ll have to transfer either in Chicago or Kansas City.
3. I’d like to book a flight to Beijing, please.
What date will you be travelling?
The 19th of March.
There is a flight at 5. 20 am. Would you like to be booked on it?
Yes, please.
to transfer — to change a plane
How to change a flight reservation
1. I’d like to change my flight reservation.
Ok. What’s your booking number?
2. What would you like to change?
I’d like to take an earlier flight if possible.
3. I’m booked on flight number XPL on April 12. Can I change
this to a later date, please?
What date would you like to depart?
4. Will I have to pay a change fee?
Yes, because you booked a flight over 24 hours ago.
a fee — money you pay for service
How to check-in
1. Can I see your passport and tickets, please?
Here you are.
I’m afraid, your flight has been delayed. It’s now scheduled to
depart at 4.30 pm.
2. Would you like an aisle or a window seat?
A window seat, please.
to be delayed — to be later than planned
to be scheduled — to be planned at a particular time
to depart — to leave
an aisle seat — a seat near the passage between rows
How to rent a car
1. I’d like to rent a car.
For how long?
For 3 days.
2. What type of car would you like?
I’d like a midsize car. How much would it cost?
30 dollars per day.
3. Would you like insurance on your car?
Yes, please.
How many people are going to drive?
Just myself.
4. Can I see your driver’s licence?
Will my international licence do?
5. Do I have to return a car to this location?
No, you can leave it at any of our locations. Remember to return it by
2 am on Wednesday.
How much would you charge me if I’m an hour late?
an insurance — an agreement in which you pay a company money
and they pay your costs if you have an accident.
to charge — to ask to pay money
How to rent a flat
1. I’m calling about the flat for rent. Is it still available?
Yes, it is.
Can I see it today?
2. How much is the rent?
It’s 1200 dollars per month.
Are the utilities included?
No, you’ll have to pay them yourself.
3. When is the rent due?
On the first of each month. It’s paid in advance.
4. Will the rent go up?
Not until the end of the lease. When your lease expires the rent may
go up.
5. How much is the security deposit?
It’s a month’s rent.
6. Can I sublet?
Yes, you can but you must get written permission from us first.
7. How much notice do I need to give if I want to leave early?
You need to give a month’s notice.
8. Who do I contact if there is a problem?
Me. Here is my phone number.
9. When will the flat be available?
Next month.
We need to think about it. Can we call you tonight?
Sure.
the rent is due — must be paid
in advance — before a particular time
a (rental) lease — a rental contract
to expire — to come to end
a security deposit — money you pay when you start to rent a flat
and which is given back to you when you stop renting it
utilities — gas, water, electricity
to sublet — to rent out the flat or part of the flat that you are renting
permission — when you allow somebody to do something
to give notice — to inform someone of something
How to ask for a bill
1. Can I have the bill, please?
Coming right up.
2. We’d like separate bills, please.
Sure.
How to say that the bill is incorrect
1. I’m afraid there is a mistake in the bill. I didn’t order the
milkshake.
I’m sorry. I’ll bring you the correct bill right away.
2. I’m afraid there is a mistake in the bill. You charged me twice
for the dessert.
I’m sorry, Mam. I’ll bring you the correct bill right away
How to talk about problems with equipment
1. The washing machine isn’t working.
Do you know what’s wrong with it?
2. The remote control isn’t working.
The batteries might have run out.
3. Is the printer broken?
No, it’s not. It’s just has run out of paper. Let me refill it for you.
4. My lock is broken. The key doesn’t turn.
You should call the locksmith.
a remote control — a thing you use to switch on and off TV from a
short distance away
to run out — to finish
to refill — to put something into a container again
a lock — a part of a door you put your key in to open or close it
a locksmith — a person who fixes locks
How to talk about household appliance problems
1. The kettle doesn’t seem to be working.
It could be the cable. Is it plugged in properly?
2. The tap in the kitchen is dripping.
I’ll send the plumber in right now.
3. One of my burners won’t light.
It can be clogged. Just clean it.
4. The bulb is blown.
I’ll replace it right now.
a kettle — a container you use for boiling water
to plug in — to connect a piece of equipment to an electricity supply
a tap — a thing in the bathroom or kitchen where water comes out of
to drip — when water falls in small drops
a burner — a part of a cooker that you heat pans on
to be clogged — to become blocked so that nothing can go through
it
a bulb — an object in a lamp that gives light
How to report an emergency
1. There is a robbery in progress in the neighbour’s home.
What’s the address?
2. There is a fight in progress outside the bar.
Hold on. I’ll get the police dispatched.
3. There’s a car accident.
Is anyone hurt?
The driver of one of the cars.
4. There’s a car accident.
How many cars/people are involved?
Two cars.
Is anybody trapped inside the cars?
One man is.
The ambulance is on the way.
What should we do until they arrive?
5. We are stuck in the lift/elevator.
Do you know the address where you are at?
Yes, it’s…
The rescue team will be there in 15 minutes.
6. My house is on fire.
The fire crew is on its way.
7. My house is flooding.
Have you got a burst pipe?
8. Someone is breaking into my house.
I already have the police coming.
a robbery — stealing something using force
dispatched — sent
a crew — a group of people working together
to flood — to become covered with water
to burst — to break because there is too much air inside
a pipe — a tube that carries water
to break into a house — to get into somebody’s house illegally
How to report a crime at the police station
1. I’d like to report a crime.
Can you tell me what happened?
My bag has been stolen.
2. I’ve been attacked.
When and where did it happen?
3. I’d like to report a break-in.
Was anything stolen?
a break-in — when someone illegally gets into your house or your
car
How to give a reason for your call
Can I speak to someone from the HR department? Can I ask what’s it in connection with? I’m calling about applying for the job of a sales representative. I’ll connect you to the person in charge of it. to remind — to make somebody remember something to suggest — to give someone an idea to think about to apply for — to officially ask for a job to be in charge of — to have control over somethin
Hi, Brian. How are you doing? Fine. And you? I’m good. What can I do for you? I’m calling to remind you of our dinner plans.
Hi, Rita! What can I do for you? You suggested I call you to discuss a few ideas. I am calling to let you know I’m interested.