PPSC Proficiency Test CONCAT, LEFT, LEN & Rs. Symbol Functions in MS Excel Set-10

Описание: In this video, we solve PPSC Proficiency Test Past Paper – MS Excel (Set-10) focusing on essential text functions and currency formatting commonly asked in government proficiency exams.

You will learn how to use CONCAT and CONCATENATE to join text, LEFT to extract characters, LEN to count text length, and how to apply the Rs. (Pakistani Rupee) symbol correctly in Excel.

This lecture is designed for candidates preparing for PPSC, FPSC, NTS, and departmental computer proficiency tests, helping improve speed, accuracy, and confidence in the practical exam.

Watch the complete video to master exam-oriented Excel techniques and score better in your proficiency test.

Functions & Topics Covered in This Video:

✔ CONCAT function
✔ CONCATENATE function
✔ LEFT function
✔ LEN function
✔ Using the Rs. (Pakistani Rupee) symbol in Excel
✔ Text extraction and length checking techniques
✔ Currency formatting for exam worksheets



1. Use LEFT to extract the City Code (LHR, KHI, MUL) from ID Code.

2. Use LEN to check if CNIC No has exactly 13 digits.

3. Use CONCAT to join "ID Code" and "Name" with a hyphen in a new column.

4. Apply Accounting Format (Rs. symbol) to Basic Pay and EMI.

5. Create a Hyperlink on "STENO-LHR" to www.punjab.gov.pk.

6. Protect the sheet with password "ppsc123".


This video is specially designed for:

PPSC Proficiency Test candidates

Data Entry Operator exams

Junior Clerk / Senior Clerk tests

Office Assistant & Stenotypist exams

FPSC, NTS & departmental computer tests

All tasks are demonstrated exactly according to past paper patterns, helping candidates improve speed, accuracy, and confidence during the practical exam.

Watch till the end to fully master Excel text functions and currency formatting required in government exams.

#PPSCProficiencyTest
#PPSCExcel
#PPSCPastPaper
#CONCAT
#CONCATENATE
#LEFT
#LEN
#MSExcel
#ExcelFunctions
#ExcelPractical
#ExcelProficiencyTest


Dear Viewers,
You are watching “AbMaroofDevDive” YouTube Channel. You can subscribe “@AbMaroofDevDive” Channel for the latest Important Videos in the Future. “Channel Link
@AbMaroofDevDive