Assignment-Status

Roll Number	T/B/D+/6122/IN
Students's Name	AYUSH YADAV
Batch Time	11:00 to 12:00 AM
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	09/02/2025
Number of Attempts	Absent
ASGMT Examiner	Vikrant Raikwar
Approval Status	Disapproved
Status/Download

IT Courses / Accounting Courses