EXCEL|USEFULL|ABOUT EXCEL|FORMULA|BY RITU RAJ KUMAR

 

EXCEL IS THE PART OF MISCROSOFT WORD IN WHICH ANYLIZE YOUR DATA,DATA PROCESSING.

HOW TO OPEN EXCEL

START BUTTON PRESS- TYPE EXCEL- THEN ENTER PRESS

 

EXCEL

FORMULA

FUNCTIONS

FORMATINGS

 

FORMULA

ADDITION(+)

 

=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12+A13

THEN ENTER

=SUM(A1:A13)

DOUBLE CLICK ON SUM (AUTO SUM)ON HOME TABE RIGHT CORNOR….

ALT+==

SUBTRACTION(-)

 

MULTIPLICATION(*)

SINGLE TYPE

DIVISION

 

FIND OUT LCM

6,8,4

=LCM(SELECT ALL RANGE)

FIND OUT THE MAXIMUM VALUE FROM THE RECORDS

=MAX(SELECT RANGE)

CREATE DATA

=MIN(SELECT RANGE)

=MODE(SELECT RANGE)

=SQRT(SELECT RANGE ANY ONE) SQUARE FIND

CONVERT NUMBER TO ROMAN NUMBER

10-X

1000-M

=ROMAN(SELECT RANGE)

FIND OUT AVERAGE

=AVERAGE(SELECT RANGE)

 

TEXT AND DATEDIF

C:\Users\RITURAJ KUMAR\Desktop\excel & advance excel\ADD,SUB,MULT,DIV.xlsx

CHAR FORMULA USE TO WRITE DOWN IN EXCEL A TO Z CAPTIAL LETTER AND ALSO SMALL LETTER

=CHAR(A1) R-A 65/90

=CHAR(B1) R-a 97/122

Emp name	sales
A	60
b	5
c	40
d	2
e	11
f	90
g	25
h	7

 Find out the largest 3^rd rank of the emp

=large(b2:b9,3)

Find out the smallest 4^th rank of the emp.

=small(b2:b9,4)

Title bar

Menu bar

Ribbon(hide ribbon press( ctrl+1))

Formula bar

How to sheet hide and unhide

How to hide column and unhide column

How to hide row and unhide rows

Ctrl+0

Ctrl+shift+9

 

Status bar ?

Task bar?

Cell?

Row?

Column?

Gridlines?

Row-10,48,576

Column-16384(a-xfd)

 1.Used  for see the current row postions

=row()

2.find out the current column postion

=column()

3.used for insert the auto numbering in row waise

S no

=rows($a$2:a2)

 

4.used for insert the auto numbering in column waise

S no	=columns($B$1:B1)

 

5.COUNT THE RECORDS

ANY DATA

8

5

6

5

7

 

=COUNT(A1:A10)

6.COUNT THE RECORDS TEXT

SONU

ANIL

MONU

 

=COUNTA(B1:B5)

7.COUNT THE BLANK AREA FROM THE RECORDS

=COUNTNLANK(A1:A9)

8.COUNT THE TEXT LENGTHS

=LEN(A1)

RAJ KUMAR

 

 9.INSERT CURRENT DATE

CTRL+;

=TODAY()

10.INSERT TIME

CTRL+:

=NOW()

11.DATA VERIFY

=EXACT(A1,B1)-FALSE

=EXACT(A2,B2)-TRUE

D FUNCTION

D SUM,AVEARGE,MAX,MIN,COUNT,PRODUCT

=DSUM(DATABASE,CERTIA,FIELD)

 

COVERT SMALL TO CAPITAL LETTER

=UPPER(A1)

CONVERT CAPITAL TO SMALL LETTER

=LOWER(B1)

CONVERT ANY TEXT FROM CAPITAL +SMALL TO SENTENCE CASE

=PROPER(A1)

CUSTOM

SUMIF WITH FUNCTIONS

 

 

 

 

 

 

F1 TO F12 |FUNCTION KEY|BY RITU RAJ KUMAR

 

F1 T

O F12

F1-UDED FOR HIDE AND SHOW THE RIBBON IN MICROSOFT WORD

START---WINDOW---ENTER----CTRL+F1

 

F2—USED FOR CHANGE THE NAME OF FILE AND FOLDER

SELECT FILE—F2---TYPE NEW NAME—ENTER

----USED FOR MODIFY THE DATA OR VALUE IN EXCEL

START---EXCEL—ENTER—TYPE ANY TEXT—SELECT—F2—MODIFY

---USED FOR INSERT THE COMMENTS IN EXCEL

START—EXCEL—ENTER—TYPE ANY TEXT---SELECT—SHIFT+F2—TYPE ANY INFOR

 

F3—USED FOR CHANGE THE TEXT CASE(UPER/LOWER/PROPER) IN MICROSOFT WORD

---START—WINWORD—ENTER—TYPE ANY TEXT—SELECT—SHIFT+F3

 

F4—USED FOR CLOSE THE PROGRAM

START—WORDPAD—ENTER—ALT+F4

 

F5—USED FOR SHORTKEY OF REFRESH COMMAND(F5)

---USED FOR INSERT THE DATE AND TIME IN NOTPAD

--START—NOTPAD—ENTER—F5

--USED FOR SEE THE PAGE ON FULL SCREEN IN POWERPOINT

--START—POWERPOINT—ENTER—TYPE ANY TEXT—F5

 

F6—USED FOR GO TO ADDRESS BAR IN ANY BROWSER

(INTERNET EXPLORER,MOZILA FIREFOX,GOOGLE CHROME)

 

F7—USED FOR CHECK THE SPELLING & GRAMMAR IN MICROSOFT WORD

 

 

START—WINWORD—ENTER-TYPE ANY TEXT)

I am going to markete

BLUE UNDERLINE-GRA-IS WRONG

RED UNDERLINE-SPELLING IS WRONG

--USED FOR SEE THE SYNONYM & ANTONYM OF WORDS IN MICROSOFT WORD

--START—WINWORD—ENTER—TYPE—Man—SELECT-SHIFT+F7

 

 

F8--USED FOR OPEN THE MACROS IN MICROSOFT WORD

--START—WINWORD—ENTER—ALT+F8

--SELECT ANY WORD SENTENCE,PARAGRAPH,SELECT ALL IN IN MICROSOFT WORD

TRICK =rand() enter

F9—USED FOR INSERT THE MIDDLE BRACKET IN MICROSOFT WORD

START—WINWORD—ENTER-CTRL+F9{ }

F10-USED FOR SORT KEY OF RESTOR & MAXIMIZE IN MICROSOFT WORD

START—WINWORD—ENTER—CTRL+F10

F11—USED FOR INSERT THE SHEET IN MICROSOFT -EXCEL

--USED FOR MAKE THE CHART ON GRAPH IN MICROSOFT –EXCEL

 

F12—USED FOR SORT KEY OF SAVE AS COMMAND IN MICROSOFT—EXCEL

START-WINWORD—ENTER –TYPE AND TEXT F12 –FILE –SAVE

BY-RITU RAJ KUMAR

 

 

 

 

EXAM DATE FOR B A HONS ENGLISH| SEM 2| TENTITVE DATE

 

22 MAY 2024(WED)2924001205-FAMILY BUSINESS MANAGEMENT TIME-2:30 PM TO 5:30 PM

27 MAY 2024(MONDAY)-2032101201- 14TH TO 17TH CENTUARY ENGLISH POETRY ,TIME-9:00AM TO 12:00 NOON

31 MAY 2024(FRIDAY)-2032101202-16TH TO 17TH CENTUARY ENLISH DARMA,TIME-9:00 AM TO 12:00 NOON

6TH JUNE 2024(THURSDAY) -2032101203-18 TH CENTUARY, TIME-9:00 AM TO 12:00 NOON

11 TH JUNE 2024( TUESDAY)-2051001003-SOCIAL MEDIA AUR BLOG LEKHAN-TIME-9:00 AM TO 11:00 AM

14 TH JUNE 2024(FRIDAY)-2416001002-FINANCE TO EVERYONE,TIME -9:00 AM TO 11:30 AM

19 TH JUNE 2024(WEDNESDAY) -6967001022-BHARTIYA PARAMPARA AUR MANAV MOOLAY,TIME 9:00 AM TO 11:00 AM

19 JUNE 2024(WEDNESDAY)-6967001002-CONSTITUTIONAL VALUE ANDS FUNDAMENTAL DUTIES- TIME 9:00 AM TO 11:00 AM

19 JUNE 2024(WEDNESDAY)-6967001014-READING INDIAN FICTION IN ENGLISH ,TIME- 9:00 AM TO 11:00 AM

14 JUNE 2024(FRIDAY)-2036000002-COMMUNICATION IN EVERYDAY LIFE ,TIME-9:00 AM TO 11:30 AM

14 JUNE 2024(FRIDAY)-2056000002-RANGMACH-TIME-9:00 AM TO 11:30 AM

exam datesheethttps://web.sol.du.ac.in/info/tentative---academic-calendar-for-undergraduate-programmes-for-the-academic-year-2023-24

THANKS 

SUBJECT- BCHCT CODE 131|BACHELOR OF SCIENCE (GENERAL) (BSCG) Term-End Examination June, 2022|QUESTION PAPER PREVIOUS YEAR|BY RITU RAJ KUMAR

 BCHCT-131 : ATOMIC STRUCTURE, BONDING, GENERAL ORGANIC CHEMISTRY AND ALIPHATIC HYDROCARBONS

 Time : 2 hours Maximum Marks : 50 

Note : (i) Attempt any five questions from Part A and any five questions from Part B on separate answer sheets. (ii) All questions carry equal marks.

 PART A (Maximum Marks : 25)

1. (a) Discuss the contribution of Rutherford in explaining the structure of an atom. 3 (b) Which of the following molecules has a dipole moment, CH4 or NH3 ? Give reason. 1 (c) Name the force by which the molecules are held together in the crystal structure of a compound.

2. (a) Why is oxygen paramagnetic ? Explain using molecular orbital theory.

 3 (b) State the type of hybridisation present in benzene and SF4 molecules. 2

 3. (a) Write the steps used in valence bond method to arrive at the structure of a molecule.

 3 (b) Classify the following statements as true or false. Also give reason in support of your answer. 2

 (i) Ionisation energy of sodium is less than that of magnesium. 

 (ii) First ionisation energy of magnesium is more than its second ionisation energy.

 4. (a) Write all steps to obtain the Lewis structure of CO2 . 3

 (b) Briefly explain the photoelectric effect. How did Einstein explain it ? 2 

5. Name the four quantum numbers of an electron and give their significance. What is Pauli’s Exclusion Principle ? 5

. 6. (a) Explain the difference between a covalent and a coordinate covalent bond with a suitable example. 3 (b) Write the electronic configurations of Cr (At. No. = 24) and Ag (At. No. = 47). 2 7. (a) Explain the significance of  and  2 . 

(b) Give the characteristics of a well-behaved wave function. Draw a suitable diagram for the well-behaved wave function. 3 

 PART B (Maximum Marks : 25) 

8. (a) What is the product of Kolbe’s electrolysis of sodium acetate ? Write the reaction and its mechanism. 3

 (b) How will you convert 2-pentyne to cis and trans-2-pentene ? 2 

9. (a) Write the products of oxidative ozonolysis of 2-methyl-2-butene. 2 

(b) Arrange the following compounds in the increasing order of their acidity and give reason for answer : 3 CH3CHCH2COOH, CH3CH2CHCOOH, | | Cl Cl ClCH2CH2CH2COOH 

10. (a) Which one of the following compounds will exibit optical activity and why ? OH 

| (i) CH3CHCOOH (ii) HOOC(CH2 ) 2COOH Draw two Fischer projections of compound (i). 3 

(b) How will you prepare 1-hexyne from ethyne ? 2

 11. What are electrophiles and nucleophiles ? Give one example each of

 (i) a neutral electrophile

, (ii) a neutral nucleophile, and

 (iii) a charged electrophile. 5

 12. (a) Explain Saytzeff’s rule with the help of a suitable example. 3 

(b) Write the products formed by the reaction of HBr and propene when

 (i) no peroxide is present, and (ii) in the presence of peroxide. 2

 13. (a) Draw the conformations of cyclohexane. Comment on their relative stabilities. 3 

(b) How are straight chain alkanes converted to branched chain alkanes ? What is the importance of this reaction ?

UNIT 2 MOST IMPORTANT QUESTION IN EXAM| BA HONS ENGLISH

 1. Swift is usually charged with being a misanthrope. Does your reading of Gulliver’s Travels justify this? 2. Can we read Book 1 of Gulliver‘s Travels without being conscious of the satire? Give reasons in support of your answer. 3. Which episodes in Book I of Gulliver’s Travels make you feel that the book is a satire rather than merely an adventure story? Give reasons in support of your answer. 4. Describe the picture of Brobdingnagian society as given by Swift in Book II of Gulliver’s Travels. What evils of contemporary society was it designed to expose? 5. What are the objects of Swift’s satire in Gulliver’s Travels Book I and II? 6. “Swift’s picture of Brobdingnagian society is not merely a piece of satire but also a vision of society as he would like it to be.” Discuss.

7. Examine the complex use of irony that Swift makes in Gulliver’s Travels Book I and II. 8. “The Voyage to Lilliput” is the neatest and most diverting of the four voyages . . . It holds our interest chiefly as imaginative narrative.” Discuss. 9. “Though Gulliver makes the error of identifying himself and the other human beings completely with the Yahoos, we and Swift do not.” Do you agree with this view? Give a reasoned answer. 10. Bring out the significance of Gulliver’s voyage to the country of the Houyhnhnms in terms of irony and satire. 11. Bring out the significance of Gulliver’s voyage to Laputa. 12. Comment of the narrative technique of Swift in Book I and II of Gulliver’s Travels. What does Swift achieve by this technique. 13. In Gulliver’s Travels Swift holds up a mirror to human defects and depravity. Elaborate. 14. Beneath the comic storyline of Gulliver’s Travels lies the savage satire of Swift. Illustrate with examples.