Quiz Questions On Microsoft Excel And Access!

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Edisongotan
E
Edisongotan
Community Contributor
Quizzes Created: 4 | Total Attempts: 4,738
Questions: 41 | Attempts: 246

SettingsSettingsSettings
Quiz Questions On Microsoft Excel And Access! - Quiz

.


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

    Correct Answer
    C. 65536
    Explanation
    The maximum number of rows in Microsoft Excel 2003 is 65536. This means that Excel 2003 can have up to 65536 rows of data in a single worksheet.

    Rate this question:

  • 2. 

    What is the first spreadsheet application created by Microsoft before Excel?

    Correct Answer
    Multiplan
    Multi-plan
    Microsoft Multiplan
    Explanation
    Multiplan is the correct answer because it was the first spreadsheet application created by Microsoft before Excel. It was released in 1982 and was initially developed for CP/M operating system. Multiplan was later replaced by Excel, which was introduced in 1985 and became the dominant spreadsheet application.

    Rate this question:

  • 3. 

    In Microsoft Access, each table has a unique key called what?

    Correct Answer
    primary key
    Explanation
    In Microsoft Access, each table has a unique key called a primary key. The primary key is used to uniquely identify each record in the table. It ensures that there are no duplicate records and allows for efficient searching and sorting of data. The primary key can be a single field or a combination of fields, and it is essential for maintaining data integrity and establishing relationships between tables.

    Rate this question:

  • 4. 

    What is the data type if you want it to increment automatically?

    Correct Answer
    auto-number
    autonumber
    Explanation
    The correct answer is "auto-number" or "autonumber". This data type is used when you want a field to automatically increment its value. It is commonly used in databases to assign a unique identifier to each record without manual input. By using this data type, the system will automatically generate and assign a new number to each new record, ensuring that each record has a unique identifier.

    Rate this question:

  • 5. 

    Database application of Microsoft Office?

    Correct Answer
    Access
    Microsoft Access
    MS Access
    Explanation
    Access, Microsoft Access, and MS Access are all correct answers for the question "Database application of Microsoft Office?" This is because Access is a database management system (DBMS) that is part of the Microsoft Office suite. It allows users to create and manage databases, build forms and reports, and perform data analysis and queries. Microsoft Access and MS Access are alternative names for the same software, so all three options are valid answers to the question.

    Rate this question:

  • 6. 

    Latest version of Microsoft Access for Windows?

    Correct Answer
    2007
    Explanation
    The latest version of Microsoft Access for Windows is 2007.

    Rate this question:

  • 7. 

    Maximum numbers of column in Microsoft Excel 2003?

    Correct Answer
    256
    Explanation
    Microsoft Excel 2003 has a maximum limit of 256 columns. This means that you can have a total of 256 columns in a single worksheet. This limitation is specific to Excel 2003 and later versions have increased the number of columns available.

    Rate this question:

  • 8. 

    CSV stands for? (Without dash)

    Correct Answer
    Comma Separated Value
    Explanation
    CSV stands for Comma Separated Value. It is a file format used to store and exchange data in a tabular form, where each value is separated by a comma. CSV files are commonly used for importing and exporting data between different applications, such as spreadsheets and databases, due to their simplicity and compatibility with various software.

    Rate this question:

  • 9. 

    Default file extension of Microsoft Excel 2003 Workbook?

    Correct Answer
    xls
    .xls
    Explanation
    The default file extension for Microsoft Excel 2003 Workbook is xls. This file extension is used to indicate that the file is a workbook created using Excel 2003. The .xls extension is widely recognized and compatible with various versions of Excel, making it the default choice for saving Excel 2003 workbooks.

    Rate this question:

  • 10. 

    Default file extension of Microsoft Excel 2007 Workbook?

    Correct Answer
    xlsx
    .xlsx
    Explanation
    The default file extension for Microsoft Excel 2007 Workbook is xlsx. This extension is used to identify files that are created and saved in the Microsoft Excel 2007 format. The ".xlsx" extension indicates that the file is a workbook created using Excel 2007 or a later version. The second option, ".xlsx", is redundant and unnecessary as it is already covered by the first option. Therefore, the correct answer is xlsx.

    Rate this question:

  • 11. 

    Default file extension of Microsoft Access 2003?

    Correct Answer
    mdb
    .mdb
    Explanation
    The default file extension for Microsoft Access 2003 is "mdb". This file extension is used to identify and open Access database files in the 2003 version of the software. The ".mdb" extension is commonly associated with Access databases and allows users to easily recognize and access their database files.

    Rate this question:

  • 12. 

    Term used to link tables in Microsoft Access database?

    Correct Answer
    relationship
    Explanation
    In Microsoft Access database, the term "relationship" is used to link tables. This means that the tables are connected to each other based on a common field or key. By establishing relationships between tables, it becomes easier to retrieve and analyze data from multiple tables simultaneously. This allows for efficient data management and avoids data duplication.

    Rate this question:

  • 13. 

    Maximum capacity of Microsoft Access 2003? (How many GB?)

    Correct Answer
    2
  • 14. 

    Alternative to Microsoft Office products that was created by Oracle (Sun Microsystems)?

    Correct Answer
    OpenOffice.org
    Open Office
    Star Office
    StarOffice
    Open Office.org
    Explanation
    The alternative to Microsoft Office products that was created by Oracle (Sun Microsystems) is OpenOffice.org, also known as Open Office. Another alternative is Star Office, which was also developed by Sun Microsystems. These software suites provide similar functionality to Microsoft Office, including word processing, spreadsheet, presentation, and database applications. OpenOffice.org and Star Office offer a free and open-source alternative to Microsoft Office, allowing users to create and edit documents without the need for purchasing a license.

    Rate this question:

  • 15. 

    Used to create graphical representation of data in Microsoft Excel?

    Correct Answer
    Chart
    Chart Wizard
    Explanation
    The correct answer is "Chart, Chart Wizard". In Microsoft Excel, a chart is used to create a graphical representation of data. It helps to visualize and analyze data trends and patterns. The Chart Wizard is a tool in Excel that guides users through the process of creating a chart. It provides various options and customization settings to create visually appealing and informative charts.

    Rate this question:

  • 16. 

    Can Excel export files directly to PDF?

    • A.

      Yes

    • B.

      No

    Correct Answer
    B. No
    Explanation
    Excel does not have a built-in feature to directly export files to PDF. However, there are alternative methods to convert Excel files to PDF format, such as using third-party add-ins or using the "Save As" option and selecting PDF as the file format. Therefore, the correct answer is "No".

    Rate this question:

  • 17. 

    Used to copy the formatting of text or cell in Microsoft Excel?

    Correct Answer
    Format Painter
    Explanation
    The Format Painter tool in Microsoft Excel is used to copy the formatting of text or cells. It allows users to quickly apply the same formatting, such as font style, size, color, and cell borders, to other cells or ranges within the worksheet. This tool saves time and effort by eliminating the need to manually format each cell individually. By selecting a cell with the desired formatting and using the Format Painter tool, users can easily apply that formatting to other cells with a single click.

    Rate this question:

  • 18. 

    In Microsoft Excel, the Increase Decimal and Decrease Decimal button is located in what toolbar?

    Correct Answer
    Formatting Toolbar
    Formatting
    Explanation
    The Increase Decimal and Decrease Decimal buttons in Microsoft Excel are used to adjust the number of decimal places displayed in a cell. These buttons are located in the Formatting Toolbar, which is a toolbar that contains various formatting options for cells, such as font style, size, alignment, and borders. Therefore, the correct answer is Formatting Toolbar.

    Rate this question:

  • 19. 

    What is the default page orientation in Microsoft Excel?

    Correct Answer
    portait
    Explanation
    The default page orientation in Microsoft Excel is portrait. This means that the page is set up vertically, with the longer side of the paper running from top to bottom. This is the standard orientation for most documents and is commonly used for printing and viewing spreadsheets in Excel.

    Rate this question:

  • 20. 

    What is the default number of Worksheet in a new Microsoft Excel Workbook?

    Correct Answer
    3
    Explanation
    The default number of worksheets in a new Microsoft Excel Workbook is 3. This means that when you open a new workbook in Excel, it will automatically have three blank worksheets for you to work with. These worksheets can be used to organize and analyze data in separate tabs within the workbook.

    Rate this question:

  • 21. 

    Used to get the sum of multiple cells' value using one button in Microsoft Excel?

    Correct Answer
    AutoSum
    Explanation
    AutoSum is a feature in Microsoft Excel that allows users to quickly calculate the sum of multiple cells' values by using a single button. It automatically selects a range of cells based on the adjacent data and inserts the SUM function to calculate the total. This saves time and effort for users who need to perform frequent summations in their spreadsheets.

    Rate this question:

  • 22. 

    In Microsoft Excel, what is the default category in Format Cell?

    Correct Answer
    General
    Explanation
    The default category in Format Cell in Microsoft Excel is General. This category is used for general formatting and does not apply any specific formatting to the cell. It is the most basic format category and is typically used for displaying numbers and text in their default format without any additional formatting options applied.

    Rate this question:

  • 23. 

    What is the name of the first cell from the upper left in Microsoft Excel?

    Correct Answer
    A1
    Explanation
    A1 is the correct answer because in Microsoft Excel, cells are identified by a combination of a letter and a number. The letter represents the column, and the number represents the row. A1 refers to the first cell in the first column and first row, which is the cell located in the upper left corner of the spreadsheet.

    Rate this question:

  • 24. 

    In Microsoft Excel, Sort Ascending and Sort Descending is located in what toolbar:

    Correct Answer
    Standard Toolbar
    Standard
    Explanation
    Sort Ascending and Sort Descending options in Microsoft Excel are located in the Standard Toolbar. The Standard Toolbar is a common toolbar in Excel that contains various commands and functions for managing and formatting data. It provides quick access to commonly used tools, including sorting options. Therefore, the correct answer is Standard Toolbar.

    Rate this question:

  • 25. 

    Function used to get the maximum number in the selection of cells in Microsoft Excel?

    Correct Answer
    Max
    Explanation
    The function "Max" is used to find the maximum number in a selection of cells in Microsoft Excel. It takes multiple arguments and returns the largest value among them. By using this function, users can easily identify the highest value within a range of cells, which can be useful for various calculations and data analysis tasks.

    Rate this question:

  • 26. 

    Web alternative to Microsoft Word or Excel created by Google?

    Correct Answer
    Google Docs
    Docs
    Explanation
    Google Docs is a web-based alternative to Microsoft Word or Excel created by Google. It allows users to create, edit, and collaborate on documents, spreadsheets, and presentations online. With Google Docs, multiple users can work on the same document simultaneously, making it a convenient tool for teamwork and remote collaboration. It also offers cloud storage, automatic saving, and easy sharing options. Overall, Google Docs provides a free and accessible platform for creating and managing various types of documents online.

    Rate this question:

  • 27. 

    Used to create link in Microsoft Excel?

    Correct Answer
    Hyperlink
    Hyperlink button
    Explanation
    In Microsoft Excel, the "Hyperlink" and "Hyperlink button" options are used to create links. A hyperlink is a clickable element that allows users to navigate to a different location within the workbook, to a different file, or to a website. The "Hyperlink" option allows users to directly insert a hyperlink into a cell or a shape, while the "Hyperlink button" is a toolbar button that provides a quick way to create and manage hyperlinks. Both options serve the same purpose of creating links in Excel.

    Rate this question:

  • 28. 

    Used to put notes in Microsoft Excel?

    Correct Answer
    Comment
    Comments
    Explanation
    In Microsoft Excel, the "Comment" and "Comments" options are used to put notes or annotations on specific cells or ranges. These notes can provide additional information or explanations about the data in the cell, making it easier for others to understand and interpret the spreadsheet. By using comments, users can add context or reminders without affecting the actual data or calculations in the worksheet. The "Comment" option is used to insert a single comment on a selected cell, while the "Comments" option allows for multiple comments to be inserted on different cells.

    Rate this question:

  • 29. 

    Used to link another table to the current one with primary key?

    Correct Answer
    Foreign Key
    Explanation
    A foreign key is used to link another table to the current one with a primary key. It is a field or a combination of fields in a table that refers to the primary key of another table. This establishes a relationship between the two tables, allowing data to be shared and referenced between them. The foreign key ensures data integrity by enforcing referential integrity constraints, meaning that the values in the foreign key column must match the values in the primary key column of the referenced table.

    Rate this question:

  • 30. 

    Place where you can see the data of your cell?

    Correct Answer
    Formula Bar
    Explanation
    The formula bar is the place where you can see the data of your cell. It is located at the top of the Excel window, just below the ribbon. The formula bar displays the contents of the selected cell, including any formulas or data entered into it. It allows you to view and edit the contents of the cell, making it a useful tool for working with data in Excel.

    Rate this question:

  • 31. 

    Used to filter data and get specific fields in Microsoft Access?

    Correct Answer
    Queries
    Explanation
    Queries in Microsoft Access are used to filter and retrieve specific data from a database. They allow users to define criteria and conditions to extract the desired information from one or more tables. By specifying fields, sorting orders, and filtering conditions, queries can efficiently retrieve the required data, eliminating the need to manually search through large amounts of data. Therefore, queries are an essential tool in Microsoft Access for data analysis and reporting purposes.

    Rate this question:

  • 32. 

    Default text length in Microsoft Access 2003?

    Correct Answer
    50
    Explanation
    The default text length in Microsoft Access 2003 is 50 characters. This means that when creating a text field in a database table, the maximum number of characters allowed in that field is set to 50 by default. However, this default length can be changed or customized based on the specific needs of the database design.

    Rate this question:

  • 33. 

    In Microsoft Access, the Relationship is located in what Menu?

    Correct Answer
    Tools
    Explanation
    In Microsoft Access, the Relationship feature can be found in the "Tools" menu. This menu provides various tools and options for managing and organizing the database, including the ability to define relationships between tables. By selecting the "Tools" menu, users can access the Relationship feature and establish connections between tables, which helps in maintaining data integrity and improving data analysis capabilities.

    Rate this question:

  • 34. 

    Used to put text or content in all top and bottom part of pages in Microsoft Word or Excel?

    Correct Answer
    Header and Footer
    Explanation
    Header and Footer is a feature in Microsoft Word or Excel that allows users to insert text or content at the top and bottom of each page. This feature is commonly used to display information such as page numbers, document title, author name, date, and other relevant details that need to be consistent throughout the document. By using the Header and Footer feature, users can easily add and customize these elements, ensuring a professional and organized appearance for their documents.

    Rate this question:

  • 35. 

    Used to check for spelling and other errors?

    Correct Answer
    Spell Checker
    Explanation
    A spell checker is a tool or software used to identify and correct spelling errors in written text. It helps to ensure that words are spelled correctly and can also detect other errors such as incorrect grammar, punctuation, and capitalization. This tool is commonly used in word processing software, email clients, and web browsers to improve the accuracy and readability of written content. By highlighting and suggesting corrections for misspelled words, a spell checker helps users produce error-free and professional-looking documents.

    Rate this question:

  • 36. 

    Default data type for Foreign Key?

    Correct Answer
    Number
    Explanation
    The default data type for a foreign key is typically a number. This is because foreign keys are used to establish a relationship between two tables in a database, where the primary key of one table is referenced in another table. The primary key is usually a numeric value, and therefore the foreign key data type is also set as a number to match the primary key data type. This allows for efficient indexing and querying of the related data.

    Rate this question:

  • 37. 

    Microsoft Excel was created initially for what Operating System?

    Correct Answer
    Mac
    Macintosh
    Explanation
    Microsoft Excel was initially created for the Macintosh operating system. The software was developed by Microsoft specifically for Mac users, providing them with a powerful tool for creating spreadsheets and performing data analysis. The early versions of Excel were exclusively available for Macintosh computers before Microsoft eventually released versions for other operating systems such as Windows.

    Rate this question:

  • 38. 

    To replace multiple instances of a text or data, you can use what feature of Microsoft Excel?

    Correct Answer
    Find and Replace
    Replace
    Explanation
    To replace multiple instances of a text or data in Microsoft Excel, you can use the "Find and Replace" feature. This feature allows you to search for a specific text or data and replace it with another value throughout the entire worksheet or selected range. By using this feature, you can quickly and efficiently make changes to multiple cells or formulas without manually editing each one individually. The "Replace" option is a part of the "Find and Replace" feature, which specifically replaces the searched text or data with a new value.

    Rate this question:

  • 39. 

    What is the color of Microsoft Excel?

    Correct Answer
    Green
    Explanation
    Microsoft Excel is commonly associated with the color green because the default color scheme used in Excel has a green color theme. This includes the green color used for the Excel logo and various elements within the software interface. Additionally, the green color is often used to represent financial data and calculations, which are commonly performed in Excel. Therefore, the color green is closely associated with Microsoft Excel.

    Rate this question:

  • 40. 

    Can you save an Excel Worksheet to a webpage?

    • A.

      Yes

    • B.

      No

    Correct Answer
    A. Yes
    Explanation
    Yes, you can save an Excel Worksheet to a webpage. Excel provides the option to save a worksheet as a webpage, which converts the worksheet into an HTML file that can be viewed and accessed through a web browser. This allows users to share and publish their Excel data on the web, making it accessible to a wider audience. By saving as a webpage, the Excel worksheet retains its formatting, formulas, and other features, ensuring that the data is accurately represented on the webpage.

    Rate this question:

  • 41. 

    Used to fill the text / cell with background color?

    Correct Answer
    Fill Color
    Explanation
    The term "Fill Color" refers to the action of filling a text or cell with a background color. It is a feature commonly found in various software applications, such as word processors or spreadsheet programs, that allows users to enhance the visual appearance of their documents or data by adding color to specific areas. By selecting the "Fill Color" option, users can choose from a range of colors to apply as the background color for the selected text or cell.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 03, 2010
    Quiz Created by
    Edisongotan
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.