Assignment

Roll Number	T/B/D+/6186/IN
Students's Name	YUVRAJ SINGH
Batch Time	02:00 to 03:00 PM
Excel Assignment	Excel Assignment-2
Microsoft Excel Assignment -2 Questions	1. How many types of cell references in M.S Excel? 2. Write down the importance of function with example? 3. Give the syntax of the following A. SUM () B. DATE () C. COUNT () D. AVERAGE () 4. Explain text function with example? 5. Give the syntax of the following text function? A. MID() B. LEFT() C. LEN() D. REPT() 6. Types of operator in M.S Excel explain each? 7. What is logical function explain with example? 8. Write down the syntax of Sumif function? 9. What is auto fill explain with example? 10. What is data validation and how to apply it? 11. How to create list validation? 12. How to assign input message and error alert in data validation? 13. What is range and range name? 14. How many ways to create range name explain each? 15. How to create non continuous range name? 16. How to check range name? 17. How to delete range name? 18. How to edit range name? 19. How to refer another sheet of the same workbook? 20. How to refer the worksheet in another workbook?
ASGMT Submit Date	23/06/2025
Number of Attempts	1
ASGMT Examiner	Ritik Savita
Approval Status	Approved
Status/Download
ASGMT Submit Date	23/06/2025
ASGMT Examiner	Ritik Savita
Number of Attempts to complete ASGMT	1

IT Courses / Accounting Courses