Trivia Questions On Microsoft Excel And Access!

50 Questions | Total Attempts: 44

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

Microsoft Excel and Access are one of the most used applications in the world today. Both Microsoft Excel and Microsoft Access help in analyzing large amounts of information and manage related data. The quiz below is the first one on IT 2 class, and it covers what we learned Microsoft Excel and Access. Take it up and see just how much you understood.


Questions and Answers
  • 1. 
    What is the maximum number of rows in Microsoft Excel 2003?
    • A. 

      65535

    • B. 

      65555

    • C. 

      65536

    • D. 

      65545

    • E. 

      65575

  • 2. 
    What is the first spreadsheet application created by Microsoft before Excel?
  • 3. 
    What is the latest version of Microsoft Excel for Mac?
  • 4. 
    What is the latest version of Microsoft Excel for Windows?
  • 5. 
    In Microsoft Access, each table has a unique key called what?
  • 6. 
    What is the data type if you want it to increment automatically?
  • 7. 
    Database application of Microsoft Office?
  • 8. 
    Latest version of Microsoft Access for Windows?
  • 9. 
    Maximum numbers of column in Microsoft Excel 2003?
  • 10. 
    CSV stands for? (Without dash)
  • 11. 
    Default file extension of Microsoft Excel 2003 Workbook?
  • 12. 
    Default file extension of Microsoft Excel 2007 Workbook?
  • 13. 
    Default file extension of Microsoft Access 2003?
  • 14. 
    Term used to link tables in Microsoft Access database?
  • 15. 
    Maximum capacity of Microsoft Access 2003? (How many GB?)
  • 16. 
    Alternative to Microsoft Office products that was created by Oracle (Sun Microsystems)?
  • 17. 
    Used to create graphical representation  of data in Microsoft Excel?
  • 18. 
    Can Excel export files directly to PDF?
    • A. 

      Yes

    • B. 

      No

  • 19. 
    What is the maximum attachment in Yahoo! Mail? (In MB, input numbers only)
  • 20. 
    Used to copy the formatting of text or cell in Microsoft Excel?
  • 21. 
    In Microsoft Excel, the Increase Decimal and Decrease Decimal button is located in what toolbar?
  • 22. 
    What is the default page orientation in Microsoft Excel?
  • 23. 
    What is the default number of Worksheet in a new Microsoft Excel Workbook?
  • 24. 
    Used to get the sum of multiple cells' value using one button in Microsoft Excel?
  • 25. 
    In Microsoft Excel, what is the default category in Format Cell?
  • 26. 
    What is the name of the first cell from the upper left in Microsoft Excel?
  • 27. 
    In Microsoft Excel, Sort Assending and Sort Decending is located in what toolbar?
  • 28. 
    Function used to get the maximum number in the selection of cells in Micrsooft Excel?
  • 29. 
    Web alternative to Microsoft Word or Excel created by Google?
  • 30. 
    Used to create link in Microsoft Excel?
  • 31. 
    Used to put notes in Microsoft Excel?
  • 32. 
    Used to link another table to the current one with primary key?
  • 33. 
    Place where you can see the data of your cell?
  • 34. 
    Used to filter data and get specific fields in Microsoft Access?
  • 35. 
    Default text length in Microsoft Access 2003?
  • 36. 
    In Microsoft Access, the Relationship is located in what Menu?
  • 37. 
    Used to put text or content in all top and bottom part of pages in Microsoft Word or Excel?
  • 38. 
    What is the web browser created by Google?
  • 39. 
    What is the web browser created by Mozilla?
  • 40. 
    What is the web browser created by Apple?
  • 41. 
    Used to check for spelling and other errors?
  • 42. 
    Default data type for Foreign Key?
  • 43. 
    Microsoft Excel was created initially for what Operating System?
  • 44. 
    Latest product from Apple that looks like a large version of iPod?
  • 45. 
    To replace multiple instances of a text or data, you can use what feature of Microsoft Excel?
  • 46. 
    What is the color of Microsoft Excel?
  • 47. 
    Can you save an Excel Worksheet to a webpage?
    • A. 

      Yes

    • B. 

      No

  • 48. 
    Used to fill the text / cell with background color?
  • 49. 
    What is the upcoming version of Microsoft Excel this year?
  • 50. 
    Is Microsoft Office included as part of Windows?