Delhi Technological University
Delhi School Of Management
Data Analytics Lab Record
MBA-115
Session: 2024-25
Submitted To: Submitted By:
Miss Priya Ishika Dalal
24/DMBA/101
INDEX
1. Absolute and Relative Refrencing
2. Sorting & Filter
3. SUBTOTAL
4. SUMIFS
5. COUNTIFS, Goal seek
6. SUM, MAX, MIN
7. VLookup, HLookup
8. If, Nested If
9. Macros, Conditional Formatting
Class Assignments
MARKS AWARDED
FORMULA
SUBJECT WISE
STUDENT WISE
BMI Calculator
Average
Charts, V-Lookup,H-Lookup
If
v Charts
PIVOT TABLE
Nested If and AND, OR
Definition
BMI Calculator: A custom formula or tool in Excel to calculate Body Mass Index
using weight and height.
VLOOKUP: Searches for a value in the first column of a range and returns a
value in the same row from another column.
HLOOKUP: Searches for a value in the first row of a range and returns a value in
the same column from another row.
Charts: Visual representations of data in Excel (e.g., bar, line, pie charts).
IF: Performs a logical test and returns different values based on whether the
condition is TRUE or FALSE.
SUM: Adds a range of numbers or values.
AVERAGE: Calculates the arithmetic mean of a range of numbers.
SUBTOTAL: Returns the subtotal of a range, depending on the specified
function (e.g., SUM, AVERAGE).
COUNTIF: Counts the number of cells in a range that meet a specified
condition.
SUMIF: Adds numbers in a range based on a specified condition.
MAX: Returns the largest value in a range.
MIN: Returns the smallest value in a range.
AND: Returns TRUE if all conditions are TRUE.
OR: Returns TRUE if at least one condition is TRUE.
COUNT: Counts the number of numeric entries in a range.
LEFT: Extracts a specified number of characters from the start of a text string.
RIGHT: Extracts a specified number of characters from the end of a text string.
MID: Extracts a specific number of characters from a text string, starting at a
given position.
UPPER: Converts text to uppercase.
PROPER: Capitalizes the first letter of each word in a text string.
LOWER: Converts text to lowercase.
TRIM: Removes extra spaces from text except for single spaces between words.
FIND: Returns the position of a substring within a text string (case-sensitive).
REPLACE: Replaces part of a text string with another string based on position.
Nested IF: Combines multiple IF functions to test several conditions.
Pivot Table: Summarizes and analyzes data interactively by rows and columns.
Pivot Chart: Visual representation of a pivot table.
Solver: Solves optimization problems by finding the best solution for a formula
under constraints.
Macros: Automates repetitive tasks by recording and executing a set of
instructions.
Advanced Filter: Filters data based on complex criteria beyond standard filters.
Goal Seek: Adjusts a value in a cell to achieve a desired outcome in a formula.
Scenario: Compares different sets of input values to see various outcomes.
