Worksheet No.
: 4
Student Name: Ashish Verma UID: 23MCA20502
Branch: MCA Section/Group: 8A
Semester: 3rd Date of Performance: 5-09-24
Subject Name: BUSINESS ANALYTICS Subject Code: 23CAH-701
Aim of the practical:
a) Assign a name to a range of cells to make it easier to reference those ranges in
calculations, create a drop-down menu to make data entry quicker and more efficient.
b) Use sort and filter to find and organize data in large databases, custom filters.
Objective : CO1: Apply the concepts and components of Data Analytics.
Data :
15
Steps to create CHARTS :
1. Bar Graph : A column chart is similar to a bar chart but is best used for
data presented in columns rather than rows.
To create a column chart in Excel:
➢ Go to the “insert tab on the Excel ribbon
➢ Create a pivot table
➢ After that create the bar from the ribbon
➢ Give the title Name yaxis name , x axis name and labels.
16
2. Pie Chart: A pie chart is used to show the proportions of different parts
to a whole.
To create a pie chart in Excel:
· Go to the "Insert" tab on the Excel ribbon.
· Create a pivot table.
· Click on the "Pie" chart icon and choose the desired pie chart type.
Freezing Panes: The "Freeze Panes" feature allows you to keep specific rows and/or
columns visible on the screen while you scroll through a large dataset. This is particularly
helpful when you want to keep header rows or important information visible at all times.
To freeze panes in Excel:
1. Open the Excel workbook containing the dataset you want to freeze panes in.
17
2. Select the cell below the row you want to freeze and to the right of the column you
want to freeze. For example, if you want to freeze the first row and the first column,
select cell B2.
3. Go to the "View" tab on the Excel ribbon.
4. Click on the "Freeze Panes" dropdown button in the "Window" group.
5. Select one of the following options based on your preference:
• "Freeze Panes": This option freezes both rows and columns based on your
selection. Rows above and columns to the left of the selected cell will be
frozen.
• "Freeze Top Row": This option freezes only the top row, keeping it visible as
you scroll down the sheet.
• "Freeze First Column": This option freezes only the first column, keeping it
visible as you scroll to the right.
• "Freeze Panes": This option unfreezes any previously frozen panes, allowing
you to set new ones.
After selecting the desired option, the selected rows and columns will be frozen, and you
can scroll through the sheet while keeping the specified rows and/or columns visible
As you can see we have freezed our first column I.e. Name
18
Learning outcomes (What I have learnt):
⚫ Learnt to freeze the row and column.
⚫ Learn to give the titile ,label etc in in grah or chart
⚫ Learnt to share the excel file
Evaluation Grid (To be created as per the SOP and Assessment guidelines by the faculty):
Sr. No. Parameters Marks Obtained Maximum Marks
1. Worksheet 8 Marks
2. Viva 10 Marks
3. Simulation 12 Marks
Total 30 Marks
Teacher Signature
19
