Roll NumberT/B/D+/6195/IN
Students's NameVINAY PRATAP SINGH
Batch Time04:00 to 05:00 PM
Excel AssignmentExcel Assignment-3
Microsoft Excel Assignment -3 Questions
  • 1. How to remove grid lines from sheet?
  • 2. How to insert word Art in M S Excel?
  • 3. What is database explain?
  • 4. How many types of databases in M S Excel?
  • 5. How many types of filters in M S Excel explain Each?
  • 6. How to filter table data with or without Heading?
  • 7. How filter table data result in different location?
  • 8. How to filter data using AND/OR condition?
  • 9. How to remove filter?
  • 10. Give the syntax of D-function with Example?
  • 11. How to apply D-function in a sheet?
  • 12. Write down the benefits of pivot table?
  • 13. What is data validation explain With Example?
  • 14. How to assign text validation with input/error Alert Massage?
  • 15. How to assign date validation with input/error Alert Massage?
  • 16. How to assign number validation with input/error Alert Massage?
  • 17. How to Assign list validation in M S Excel.
  • 18. How to Sort Excel Sheet data?
  • 19. How to apply subtotal in a sheet?
  • 20. Write down the importance of chart in M S Excel?
ASGMT Submit Date16/06/2025
Number of Attempts1
ASGMT ExaminerRitik Savita
Approval StatusApproved
Status/Download

  • Status Unapproved means your Assignment in progress.
  • Status Approved means your Assignment is Complete.
  • Status Disapproved means Assignment is not Complete by Students.
  • You can download your Assignment in PDF when status shows Approved.