Scribd
Upload
8 views10 pages

70 Excel Formula Practice File

The document contains various data sets including student scores in different subjects, names formatted in uppercase and proper case, and a list of items with their unit rates. It also includes task schedules with start and end dates, as well as age calculations based on birth dates. Additionally, there are links to websites associated with each item listed.

Uploaded by

Suman Bag
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views10 pages

70 Excel Formula Practice File

The document contains various data sets including student scores in different subjects, names formatted in uppercase and proper case, and a list of items with their unit rates. It also includes task schedules with start and end dates, as well as age calculations based on birth dates. Additionally, there are links to websites associated with each item listed.

Uploaded by

Suman Bag
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

ID Student Name Hindi Eng Math Total % Division Remarks Rank

1001 Neha 70 98 97
1002 Nishi 34 62 97
1003 Aradhya 23 66 86
1004 Anchal 45 42 83
1005 batu 27 98 25
1006 Bhavya 46 83 37
1007 Deepika 45 90 45
NAME UPPERCASE lowercase
Mohan Kumar Sharma
Bhavya S Vajpai
Rohit Dev Verma
Mohan Kumar Singh
Neha Raj Gupta
Khushi G Vajpai
Mohan Kumar Mishra
Achyutam Kumar Mishra
Proper Case

Mohan dev 1
Bhavya Vajpai 2
Shruti Vajpai 4
Priya Mishra 9
Riya Sharma 7
Mohan dev 1
Bhavya Vajpai 2
Shruti Vajpai 4
Priya Mishra 9
Riya Sharma 7
FIND, REPLACE & SUBSTITUTE FUCTION

Mohan Kumar Sharma 2024 CCC CTA


Bhavya S Vajpai 2024 MS OFFICE CTA
Rohit Dev Verma 2024 TALLY PRIME CTA
Mohan Kumar Singh 2024 Tally ERP 9 CTA
Neha Raj Gupta 2024
Khushi G Vajpai 2024 CS@1001@2024
Mohan Kumar Mishra 2024 CS@1002@2024
Achyutam Kumar Mishra 2024 CS@1003@2024
CS@1004@2024
CS@1005@2024
ITEM UNIT RATE Total [Link] Youtube
Monitor 20 4000 [Link] Google
Printer 41 5500 [Link] Facebook
Keyboard 52 180 [Link] Instagram
Speaker 63 2999
Light Pen 74 4500
Mic 85 ###

Year Month Day Date


2024 9 25
2024 10 24
2025 1 4
2025 1 5

Date Day Month year


9/10/2023
8/15/2024
1/2/2025
1/6/2025
Task Start date Duration (Working days) Task End Date Holiday
Task 1 1/1/2025 15 1/13/2025
Task 2 1/2/2025 5 1/14/2025
Task 3 1/5/2025 6
Task 4 1/15/2025 21

Task Start date Task End Date total days Date


Task 1 1/1/2025 1/25/2025 1/1/2025
Task 2 1/2/2025 1/16/2025 3/2/2025
Task 3 1/5/2025 2/2/2025 1/5/2025
Task 4 1/15/2025 1/28/2025 2/15/2025
1/1/2025
Policy Issue Date Next Renue after 3 mon. 1/2/2025
1/25/2025 1/5/2025
1/16/2025
2/2/2025
1/28/2025
1/25/2025
1/16/2025
2/2/2025
start date of month
1/1/2025
3/1/2025
1/1/2025
2/1/2025
1/1/2025
1/1/2025
1/1/2025
Name Birth date Today Total Age
Name 1 1/1/1999 1/1/2025
Name 2 1/2/1998 1/2/2025
Name 3 10/5/2002 1/5/2025
Name 4 12/15/2005 1/15/2025

You might also like