MS-EXCEL

PRACTICAL FILE
Student Name : Shivansh Goel
Enrolment No. : 04317788821

28-02-2022 BCom(H) IT Practical File- BCom 113 1

 P#1: Steps to apply nested sort

28-02-2022 BCom(H) IT Practical File- BCom 113 2

 Step 1: Select the data to sort → Then go to Data Tab
→ Click on Sort option

28-02-2022 BCom(H) IT Practical File- BCom 113 3

 Step 2: Pop up will appear → Select the column in
Sort by option and the order of sorting → To add
nested sorting click on Add Level option → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 4

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 5

 P#2: Steps to set word wrap and merge &
center

28-02-2022 BCom(H) IT Practical File- BCom 113 6

 Step 1: Select the cells to word wrap and merge → Right
Click the mouse → Click on Format Cells option

28-02-2022 BCom(H) IT Practical File- BCom 113 7

 Step 2: Pop up will appear → Choose the desired
alignment → Click the Wrap text and Merge cells
option → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 8

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 9

 P#3: Steps to set conditional formatting on
Text and on Numbers

28-02-2022 BCom(H) IT Practical File- BCom 113 10

 Step 1: Select the Data for Conditional Formatting →
Go to Home Tab → Click on Conditional Formatting
option→ Choose the desired formatting

28-02-2022 BCom(H) IT Practical File- BCom 113 11

 Step 2: Pop up will appear → Set the desired rule →
Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 12

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 13

 P#4: Steps to set Filters on Data sheet

28-02-2022 BCom(H) IT Practical File- BCom 113 14

 Step 1: Select the data to filter → Go to Data Tab →
Click on Filter option

28-02-2022 BCom(H) IT Practical File- BCom 113 15

 RESUL
T

28-02-2022 BCom(H) IT Practical File- BCom 113 16

P#5: Steps to remove duplicate values from list

28-02-2022 BCom(H) IT Practical File- BCom 113 17

 Step 1: Select the data from which to remoce duplicates → Go to
Data Tab → Click on Remove Duplicates option

28-02-2022 BCom(H) IT Practical File- BCom 113 18

 Step 2: Pop up will appear → Select from which to
remove duplicates → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 19

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 20

P#6: Steps to convert text number as numerical
or number

28-02-2022 BCom(H) IT Practical File- BCom 113 21

 Step 1: Select the data to convert → Go to Home Tab
→ Click on the list in Number section

28-02-2022 BCom(H) IT Practical File- BCom 113 22

 Step 2: From the list, select the Number option

28-02-2022 BCom(H) IT Practical File- BCom 113 23

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 24

 P#7: Steps to set Paste special as value and
transpose the data

28-02-2022 BCom(H) IT Practical File- BCom 113 25

 Step 1: Select the data to transpose → Copy the data

28-02-2022 BCom(H) IT Practical File- BCom 113 26

 Step 2: Select the place where to transpose → Go to
Home Tab → Click on Paste option → Then click on
Paste Special option→→

28-02-2022 BCom(H) IT Practical File- BCom 113 27

 Step 3: Pop up will appear → Select Values option →
Choose Transpose option → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 28

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 29

 P#8: Steps to set Text orientation of cell

28-02-2022 BCom(H) IT Practical File- BCom 113 30

 Step 1: Select the cell of which to change orientation →
Go to Home Tab → Click on Orientation option in
Alignment section

28-02-2022 BCom(H) IT Practical File- BCom 113 31

 Step 2: Change orientation according to need

28-02-2022 BCom(H) IT Practical File- BCom 113 32

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 33

P#9: Steps to apply IF Condition and Nested IF
Condition

28-02-2022 BCom(H) IT Practical File- BCom 113 34

 Step 1: To apply IF condition → Select where to show
the answer → Use IF function

28-02-2022 BCom(H) IT Practical File- BCom 113 35

 Step 2: First type the desired logic test → Then type
the answer if the condition is true → Type the answer if
the condition is false

28-02-2022 BCom(H) IT Practical File- BCom 113 36

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 37

 Step 1: In case of Nested IF condition instead of
writing false condition, we add more IF condition by
repeatedly using IF function

28-02-2022 BCom(H) IT Practical File- BCom 113 38

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 39

 P#10: Steps to apply Subtotal Option

28-02-2022 BCom(H) IT Practical File- BCom 113 40

 Step 1: Select the cell where to show Subtotal → Use Subtotal
function → First type the number for desired function

28-02-2022 BCom(H) IT Practical File- BCom 113 41

 Step 2: Then select the range or numbers for subtotal

28-02-2022 BCom(H) IT Practical File- BCom 113 42

 RESUL
T

28-02-2022 BCom(H) IT Practical File- BCom 113 43

 P#11: Steps to create duplicate sheet within
same workbook and outside another workbook

28-02-2022 BCom(H) IT Practical File- BCom 113 44

 Step 1: Right Click on Sheet which to duplicate →
Click on Move or Copy option

28-02-2022 BCom(H) IT Practical File- BCom 113 45

Step 2: Pop up will appear → Select Create a
copy option → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 46

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 47

 Step 1: In case of duplicating to new Workbook → In
Pop up, Select new book option in To book menu

28-02-2022 BCom(H) IT Practical File- BCom 113 48

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 49

P#12: Steps to set Page Break Preview, Header
Row and Freeze Panes

28-02-2022 BCom(H) IT Practical File- BCom 113 50

 Step 1: Go to View Tab → Click on Page Break
Preview option

28-02-2022 BCom(H) IT Practical File- BCom 113 51

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 52

 Step 1: Go to Page Layout Tab → Click on Print
Titles option

28-02-2022 BCom(H) IT Practical File- BCom 113 53

 Step 2: Pop up will appear → In Rows to repeat at
top option → Select the row to repeat

28-02-2022 BCom(H) IT Practical File- BCom 113 54

 Step 3: Go to Header/Footer Tab → Select the Header
to add → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 55

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 56

 Step 1: Go to View Tab → Click on Freeze Panes
option → Choose the option as per preference

28-02-2022 BCom(H) IT Practical File- BCom 113 57

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 58

 P#13: Steps to set data validations and create
list using data validations

28-02-2022 BCom(H) IT Practical File- BCom 113 59

 Step 1: Select the cell where to create the list → Go to
Data Tab → Click on Data Validation option

28-02-2022 BCom(H) IT Practical File- BCom 113 60

 Step 2: Pop up will appear → In Allow menu, Select List option
→ In Source, select source for the list → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 61

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 62

 P#14: Steps to show / hide formula

28-02-2022 BCom(H) IT Practical File- BCom 113 63

 Step 1: Go to Formulas Tab → Click on Show
Formulas option to show or hide formulas

28-02-2022 BCom(H) IT Practical File- BCom 113 64

 RESULT

28-02-2022 BCom(H) IT Practical File- BCom 113 65

 P#15: Steps to protect sheet

28-02-2022 BCom(H) IT Practical File- BCom 113 66

 Step 1: Right Click on Worksheet → Click on Protect
Sheet option

28-02-2022 BCom(H) IT Practical File- BCom 113 67

 Step 2: Pop up will appear → Type password to protect
sheet → Select Features that unauthorized users are
allowed to use in worksheet → Click OK

28-02-2022 BCom(H) IT Practical File- BCom 113 68

 THE END

28-02-2022 BCom(H) IT Practical File- BCom 113 69