Assignment-Status

Assignment ID	ASSI/3404637/IN
Roll Number	T/B/D+/5754/IN
Students's Name	ANUJ SINGH
Batch Time	04:00 to 05: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?
Number of Attempts	No Attempt
ASGMT Examiner	Lab Assistant
Approval Status	Unapproved
Status/Download

IT Courses / Accounting Courses