Scribd
Upload
15 views

chatgpt ai complete tutorial

The document contains various Excel tasks including creating formulas for summing values, checking pass/fail criteria based on marks, and formatting student names with titles based on gender. It also includes instructions for highlighting active cells, converting text to uppercase, and generating a structured employee data table. Additionally, there are examples of student records with their respective grades and product sales data.

Uploaded by

Shivani Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
15 views

chatgpt ai complete tutorial

The document contains various Excel tasks including creating formulas for summing values, checking pass/fail criteria based on marks, and formatting student names with titles based on gender. It also includes instructions for highlighting active cells, converting text to uppercase, and generating a structured employee data table. Additionally, there are examples of student records with their respective grades and product sales data.

Uploaded by

Shivani Sharma
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 15

1. excel sheet me b3 se f3 cells me values hain.

total karna hai formu

2. create a formula to show pass if all cells from b3 to f3 have values

3. crate a formula to remove extra spaces from cell b3 and convert in

4. agar b3 se f3 tak kisi bhi cell me marks 40 se kam hain to fail dikha

total 5 subjects hain and maximum marks 500 hain.

grade rules:
agar b3 se f3 cells ka sum >=400 hai to "A" grade dikhaye
agar b3 se f3 cells ka sum <400 and >=300 hai to "b" grade dikhaye
nhi to fir "C" grade dikha de

iska formula batao

5. excel sheet me b column me product name hain and d column me

6. excel sheet ke b3 cell me stu name hai and c3 cell me gender hai.

7. excel sheet ke a column me mughe student name enter karne hain

8. excel me active cell ko highlight karna hai yellow color se. vba cod

9. excel me jo bhi entry hum kare wo automatic uppercase me conve

10. excel table format me 50 records ka data banao jisme emp id, em

agar gender male hai to emp name me mr. add kr do agar female ha
in. total karna hai formula batao

om b3 to f3 have values grater than or equal to 40 otherwise show fail

m cell b3 and convert into uppercase.

se kam hain to fail dikhaye nahi to fir grade calculate kar de

rade dikhaye
hai to "b" grade dikhaye

e hain and d column me qty sold hain. f3 cell me hum jo product name type kare uski to

d c3 cell me gender hai. agar gender male hai to hume stu name me Mr. add karna hai a

t name enter karne hain or entries keval text ki honi chahiye. kaise karu

yellow color se. vba code chahiye

tic uppercase me convert ho jaye iske liye vba code do

banao jisme emp id, emp name, gender, department and salary columns honi chahiye.

dd kr do agar female hai to mrs. add kr do


name type kare uski total qty sold nikalni hain. formula kya hoga

e me Mr. add karna hai agar gender female hai to Mrs. add karna hai. formula kya hoga

aise karu

y columns honi chahiye.


a hai. formula kya hoga
Stu Name Hin Eng Phy Che Math Sum
Ram 34 23 54 56 45 212
anil kumar 54 43 56 76 65 294
sonu 67 45 76 78 78 344
sumit 87 65 78 98 98 426
rahul kumar 22 45 98 90 67 322
Stu Name Hin Eng Phy Che Math Fail /Pass
Ram 34 23 54 56 45 Fail
anil kumar 54 43 56 76 65 Pass
sonu 67 45 76 78 78 Pass
sumit 33 65 78 98 98 Fail
rahul 44 45 98 90 67 Pass
Stu Name Stu Name
Ram RAM
anil kumar ANIL KUMAR
sonu SONU
sumit SUMIT
rahul RAHUL
amit AMIT
anil kumar ANIL KUMAR
rahul RAHUL
Stu Name Hin Eng Phy Che Math Grade
Ram 34 23 54 56 45 Fail
anil kumar 23 43 56 76 65 Fail
sonu 67 45 76 78 78 B
sumit 87 65 78 98 98 A
rahul 22 45 98 90 67 Fail
Product I Product Region Qty Sold Product Qty Sold
P01 Mouse East 100 mouse 661
P02 Monitor West 230
P03 Printer South 120
P04 Mouse North 144
P05 Processor i4 East 50
P06 Mouse West 340
P07 Monitor South 210
P08 Monitor North 170
P09 Keyboard East 55
P10 Mouse West 77
Name Gender Stu Name
Mr. Ram Male
Mrs. Teena Female
Mr. Sonu Sharma Male
Mr. Sumit Male
Mrs. Anjali Female
Student Name

abc
E YTY

TRHR THYTRH
EW TEW

DF G

GHJ F
IUT7
HR THYTRH RTYTR6

WERYRT
EF
Emp ID Emp Name Gender
1001 Mr. John Doe Male
1002 Mrs. Jane Smith Female
1003 Mr. Michael Brown Male
1004 Mrs. Sarah Johnson Female
1005 Mr. David Williams Male
1006 Mrs. Emily Davis Female
1007 Mr. James Miller Male
1008 Mrs. Linda Wilson Female
1009 Mr. Robert Moore Male
1010 Mrs. Patricia Taylor Female
1011 Mr. Brian Anderson Male
1012 Mrs. Laura Thomas Female
1013 Mr. Kevin Jackson Male
1014 Mrs. Olivia White Female
1015 Mr. Daniel Harris Male
Department Salary
HR 45000
Marketing 50000
IT 60000
Finance 55000
Operations 48000
HR 47000
IT 65000
Marketing 53000
Sales 45000
Finance 60000
Operations 46000
IT 62000
HR 47000
Marketing 54000
Sales 4900

You might also like