DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
1)Use the aggregate functions Sum ,Average, Max and Min,Count and CountIf for the given table in
Excel.
a)Calculate the total salary of all employees.
b)Find the average salary of employees.
c)Find largest and lowest salary within a table.
d)Count the number of employees in the "Sales" department.
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
2)Use Sorting anf Filtering options find the calculations and result using following data.
a)Sort the Sales column to find the highest Sales Value.
b) Filter the "Region" column to display only the data for the "East" region.
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
3) Create a table with employee information it should contains the following fields, EmployeeName,
Department, Salary, Hire Date and you want to ensure that the "Hire Date" column only accepts
dates within a specified range.
a)Apply Data Validation to the "Hire Date" column to ensure that only dates between January 1,
2018, and December 31, 2022, are accepted.
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
4) Create a dataset related to engineering project tasks and the time spent on each task by different
team members
a)Create a pivot table for the below table to analyze this engineering project data.
b)Create the pivort chart for the created pivot table.
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
5)Use the Text Functions
a)UPPER and LOWER-write the Upper of the word “Visualisation” and lower of the word “EMPATHY”
using text function.
b)Trim-Trim the word” Good Morning” in another cell using text function.
c)Concatenate the words “Data” and “Analytics” using concatenate text function.
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
6) Construction project management task. You have data related to the project's budget, resource
allocation, and task tracking that needs to be organized, analyzed, and reported on.
a)Create a new Excel workbook for the project management.
b)Make first sheet, as "Budget," enter project expenses, allocations, and categories
c)Make second sheet, as "Tasks," enter a list of project tasks, assigned team members, deadlines, and
statuses.
d)Make the third sheet, as "Reports," for generating summaries and charts.
e)Use formulas to link and summarize data from the "Budget" and "Tasks" sheets and Calculate the
total project cost in sheet 3 .
f)Calculate the number of tasks in progress in sheet 3.
g)Create Pie chart for budget distribution using budget category and allocation.
DEPARTMENT OF INFORMATION SCIENCE AND ENGINEERING
DA LAB Questions
7) Create worksheet with following fields: Empno, Ename, Basic Pay (BP), Travelling Allowance (TA),
Dearness Allowance (DA), House Rent Allowance (HRA), Income Tax (IT), Provident Fund (PF), and
Net Pay (NP). Use appropriate formulas to calculate the above scenario. Analyze the data using
appropriate chart.
HINT:-
Income Tax=“=0.10*(BP+TA+DA+HRA)”
Provident Fund=“=0.08*(BP+TA+DA+HRA)”
Net Pay=“=(BP + TA + DA + HRA) - IT – PF”
a)Analyse the data after finding Income Tax,Provident Fund and Net Pay Using Clustered bar chart.