Assignment-Status

Roll Number	T/B/D+/5706/IN
Students's Name	NISHA SHARMA
Batch Time	03:00 to 04: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	17/03/2024
Number of Attempts	2
ASGMT Examiner	Arpit Singh
Approval Status	Approved
Status/Download

IT Courses / Accounting Courses